shop
Tables (4)
category
- cate_no — int — Primary key — NOT NULL
- cate_name — varchar(255)
member
- mem_no — int — Primary key — NOT NULL
- mem_id — varchar(255)
- mem_passwd — varchar(255)
- mem_name — varchar(255)
- mem_email — varchar(255)
- mem_role — varchar(10)
orders
- order_no — int — Primary key — NOT NULL
- order_price — int
- order_cost — int
- order_income — int
- order_name — varchar(255)
- order_products — int
- order_addr — varchar(255)
- order_status — int
- imp_uid — varchar(255)
- mem_no — int — Foreign key → member.mem_no
product
- prod_no — int — Primary key — NOT NULL
- prod_name — varchar(255)
- prod_price — int
- prod_cost — int
- prod_income — int
- prod_status — int
- prod_amount — int
- prod_img — varchar(255)
- cate_no — int — Foreign key → category.cate_no