CREATE TABLE `hms`.`record_info` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `phone_number` VARCHAR(45) NULL,
  `surname` VARCHAR(45) NULL,
  `first_name` VARCHAR(45) NULL,
  `gender` VARCHAR(45) NULL,
  `dob` VARCHAR(45) NULL,
  `marital_status` VARCHAR(45) NULL,
  `occupation` VARCHAR(45) NULL,
  `email_address` VARCHAR(45) NULL,
  `address` VARCHAR(45) NULL,
  `next_of_kin_fullname` VARCHAR(45) NULL,
  `next_of_kin_relationship` VARCHAR(45) NULL,
  `next_of_kin_phonenumber` VARCHAR(45) NULL,
  `next_of_kin_email` VARCHAR(45) NULL,
  `next_of_kin_address` VARCHAR(45) NULL,

  PRIMARY KEY (`id`));


ALTER TABLE `hms`.`record_info` 
ADD COLUMN `facilityId` VARCHAR(45) NULL AFTER `next_of_kin_address`;
