 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');

  `relationship_id` int(11),
  `birth_date` date,
  `birth_place` varchar(200),
  `civil_status` int(11),
  `years_of_residency` int(11),
  `occupation` varchar(100),
  `gender_id` int(11),
  `highest_education_attainment_id` int(11),
  `deleted` int(11),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

  `full_name` varchar(100),
  `user_name` varchar(100),
  `password` varchar(100),
  `created` datetime,
  `modified` datetime,
  `deleted` int(11),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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