alld

Tables (13)

Address (addr)

  • Address no (addr_cd) — int — Primary key — NOT NULL
  • User no (user_cd) — int — Foreign key → User.User no — NOT NULL
  • Item no (item_cd) — int — Foreign key → Item.Item no — NOT NULL
  • addr code (addr_code) — int — Foreign key → Address code.addr code — NOT NULL

Address code (addr_code)

  • addr code (addr_code) — int — Primary key — NOT NULL

Admin (admin)

  • adm_cd — int — Primary key — NOT NULL
  • User no (user_cd) — int — Foreign key → User.User no — NOT NULL

Delevery (deliver)

  • Delevery no (order_cd) — int — Primary key — NOT NULL
  • Order no (order_cd2) — int — Foreign key → Order.Order no — NOT NULL
  • User no (user_cd) — int — Foreign key → Order.User no — NOT NULL
  • Item no (item_cd) — int — Foreign key → Order.Item no — NOT NULL

Ground (ground)

  • Ground no (ground_cd) — int — Primary key — NOT NULL
  • Main list no (mainlist_cd) — int — Foreign key → Main list.Main list no — NOT NULL

Item (item)

  • Item no (item_cd) — int — Primary key — NOT NULL
  • Main list no (mainlist_cd) — int — Foreign key → Main list.Main list no — NOT NULL

Item detail (item_detail)

  • Item detail no (itm_detail_cd) — int — Primary key — NOT NULL
  • Item no (item_cd) — int — Foreign key → Item.Item no — NOT NULL

Main list (main_list)

  • Main list no (mainlist_cd) — int — Primary key — NOT NULL

Option (option)

  • Option no (option_cd) — int — Primary key — NOT NULL
  • Item no (item_cd) — int — Foreign key → Item.Item no — NOT NULL

Order (order)

  • Order no (order_cd) — int — Primary key — NOT NULL
  • User no (user_cd) — int — Foreign key → User.User no — NOT NULL
  • Item no (item_cd) — int — Foreign key → Item.Item no — NOT NULL

Review (review)

  • Review no (review_cd) — int — Primary key — NOT NULL
  • User no (user_cd) — int — Foreign key → User.User no — NOT NULL
  • Item no (item_cd) — int — Foreign key → Item.Item no — NOT NULL

Seller (seller)

  • Seller no (item_cd) — int — Primary key — NOT NULL
  • Order no (order_cd) — int — Foreign key → Order.Order no — NOT NULL
  • User no (user_cd) — int — Foreign key → Order.User no — NOT NULL
  • Item no (item_cd2) — int — Foreign key → Order.Item no — NOT NULL

User (user)

  • User no (user_cd) — int — Primary key — NOT NULL