RoomFit
Tables (9)
lifestyles
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- preferred_floor — VARCHAR(10) — NOT NULL
- personality — VARCHAR(15) — NOT NULL
- temperature_type — VARCHAR(10) — NOT NULL
- diffuser_allowed — BOOLEAN — NOT NULL
- eating_in_room — VARCHAR(25)
- phone_call_in_room — BOOLEAN
- smoking — VARCHAR(15)
- home_visit_frequency — VARCHAR(15)
- shower_time — VARCHAR(15)
- cleaning_frequency — VARCHAR(25)
- sleep_time — VARCHAR(15)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
likes
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- liked_user_id — BIGINT — Foreign key → users.id — NOT NULL
- created_at — DATETIME — NOT NULL
matches
- id — BIGINT
- sender_id — BIGINT — Foreign key → users.id — NOT NULL
- receiver_id — BIGINT — Foreign key → users.id — NOT NULL
- status — VARCHAR(15) — NOT NULL
- open_chat_url — VARCHAR(500)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
notifications
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- type — VARCHAR(20) — NOT NULL
- message — VARCHAR(255) — NOT NULL
- related_id — BIGINT
- is_read — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
types
- id — BIGINT
- code — VARCHAR(20) — NOT NULL
- name — VARCHAR(30) — NOT NULL
- description — VARCHAR(300)
- image_url — VARCHAR(500)
- created_at — DATETIME — NOT NULL
user_priority_traits
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- trait_key — VARCHAR(25) — NOT NULL
- created_at — DATETIME — NOT NULL
user_sleep_habits
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- habit — VARCHAR(20) — NOT NULL
user_sleep_sensitivities
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- sensitivity — VARCHAR(20) — NOT NULL
users
- id — BIGINT
- email — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(20) — NOT NULL
- nickname — VARCHAR(20) — NOT NULL
- gender — VARCHAR(10) — NOT NULL
- birth — DATE
- major — VARCHAR(30)
- grade — INT
- introduce — VARCHAR(300)
- bio — VARCHAR(300)
- profile_image_url — VARCHAR(500)
- type_id — BIGINT — Foreign key → types.id
- onboarding_step — INT — NOT NULL
- is_onboarding_completed — BOOLEAN — NOT NULL
- is_push_enabled — BOOLEAN
- status — VARCHAR(20)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL