CREATE TABLE customer
(
  customerID int,
  first_name varchar(20) NOT NULL,
  last_name varchar(20) NOT NULL,
  address_line varchar(40),
  city varchar(20),
  postcode varchar(10) NOT NULL,
  mobile_number varchar(11) UNIQUE,
  email_address varchar(40) UNIQUE,
  PRIMARY KEY (customerID)
);


CREATE TABLE orders
(
  orderID int,
  fk_customerID int,
  order_date DATE,
  PRIMARY KEY(orderID),
  FOREIGN KEY(fk_customerID) REFERENCES customer(customerID)
);

CREATE TABLE orderitem
(
  itemID int,

)

CREATE TABLE payment
(
  paymentID int,
  fk_orderID int,
  payment_method varchar(20) NOT NULL,
  payment_date DATE,
  PRIMARY KEY (paymentID)
)
CREATE TABLE delivery
(
  deliveryID int,
  delivery_address varchar(40),
  delivery_date DATETIME,
  PRIMARY KEY (deliveryID)
)