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