cozy share

Tables (9)

direct_message_room

  • direct_message_room_id — BIGINT — Primary key — NOT NULL
  • progress_home_id — BIGINT
  • user_1_id — BIGINT — Foreign key → user.user_id
  • user_2_id — BIGINT — Foreign key → user.user_id
  • INDEX — `FKahhpgvm2xsud0er37cc7uv7jw`
  • INDEX — `FK8ky9lq8kxdhyrm5ipos4rm91r`

home

  • home_id — BIGINT — Primary key — NOT NULL
  • create_date_time — DATETIME(6)
  • modified_date_time — DATETIME(6)
  • bath_room_count — INT — NOT NULL
  • bedroom_count — INT — NOT NULL
  • bill — INT — NOT NULL
  • bond — INT — NOT NULL
  • can_parking — BIT(1) — NOT NULL
  • gender — ENUM('MALE', 'FEMALE', 'ANYTHING') — NOT NULL
  • introduce — VARCHAR(255) — NOT NULL
  • options — VARCHAR(255) — NOT NULL
  • rent — INT — NOT NULL
  • resident_count — INT — NOT NULL
  • type — ENUM('SHARED_ROOM', 'PRIVATE_ROOM', 'HOME_STAY', 'STUDIO', 'ONE_BED_FLAT') — NOT NULL
  • home_status — ENUM('SOLD_OUT', 'SELL_STOP', 'DURING_SELL', 'FOR_SALE')
  • user_id — BIGINT — NOT NULL
  • home_address_id — BIGINT — Foreign key → home_address.home_address_id

home_address

  • home_address_id — BIGINT — Primary key — NOT NULL
  • create_date_time — DATETIME(6)
  • modified_date_time — DATETIME(6)
  • city — VARCHAR(255) — NOT NULL
  • detail_address — VARCHAR(255) — NOT NULL
  • latitude — DOUBLE
  • longitude — DOUBLE
  • post_code — INT — NOT NULL
  • state — VARCHAR(255) — NOT NULL
  • street_code — VARCHAR(255) — NOT NULL
  • street_name — VARCHAR(255) — NOT NULL

home_image

  • home_image_id — BIGINT — Primary key — NOT NULL
  • create_date_time — DATETIME(6)
  • modified_date_time — DATETIME(6)
  • image_url — VARCHAR(255) — NOT NULL
  • home_id — BIGINT — Foreign key → home.home_id
  • INDEX — `FK3vwjapwljhhjaqwktpnjxtfbf`

point_history

  • id — BIGINT — Primary key — NOT NULL
  • charge_amount — DOUBLE — NOT NULL
  • charge_type — ENUM('WITHDRAW', 'APPLY_WITHDRAW', 'DEPOSIT')
  • history_date_time — DATETIME(6)
  • user_account_id — BIGINT — Foreign key → user_account.user_account_id
  • INDEX — `FKd08vdcwvsrhrs0anf2xmk39vg`

protected_deal

  • protected_deal_id — BIGINT — Primary key — NOT NULL
  • create_date_time — DATETIME(6)
  • modified_date_time — DATETIME(6)
  • deal_state — ENUM('NONE', 'REQUEST_DEAL', 'ACCEPT_DEAL', 'CANCEL_BEFORE_DEAL', 'CANCEL_DURING_DEAL', 'COMPLETE_DEAL') — NOT NULL
  • deposit — DOUBLE — NOT NULL
  • dm_id — BIGINT — NOT NULL
  • getter_id — BIGINT — NOT NULL
  • home_id — BIGINT — NOT NULL
  • provider_id — BIGINT — NOT NULL
  • protected_deal_time_id — BIGINT — Foreign key → protected_deal_date_time.protected_deal_time_id

protected_deal_date_time

  • protected_deal_time_id — BIGINT — Primary key — NOT NULL
  • cancel_at — DATETIME(6)
  • complete_at — DATETIME(6)
  • create_at — DATETIME(6)
  • deal_at — DATETIME(6)
  • start_at — DATETIME(6)

user

  • user_id — BIGINT — Primary key — NOT NULL
  • create_date_time — DATETIME(6)
  • modified_date_time — DATETIME(6)
  • email — VARCHAR(255) — NOT NULL
  • fcm_token — VARCHAR(255)
  • gender — ENUM('MALE', 'FEMALE', 'ANYTHING')
  • introduce — VARCHAR(255)
  • job — VARCHAR(255)
  • nationality — VARCHAR(255)
  • nickname — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • profile_url — VARCHAR(255)
  • refresh_token — VARCHAR(255)
  • signup_type — ENUM('EMAIL', 'GOOGLE', 'APPLE') — NOT NULL
  • user_state — ENUM('ACTIVE', 'INACTIVE')

user_account

  • user_account_id — BIGINT — Primary key — NOT NULL
  • depositor_name — VARCHAR(255)
  • paypal_information — VARCHAR(255)
  • point — DOUBLE
  • user_id — BIGINT — NOT NULL