mall project

Tables (4)

Member (맴버)

  • ID (Key) — Primary key — NOT NULL
  • login_id (Field)
  • login_pwd (Field2)
  • nick_name (Field3)
  • created_date (Field4)
  • last_modified_date (Field5)
  • state (Field6)

Order (주문)

  • ID (Key) — Long — Primary key — NOT NULL
  • MemberID (Key2) — Member — Foreign key → Member.ID — NOT NULL
  • created_date (Field2)
  • last_modified_date (Field)

OrderLine (주문상품)

  • ID (Key) — Long — Primary key — NOT NULL
  • ID (OrderID) — Order — Foreign key → Order.ID — NOT NULL
  • ID (ProductID) — Product — Foreign key → Product.ID — NOT NULL
  • order_price (Field) — Long
  • count (Field2) — Long

Product (상품)

  • ID (Key) — Primary key — NOT NULL
  • name (Field) — String
  • price (Field2) — Long
  • stock_quantity (Field3) — Long