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