zupzup

Tables (9)

Buildings

  • id — BIGINT
  • name — VARCHAR(255)
  • latitude — FLOAT
  • longitude — FLOAT
  • is_outdoor — BOOLEAN

Categories

  • id — BIGINT
  • name — VARCHAR(255)
  • icon_url — TEXT
  • is_valuable — BOOLEAN

Claims

  • id — BIGINT
  • user_id — BIGINT
  • lost_item_id — BIGINT
  • quiz_passed — BOOLEAN
  • pledged_at — DATETIME
  • is_completed — BOOLEAN
  • completed_at — DATETIME

Keywords

  • id — BIGINT
  • user_id — BIGINT
  • category_id — BIGINT
  • building_id — BIGINT
  • date_range_start — DATE
  • date_range_end — DATE

LostItemPhotos

  • id — BIGINT
  • lost_item_id — BIGINT
  • image_url — TEXT
  • is_main — BOOLEAN

LostItems

  • id — BIGINT
  • title — VARCHAR(255)
  • description — TEXT
  • category_id — BIGINT
  • found_location_id — BIGINT
  • custom_location_detail — VARCHAR(255)
  • keeper_location — VARCHAR(255)
  • status — ENUM('active', 'found', 'expired')
  • has_quiz — BOOLEAN
  • owner_id — BIGINT
  • found_date — DATE
  • created_at — DATETIME
  • expires_at — DATETIME

Notifications

  • id — BIGINT
  • user_id — BIGINT
  • lost_item_id — BIGINT
  • sent_at — DATETIME
  • method — ENUM('email', 'inapp')

Quizzes

  • id — BIGINT
  • lost_item_id — BIGINT
  • question — TEXT
  • correct_answer — VARCHAR(255)
  • option1 — VARCHAR(255)
  • option2 — VARCHAR(255)
  • option3 — VARCHAR(255)

Users

  • id — BIGINT
  • email — VARCHAR(255)
  • nickname — VARCHAR(255)
  • provider — ENUM('google', 'naver')
  • created_at — DATETIME