sql Script

Project Adire {
  database_type: 'PostgreSQL'
  Note: 'Fashion Store'
}

//Customer
Table Customer {
  customerID integer [primary key]
  firstName varchar
  lastName varchar
  email varchar unique
  phoneNumber varchar
  address varchar
}

//Designer
Table NewDesignerAccount {
  designerID integer [primary key]
  firstName varchar
  lastName varchar
  phoneNumber varchar
  email varchar unique
  userName varchar unique
  password varchar
}

//Product 
Table Product {
  productID integer [primary key]
  productName varchar
  productDescription varchar
  productImage varchar
  designerID integer //[foreign key references Designer(designerID)]
}

//Order
Table Order {
  orderID integer [primary key]
  customerID integer //[foreign key references Customer(customerID)]
  orderDate datetime
  startDate datetime
  endDate datetime
  status varchar
}

//Login Existing Account User 
Table DesignerLogin {
  designerID integer //foreign key
  email varchar [unique]
  password varchar
}

//Order Item
Table OrderItem {
  orderItemID integer [primary key]
  orderID integer //[foreign key references Order(orderID)]
  productID integer //[foreign key references Product(productID)]
  quantity integer
}

//Price
Table Price {
  priceID integer [primary key]
  productID integer //[foreign key references Product(productID)]
  price decimal(10,2)
  startDate datetime
  endDate datetime
}

//Payment
Table Payment {
  paymentID integer [primary key]
  orderID integer //[foreign key references Order(orderID)]
  amount decimal(10,2)
  paymentDate datetime
}

//Order Summary 
Table OrderSummary {
  orderSummaryID integer [primary key]
  orderDate datetime
  customerID integer //[foreign key references Customer(customerID)]
}

//Receipt
Table Receipt {
  receiptID integer [primary key]
  orderID integer //[foreign key references Order(orderID)]
  amount decimal(10,2)
  paymentDate datetime
}