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)