test

Tables (9)

Customer (Untitled)

  • customerID (customer_id) — NOT NULL — Primary key — NOT NULL
  • user_name — NOT NULL
  • user_phone — NOT NULL
  • user_grade — NOT NULL
  • user_accomulated — NOT NULL

Easy_join (easy_join)

  • user_email_id (email_id) — NOT NULL — Primary key — NOT NULL
  • user_number (Key) — NOT NULL — Primary key — NOT NULL
  • user_easy_number (easy_number) — NOT NULL
  • Field2

Mart (마트)

  • martID (mart_id2) — NOT NULL — Foreign key → Order.martID — NOT NULL
  • martName (mart_name) — NOT NULL
  • martAddress (mart_address) — NOT NULL
  • martTel (mart_tel) — NOT NULL

Order (주문)

  • orderID (order_id) — NOT NULL — Primary key — NOT NULL
  • martID (mart_id) — NOT NULL — Primary key — NOT NULL
  • orderTime (order_time) — NOT NULL
  • orderAmount (order_amount) — NOT NULL
  • orderQauntity (order_qauntity) — NOT NULL
  • orderPayment (order_payment) — NOT NULL

OrderDetail (주문상세)

  • Key — Primary key — NOT NULL
  • orderID (order_id) — NOT NULL — Foreign key → Order.orderID — NOT NULL
  • martID (mart_id) — NOT NULL — Foreign key → Order.martID — NOT NULL
  • productID (product_id) — NOT NULL — Foreign key → Product.productID — NOT NULL
  • customerID (customer_id) — NOT NULL — Foreign key → Customer.customerID — NOT NULL
  • productAmount (product_amount) — NOT NULL

Product (상품)

  • productID (product_id) — NOT NULL — Primary key — NOT NULL
  • productName (product_name) — NOT NULL
  • productCategory (product_category) — NOT NULL
  • productPrice (product_price) — NOT NULL
  • productTax (product_tax) — NOT NULL
  • Field

ex1 (Untitled2)

  • Key — Primary key — NOT NULL

ex1 (Untitled3)

  • Key — Primary key — NOT NULL

join

  • user_number (userNumber) — NOT NULL — Primary key — NOT NULL
  • user_id (userID) — NOT NULL
  • user_password (password) — NOT NULL
  • user_name (name) — NOT NULL
  • user_phone (phone) — NOT NULL
  • user_email (email) — NOT NULL
  • user_grade (grade) — NOT NULL
  • user_address (address) — NOT NULL
  • join_date (creatDate) — NOT NULL
  • user_accumulated (accumulated) — NOT NULL