KPOP

Tables (6)

Admin (Untitled6)

  • adminId — Long — Primary key — NOT NULL
  • id — String
  • pw — String

Goods (Untitled2)

  • goods_id (goodsId) — Long — Primary key — NOT NULL
  • userId — Long — Foreign key → Users.userId — NOT NULL
  • adminId — Long — Foreign key → Users.adminId — NOT NULL
  • title — String
  • description — String
  • price — Long

Group (Untitled5)

  • groupId — Long — Primary key — NOT NULL
  • name — String
  • interestId — Long — Foreign key → Interest.interestId — NOT NULL
  • userId — Long — Foreign key → Interest.userId — NOT NULL
  • adminId — Long — Foreign key → Interest.adminId — NOT NULL

Interest (Untitled4)

  • interestId — Long — Primary key — NOT NULL
  • userId — Long — Foreign key → Users.userId — NOT NULL
  • adminId — Long — Foreign key → Users.adminId — NOT NULL
  • Field

Location (Untitled3)

  • locationId — Long — Primary key — NOT NULL
  • goods_id (goodsId) — Long — Foreign key → Goods.goods_id — NOT NULL
  • userId — Long — Foreign key → Goods.userId — NOT NULL
  • adminId — Long — Foreign key → Goods.adminId — NOT NULL
  • name — String
  • lat (kat) — String
  • lot — String

Users (Untitled)

  • userId — Long — Primary key — NOT NULL
  • adminId — Long — Foreign key → Admin.adminId — NOT NULL
  • nickName — String
  • userEmail — String
  • userPassword — String