   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
+CREATE TABLE `statuses` (
+  `id` int(11)  AUTO_INCREMENT,
+  `name` varchar(100) ,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
 CREATE TABLE `civil_statuses` (
+  `id` int(11)  AUTO_INCREMENT,
+  `name` varchar(100) ,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+CREATE TABLE `house_statuses` (
   `id` int(11)  AUTO_INCREMENT,
   `name` varchar(100) ,
   PRIMARY KEY (`id`)

  `full_name` varchar(100),
  `user_name` varchar(100),
  `password` varchar(100),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `owners` (
  `id` int(11)  AUTO_INCREMENT,
  `house_number` varchar(100),
  `type_of_ownership_id` int(11),
  `full_name` varchar(100),
  `address` varchar(200),
  `birth_date` date,
  `birth_place` varchar(200),
  `citizenship` varchar(100),
  `religion` varchar(100),
  `highest_education_attainment_id` int(11),
  `years_of_residency` int(11),
  `civil_status_id` int(11),
  `occupation` varchar(100),
  `gender_id` int(11),
  `deleted` int(11),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO educations (name)VALUES('High School');
INSERT INTO educations (name)VALUES('College');
INSERT INTO educations (name)VALUES('Post College');
INSERT INTO statuses (name)VALUES('Alive');
INSERT INTO statuses (name)VALUES('Deceased');
INSERT INTO civil_statuses (name)VALUES('Single');
INSERT INTO civil_statuses (name)VALUES('Married');
INSERT INTO civil_statuses (name)VALUES('Widowed');
INSERT INTO civil_statuses (name)VALUES('Separated');
INSERT INTO house_statuses (name)VALUES('Active');
INSERT INTO house_statuses (name)VALUES('Inactive');
INSERT INTO relationships (genre, name)VALUES(1, 'Father');
INSERT INTO relationships (genre, name)VALUES(1, 'Mother');
INSERT INTO relationships (genre, name)VALUES(1, 'Sister');
