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