OpenMarket
Tables (8)
Cart (cart)
- id (Key) — Primary key — NOT NULL
- id (user id) — Foreign key → Member.id — NOT NULL
Cart Item (cartitem)
- id (Key) — Primary key — NOT NULL
- cart_id (field) — Foreign key → Cart.id — NOT NULL
- item_id — Foreign key → Item.id — NOT NULL
- count (Field)
Item (item)
- id (Key) — Primary key — NOT NULL
- status (Field2)
- name (Field)
- price (Field4)
- count (Field3)
Item Desc (itemdesc)
- Key — Primary key — NOT NULL
- item id (Key2) — Foreign key → Item.id — NOT NULL
Member (member)
- id (Key) — Primary key — NOT NULL
- type (Field3)
- name (Field1)
- email (Field2)
- login (Field4)
- password (Field5)
- address (Field6)
Order (order)
- id (Key) — Primary key — NOT NULL
- user id (user_id) — Foreign key → Member.id — NOT NULL
- order_date (Field)
- status (Field2)
Order Item (orderitem)
- id (Key) — Primary key — NOT NULL
- order id (Key2) — Foreign key → Order.id — NOT NULL
- item id (Key3) — Foreign key → Item.id — NOT NULL
- price (Field)
- count (Field2)
Store (store)
- Key — Primary key — NOT NULL
- member id (Key2) — Foreign key → Member.id — NOT NULL
- board id (Field)
- chat (Field2)
- desc (Field3)