create.txt

CREATE TABLE UserAccount
( 
	Email VARCHAR(100) NOT NULL,  
	Password VARCHAR(256) NOT NULL, 
    CryptoKey VARCHAR(256) NOT NULL,
	Salt VARCHAR(128) NOT NULL,
	Primary key (Email) 
);

CREATE TABLE Customer
     ( 
	Email VARCHAR(100) NOT NULL,  
        FirstName VARCHAR(30) NOT NULL, 
        LastName VARCHAR(30) NOT NULL,
        Address VARCHAR(50) NOT NULL,
        City VARCHAR(20) NOT NULL, 
        Postcode VARCHAR (4) NOT NULL,
        State VARCHAR(15) NOT NULL, 
        Country VARCHAR(10) NOT NULL,
	AreaCode VARCHAR(2) NOT NULL,
        Telephone VARCHAR (30) NOT NULL, 
        Company VARCHAR (30),
        Primary key (Email),		
	FOREIGN KEY (Email) REFERENCES UserAccount(Email)
     );
	 
 CREATE TABLE Card
     ( 
		Email VARCHAR(100) NOT NULL, 
        Name VARCHAR(30) NOT NULL, 
        CardNumber VARCHAR(19) UNIQUE NOT NULL,
		ExpiryMonth VARCHAR(2) NOT NULL,
		ExpiryYear VARCHAR(2) NOT NULL,
		CVV VARCHAR(3) NOT NULL,
        Primary key (Email),
		FOREIGN KEY (Email) REFERENCES Customer(Email)
     );
	 
 CREATE TABLE Orders
   (
   ID INT NOT NULL, 
   CardNumber VARCHAR(19) NOT NULL,
   OrderSubtotal NUMBER(19,4) NOT NULL,
   ShippingCost NUMBER(19,4) NOT NULL,
   GstCost NUMBER(19,4) NOT NULL,
   TotalCost NUMBER(19,4) NOT NULL,
   OrderDate DATE NOT NULL,
   Primary key (ID),
   FOREIGN KEY (CardNumber) REFERENCES Card(CardNumber)
 );
 
  CREATE TABLE Items
   (
   ID INT NOT NULL, 
   OrderId INT NOT NULL,
   Product VARCHAR(30) NOT NULL,
   Qty INT NOT NULL,
   Price NUMBER(19,4) NOT NULL,
   ImgUrl VARCHAR(30) NOT NULL,
   Primary key (ID),
   FOREIGN KEY (OrderId) REFERENCES Orders(ID)
 );
 
   CREATE TABLE Contact
   (
   ID INT NOT NULL, 
   Firstname VARCHAR(30) NOT NULL,
   lastName VARCHAR(30) NOT NULL,
   Email VARCHAR(100) NOT NULL,
   subject VARCHAR(10) NOT NULL,
   Message VARCHAR(300) NOT NULL,
   Primary key (ID)
 );