Member Info
Tables (7)
Category (category)
- Category ID (category_id) — int — Primary key — NOT NULL
- Parent ID (parent_id) — int — 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 (Field) — varchar
Item (item)
- Item ID (item_id) — int — Primary key — NOT NULL
- Name (name) — varchar
- Price (price) — int
- Stock Quantity (stock_quantity) — 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)
- Order Item ID (order_item_id) — int — Primary key — NOT NULL
- Order ID (order_id) — int — Foreign key → Orders.Order ID — NOT NULL
- Item ID (item_id2) — int — Foreign key → Item.Item ID — NOT NULL
- Order Price (order_price) — int
- Count (count) — int
Orders (orders)
- Order ID (order_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
- Order Date (order_date) — date
- Status (status) — varchar