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