SQL DB EXAMPLES

CREATE DATABASE DAPP;


CREATE TABLE PURCHASES 

(PURID			INT			PRIMARY KEY, 
PURDATE			DATETIME	NOT NULL,	
PURAMT			MONEY		NOT NULL); 


CREATE TABLE PURCHASEORDER
(POID			INT			PRIMARY KEY IDENTITY(101, 1),
PODATE			DATETIME	NOT NULL, 
POAMT			MONEY		NOT NULL);   


CREATE TABLE INVENTORYTYPE 
(TYPEID			INT			PRIMARY KEY IDENTITY, 
TYPENAME		VARCHAR(20) NOT NULL); 


CREATE TABLE INVENTORY 
(INVID			INT			PRIMARY KEY IDENTITY, 
INVPROD			VARCHAR(40) NOT NULL, 
INVQTY			INT			NOT NULL, 
INVPRICE		MONEY		NOT NULL, 
TYPEID			INT FOREIGN KEY REFERENCES	INVENTORYTYPE(TYPEID),
POID			INT FOREIGN KEY REFERENCES	PURCHASEORDER(POID)); 

CREATE TABLE INVENTORYORDER 


INSERT INTO PURCHASES 

VALUES (123, '01/15/2015', 150.00);


INSERT INTO PURCHASES 

VALUES (345, '02/20/2015', 300.00);

INSERT INTO PURCHASES 

VALUES (230, '03/01/2015', 5000.00);


CREATE TABLE DBO.SAMPLE_TABLE 

(

	COLUMN_1		INT			NOT NULL, 
	COLUMN_2		INT			NULL
	); 


CREATE TABLE DBO.SAMPLE_TABLE 
(

	COLUMN_1		INT			NOT NULL, 
	COLUMN_2		INT			NULL
	);