Palm oil
Tables (4)
Available_Products
- Prod_title — varchar(40)
- prod_category — varchar(35)
- prod_price — varchar(40)
- Pro_id (Pro_id2) — number — Foreign key → Product_info.Pro_id — NOT NULL
Customer(user)
- Cust_id — number — Primary key — NOT NULL
- Customer name (Cust_name) — varchar(30)
- Cust_e-mail — varchar(40)
- Cust_username — varchar(35)
- Cust_password — varchar(40)
Image
- Image_id — number — Primary key — NOT NULL
- Image_category — varchar(40)
- Image_Date (Imaget_Date) — date
- Cust_id — number — Foreign key → Customer(user).Cust_id — NOT NULL
Product_info
- Pro_id — number — Primary key — NOT NULL
- Prod_name — varchar(40)
- Prod_desc — varchar(35)
- Prod_approval — varchar(5)
- Image_id — number — Foreign key → Image.Image_id — NOT NULL