a
Tables (3)
customer
- cus_id — int — Primary key — NOT NULL
- cus_username — varchar(15)
- cus_birthdate — date
order
- prod_id — int
- ord_quantity — int
- ord_id — int — NOT NULL
- cus_id — int — Foreign key → customer.cus_id — NOT NULL
product
- pro_id — int — Primary key — NOT NULL
- pro_productname — varchar(30)
- pro_quantity — int