class Census1906

Up: class CensusLine

Source Code

This table is used to contain transcriptions of the population census of the 1906 census of the Prairie Provinces of Canada.

CREATE TABLE `Census1906` (
`Province` CHAR(2) DEFAULT NULL,
`District` DECIMAL(4,
1) NOT NULL,
`SubDistrict` DECIMAL(4,
0) NOT NULL,
`Division` VARCHAR(4) NOT NULL DEFAULT '',
`Page` INT(11) NOT NULL,
`Line` INT(11) NOT NULL,
`Family` CHAR(6) NOT NULL,
`Surname` VARCHAR(120) DEFAULT NULL,
`SurnameSoundex` CHAR(4) DEFAULT NULL,
`GivenNames` VARCHAR(120) DEFAULT NULL,
`Relation` VARCHAR(32) NOT NULL DEFAULT '',
`Sex` CHAR(1) NOT NULL DEFAULT '',
`MStat` CHAR(1) NOT NULL DEFAULT '',
`Age` VARCHAR(8) NOT NULL DEFAULT '',
`BYearTxt` VARCHAR(6) NOT NULL DEFAULT '',
`BYear` INT(11) DEFAULT NULL,
`BPlace` VARCHAR(32) NOT NULL DEFAULT '',
`ImmYear` VARCHAR(4) NOT NULL DEFAULT '',
`PostOffice` VARCHAR(48) NOT NULL DEFAULT '',
`AddrSect` VARCHAR(4) NOT NULL DEFAULT '',
`AddrTwp` VARCHAR(4) NOT NULL DEFAULT '',
`AddrRng` VARCHAR(4) NOT NULL DEFAULT '',
`AddrMdn` VARCHAR(4) NOT NULL DEFAULT '',
`Horses` INT(4) DEFAULT NULL,
`MilkCows` INT(4) DEFAULT NULL,
`Cattle` INT(4) DEFAULT NULL,
`Sheep` INT(4) DEFAULT NULL,
`Pigs` INT(4) DEFAULT NULL,
`Remarks` VARCHAR(255) DEFAULT NULL,
`IDIR` INT(10) UNSIGNED DEFAULT NULL,
`Occupation` VARCHAR(1) DEFAULT '',
PRIMARY KEY (`District`,
`SubDistrict`,
`Division`,
`Page`,
`Line`),
KEY `Surname` (`Surname`),
KEY `SurnameSoundex` (`SurnameSoundex`),
KEY `GivenNames` (`GivenNames`),
KEY `Relation` (`Relation`),
KEY `BYear` (`BYear`),
KEY `BPlace` (`BPlace`),
KEY `PostOffice` (`PostOffice`),
KEY `IDIR` (`IDIR`) )
ENGINE=InnoDB DEFAULT CHARSET=utf8 

Next: class Census1911