0504 Workshop
Tables (6)
Admin (admins)
- Admin id (admin_id) — BIGINT(11) — Primary key — NOT NULL
- Admin password (admin_pw) — VARCHAR(255)
- Admin name (admin_name) — VARCHAR(255)
- Store id (store_id) — BIGINT(11) — Foreign key → Store.Store id — NOT NULL
- Phone (phone_number) — VARCHAR(255)
Category (categories)
- Catergory id (category_id) — BIGINT(11) — Primary key — NOT NULL
- Name (name) — VARCHAR(255)
Order (orders)
- Order id (order_id) — BIGINT(11) — Primary key — NOT NULL
- Order date (order_date) — DATETIME
- Cost (order_cost) — INT(11)
- State (order_state) — VARCHAR(255)
- Admin id (admin_id) — BIGINT(11) — Foreign key → Admin.Admin id — NOT NULL
Order Detail (order_details)
- Order detail id (order_detail_id) — BIGINT(11) — Primary key — NOT NULL
- Order id (order_id) — BIGINT(11) — Foreign key → Order.Order id — NOT NULL
- Product id (product_id) — BIGINT(11) — Foreign key → Product.Product id — NOT NULL
- Count (count) — INT(11)
- Unit price (unit_price) — INT(11)
- State (state) — VARCHAR(255)
Product (products)
- Product id (product_id) — BIGINT(11) — Primary key — NOT NULL
- Name (name) — VARCHAR(255)
- Price (price) — INT(11)
- Expiration Date (expiration_date) — DATETIME
- Catergory id (category_id) — BIGINT(11) — Foreign key → Category.Catergory id — NOT NULL
- Count (count) — INT(11)
- Image (image_path) — VARCHAR(255)
- State (state) — VARCHAR(255)
- Manufacturer (manufacturer) — VARCHAR(255)
Store (stores)
- Store id (store_id) — BIGINT(11) — Primary key — NOT NULL
- Location (location) — VARCHAR(255)
- Name (name) — VARCHAR(255)
- Phone Number (phone_number) — VARCHAR(255)