Create Tables_2, Sql Server

Create Tables_2

CREATE TABLE CUSTOMERS (
Customer_ID            VARCHAR(15)    NOT NULL UNIQUE,
First_Name             VARCHAR(25)    NOT NULL,
Last_Name              VARCHAR(25)    NOT NULL,
Street_Address         VARCHAR(50)    NOT NULL,
Apartment_Number       VARCHAR(6)     NOT NULL,
City                   VARCHAR(25)    NOT NULL,
State                  CHAR(2)        NOT NULL,
Zip_code               VARCHAR(6)     NOT NULL,
Home_Phone             VARCHAR(10)    NOT NULL,
Mobile_Phone           VARCHAR(10)    NOT NULL,
Other_Phone            VARCHAR(10)    NOT NULL,
PRIMARY KEY (Customer_ID));

CREATE TABLE ORDERS (
Order_ID               VARCHAR(15)    NOT NULL UNIQUE,
Customer_ID            VARCHAR(15)    NOT NULL REFERENCES CUSTOMERS (Customer_ID),
Order_Date             DATE           NOT NULL,
Order_Notes            VARCHAR(75),     
PRIMARY KEY (Order_ID));

CREATE TABLE DONUTS (
Donut_ID               VARCHAR(15)    NOT NULL UNIQUE,
Donut_Name             VARCHAR(25)    NOT NULL,
Donut_Description      VARCHAR(50)    NOT NULL,
Unit_Price             DECIMAL(7,2)   NOT NULL,        
PRIMARY KEY (Donut_ID));

CREATE TABLE ORDER_LINE_ITEM (
Donut_ID               VARCHAR(15)    NOT NULL REFERENCES DONUTS(Donut_ID),
Order_ID               VARCHAR(15)    NOT NULL REFERENCES ORDERS (Order_ID),
Quantity               NUMERIC        NOT NULL);


run \| edit \| history \| help	0