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