Member Info
Tables (7)
Category (category)
- Category_ID (category_id) — int — Primary key — NOT NULL
- Parent_ID (parent_id) — int — Primary key — NOT NULL
- Name (name) — varchar
Category_Item (category_item)
- Category_ID (category_id) — int — Foreign key → Category.Category_ID — NOT NULL
- Item_ID (item_id) — int — Foreign key → Item.Item_ID — NOT NULL
Delivery (delivery)
- Delivery_ID (delivery_id) — int — Primary key — NOT NULL
- City (city) — varchar
- Street (street) — varchar
- Zipcode (zipcode) — varchar
- Status (status) — varchar
Item (item)
- Item_ID (item_id) — int — Primary key — NOT NULL
- Name (name) — varchar
- Price (price) — int
- StockQuantity (stockquantity) — int
Member (member)
- Member_ID (member_id) — int — Primary key — NOT NULL
- Name (name) — varchar
- CIty (city) — varchar
- Street (street) — varchar
- Zipcode (zipcode) — varchar
Order_Item (order_item)
- Orders_ID (orders_id) — int — Foreign key → Orders.Orders_ID — NOT NULL
- Item_ID (item_id) — int — Foreign key → Item.Item_ID — NOT NULL
- OrderPrice (orderprice) — int
- Count (count) — int
Orders (orders)
- Orders_ID (orders_id) — int — Primary key — NOT NULL
- Member_ID (member_id) — int — Foreign key → Member.Member_ID — NOT NULL
- Delivery_ID (delivery_id) — int — Foreign key → Delivery.Delivery_ID — NOT NULL
- OrderDate (orderdate) — date
- Status (status) — varchar