[sql] Health Informatics Students

Viewer

copydownloadembedprintName: Health Informatics Students
  1. CREATE TABLE `Health Informatics Students` (
  2.         `Student ID` INT(12) NOT NULL,
  3.         `First name` VARCHAR(25) NOT NULL,
  4.         `Last name` VARCHAR(30),
  5.         `School name` VARCHAR DEFAULT 'Confederation college',
  6.         `Program name` VARCHAR DEFAULT 'Health Informatics',
  7.         `Program start date` DATE NOT NULL,
  8.         `Previous degree` VARCHAR(5),
  9.         `Phone number` INT(15) NOT NULL,
  10.         `Address` VARCHAR(50),
  11.         `City` VARCHAR NOT NULL DEFAULT 'Thunder Bay',
  12.         `Final semester` INT,
  13.         PRIMARY KEY (`Student ID`,`First name`,`Last name`,`School name`,`Program name`,`Program start date`,`Previous degree`,`Phone number`,`Address`,`City`,`Final semester`)
  14. );

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: