EAT&JOY_ERD
Tables (5)
Cart (cart)
- Cart Numers (cart_numbers) — INT(11) — Primary key — NOT NULL
- Product Id (product_id) — INT(11) — Foreign key → Products.Product Id — NOT NULL
- Product Name (product_name) — VARCHAR(20) — Foreign key → Products.Product Name — NOT NULL
- Product Count (product_count) — INT(11)
Customers (customers)
- Customer Code (customer_code) — INT(11) — Primary key — NOT NULL
- Customer Id (customer_id) — VARCHAR(20)
- Customer Pw (customer_Pw) — VARCHAR(20)
- Customer Name (customer_name) — VARCHAR(10)
- Customer Email (customer_email) — VARCHAR(30)
Order (order)
- Order Id (order_id) — INT(11) — Primary key — NOT NULL
- Customer Code (customer_code) — INT(11) — Foreign key → Customers.Customer Code — NOT NULL
- Order Date (order_date) — DATE
- Order Total Price (order_total_price) — INT(11)
- Order State (order_state) — INT(11)
Order Detail (order_detail)
- Order Detail Id (order_detail_id) — INT(11) — Primary key — NOT NULL
- Order Id (order_id) — INT(11) — Foreign key → Order.Order Id — NOT NULL
- Customer Code (customer_code) — INT(11) — Foreign key → Order.Customer Code — NOT NULL
- Product Id (product_id) — INT(11) — Foreign key → Products.Product Id — NOT NULL
- Product Name (product_name) — VARCHAR(20) — Foreign key → Products.Product Name — NOT NULL
- Product Price (product_price) — INT(11)
- Order Quantity (order_quantity) — INT(11)
Products (products)
- Product Id (product_id) — INT(11) — Primary key — NOT NULL
- Product Name (product_name) — VARCHAR(20) — Primary key — NOT NULL
- product Price (product_price) — INT(11)
- Product Hit (product_hit) — INT(10)
- Product Desc (product_desc) — VARCHAR(45)