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