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)