class Census1861

Up: class CensusLine

Source Code

This table is used to contain transcriptions of the population census of the 1861 census of Canada.

CREATE TABLE `Census1861` (
`Province` CHAR(2) NOT NULL,
`District` INT(11) NOT NULL,
`SubDistrict` VARCHAR(8) NOT NULL DEFAULT '',
`Division` VARCHAR(4) NOT NULL DEFAULT '',
`Page` INT(11) NOT NULL,
`Line` INT(11) NOT NULL,
`PageDisp` VARCHAR(4) DEFAULT NULL,
`Family` CHAR(4) NOT NULL,
`Surname` VARCHAR(120) DEFAULT NULL,
`SurnameSoundex` CHAR(4) DEFAULT NULL,
`GivenNames` VARCHAR(120) DEFAULT NULL,
`Occupation` VARCHAR(48) DEFAULT NULL,
`BPlace` VARCHAR(32) DEFAULT NULL,
`MarYear` VARCHAR(4) DEFAULT NULL,
`Religion` VARCHAR(64) DEFAULT NULL,
`Location` VARCHAR(32) DEFAULT NULL,
`Age` VARCHAR(8) DEFAULT NULL,
`BYear` INT(11) DEFAULT '1861',
`Sex` CHAR(1) DEFAULT NULL,
`MStat` CHAR(1) DEFAULT NULL,
`Coloured` CHAR(1) DEFAULT NULL,
`Member` CHAR(1) DEFAULT NULL,
`NotMember` CHAR(1) DEFAULT NULL,
`Absent` CHAR(1) DEFAULT NULL,
`Deaf` CHAR(1) DEFAULT NULL,
`Blind` CHAR(1) DEFAULT NULL,
`Lunatic` CHAR(1) DEFAULT NULL,
`School` CHAR(1) DEFAULT NULL,
`Illiterate` CHAR(1) DEFAULT NULL,
`Birth` CHAR(1) DEFAULT NULL,
`DeathSex` CHAR(1) DEFAULT NULL,
`AgeAtDeath` VARCHAR(4) DEFAULT NULL,
`CauseOfDeath` VARCHAR(64) DEFAULT NULL,
`ResType` VARCHAR(16) DEFAULT NULL,
`Stories` VARCHAR(8) DEFAULT NULL,
`NumFamilies` INT(2) DEFAULT NULL,
`Remarks` VARCHAR(255) DEFAULT NULL,
`IDIR` INT(10) UNSIGNED DEFAULT NULL,
PRIMARY KEY (`Province`,
`District`,
`SubDistrict`,
`Division`,
`Page`,
`Line`),
KEY `Surname` (`Surname`),
KEY `SurnameSoundex` (`SurnameSoundex`),
KEY `GivenNames` (`GivenNames`),
KEY `Occupation` (`Occupation`),
KEY `BPlace` (`BPlace`),
KEY `Religion` (`Religion`),
KEY `IDIR` (`IDIR`) )
ENGINE=InnoDB DEFAULT CHARSET=utf8 

Next: class Census1871