SHARE
TWEET

Untitled

a guest Sep 14th, 2017 97 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE  `iad`.`Patient` (
  2.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  3.   `first_name` VARCHAR(30) DEFAULT NULL,
  4.   `last_name` VARCHAR(30) DEFAULT NULL,
  5.   `telephone_nember` VARCHAR(11) DEFAULT NULL,
  6.   `gender` tinyint(1) DEFAULT NULL,
  7.   `birthday` DATE DEFAULT NULL,
  8.   `address` mediumtext,
  9.   `sec_profile` INT(11) DEFAULT NULL,
  10.   PRIMARY KEY (`id`),
  11.   KEY `fk_Patient_1` (`sec_profile`),
  12.   CONSTRAINT `fk_Patient_1` FOREIGN KEY (`sec_profile`) REFERENCES `UserSecurityProfile` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
  13. ) ENGINE=InnoDB DEFAULT CHARSET=latin1
RAW Paste Data
Top