[sql] Health Informatics Students
Viewer
- CREATE TABLE `Health Informatics Students` (
- `Student ID` INT(12) NOT NULL,
- `First name` VARCHAR(25) NOT NULL,
- `Last name` VARCHAR(30),
- `School name` VARCHAR DEFAULT 'Confederation college',
- `Program name` VARCHAR DEFAULT 'Health Informatics',
- `Program start date` DATE NOT NULL,
- `Previous degree` VARCHAR(5),
- `Phone number` INT(15) NOT NULL,
- `Address` VARCHAR(50),
- `City` VARCHAR NOT NULL DEFAULT 'Thunder Bay',
- `Final semester` INT,
- PRIMARY KEY (`Student ID`,`First name`,`Last name`,`School name`,`Program name`,`Program start date`,`Previous degree`,`Phone number`,`Address`,`City`,`Final semester`)
- );
Editor
You can edit this paste and save as new:
File Description
- Health Informatics Students
- Paste Code
- 21 Oct-2020
- 631 Bytes
You can Share it: