dartravel
Tables (6)
BuyingHistory (Untitled5)
- PK (buy_histroy_id) — Long — Primary key — NOT NULL
- PK (user_id) — Long — Foreign key → User.PK — NOT NULL
- PK (item_id) — Long — Foreign key → Item.PK — NOT NULL
Item (Untitled4)
- PK (item_id) — Long — Primary key — NOT NULL
- 아이템 명 (item_name) — String
- 아이템 가격 (Field)
Location (Untitled3)
- PK (location_id) — Long — Primary key — NOT NULL
- 장소 이름 (name) — String
Quest (Untitled2)
- PK (quest_id) — Long — Primary key — NOT NULL
- 어디서 (quest_place) — String
- 어떻게 (quest_how) — String
- 무엇을 (quest_what) — String
- FK (location_id) — Long — Foreign key → Location.PK — NOT NULL
- 보상 (quest_point) — Long
QuestHistory (퀘스트 기록)
- PK (quest_history_id) — Long — Primary key — NOT NULL
- 인증사진 (image_url) — String
- PK (user_id) — Long — Foreign key → User.PK — NOT NULL
- PK (quest_id) — Long — Foreign key → Quest.PK — NOT NULL
User (Untitled)
- PK (user_id) — Long — Primary key — NOT NULL
- Email (user_email) — String
- personal_key (user_key) — UUID
- Point (user_point) — Long