LoopIn
Tables (9)
check_ins
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- mood — VARCHAR(40) — NOT NULL
- meal — VARCHAR(40) — NOT NULL
- sleep — VARCHAR(40) — NOT NULL
- outside — VARCHAR(40) — NOT NULL
- conversation — VARCHAR(40) — NOT NULL
- note — VARCHAR(200)
- checked_on — DATE — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
help_request_logs
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- resource_id — BIGINT — Foreign key → help_resources.id
- request_type — VARCHAR(40) — NOT NULL
- confirmed_at — DATETIME(6) — NOT NULL
- canceled_at — DATETIME(6)
- note — VARCHAR(200)
- created_at — DATETIME(6) — NOT NULL
help_resources
- id — BIGINT
- name — VARCHAR(120) — NOT NULL
- description — VARCHAR(500) — NOT NULL
- category — VARCHAR(40) — NOT NULL
- region_sido — VARCHAR(40)
- region_sigungu — VARCHAR(80)
- phone — VARCHAR(40)
- website_url — VARCHAR(500)
- address — VARCHAR(300)
- is_active — BOOLEAN — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
missions
- id — BIGINT
- title — VARCHAR(80) — NOT NULL
- description — VARCHAR(300) — NOT NULL
- category — VARCHAR(40) — NOT NULL
- estimated_minutes — SMALLINT — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
quiet_notes
- id — BIGINT
- room_id — BIGINT — Foreign key → quiet_rooms.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- content — VARCHAR(300) — NOT NULL
- visibility — VARCHAR(20) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
quiet_room_members
- id — BIGINT
- room_id — BIGINT — Foreign key → quiet_rooms.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- joined_at — DATETIME(6) — NOT NULL
- left_at — DATETIME(6)
- active_user_id — BIGINT
quiet_rooms
- id — BIGINT
- name — VARCHAR(80) — NOT NULL
- description — VARCHAR(300) — NOT NULL
- topic — VARCHAR(40) — NOT NULL
- region_sido — VARCHAR(40)
- region_sigungu — VARCHAR(80)
- is_active — BOOLEAN — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
user_missions
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- mission_id — BIGINT — Foreign key → missions.id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- selected_on — DATE — NOT NULL
- completed_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
users
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(40) — NOT NULL
- birth_year — SMALLINT
- persona_type — VARCHAR(40)
- region_sido — VARCHAR(40)
- region_sigungu — VARCHAR(80)
- is_active — BOOLEAN — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL