itzeep

Tables (29)

chatroom

  • chatroom_id — bigint
  • owner_id — bigint — NOT NULL
  • buyer_id — bigint — NOT NULL
  • home_id — bigint — NOT NULL
  • created_at — datetime
  • last_message_at — datetime
  • last_message — varchar(255)
  • unread_message_count — int

contract_chat

  • contract_chat_id — bigint
  • home_id — bigint — NOT NULL
  • owner_id — bigint
  • buyer_id — bigint
  • contract_start_at — datetime
  • last_message — varchar(255)
  • start_point — varchar(255)
  • end_point — varchar(255)
  • status — enum

electronic_signature

  • contract_id — bigint
  • identity_verification_id — bigint — NOT NULL
  • owner_id — bigint — NOT NULL
  • buyer_id — bigint — NOT NULL
  • owner_tax_signature_file_url — varchar(255)
  • owner_priority_signature_file_url — varchar(255)
  • owner_contract_signature_file_url — varchar(255)
  • buyer_contract_signature_file_url — varchar(255)
  • owner_tax_file_hash — varchar(128)
  • owner_priority_file_hash — varchar(128)
  • owner_contract_file_hash — varchar(128)
  • buyer_contract_file_hash — varchar(128)
  • owner_tax_signed_at — datetime
  • owner_priority_signed_at — datetime
  • owner_contract_signed_at — datetime
  • buyer_contract_signed_at — datetime
  • created_at — datetime — NOT NULL

facility_category

  • category_id — bigint
  • category_type — varchar(100) — NOT NULL

facility_item

  • item_id — bigint
  • category_id — bigint — NOT NULL
  • item_name — varchar(100) — NOT NULL

final_contract

  • contract_id — bigint — NOT NULL
  • home_id — bigint
  • owner_id — bigint
  • buyer_id — bigint
  • contract_pdf_url — varchar(255)
  • contract_pdf_hash — varchar(128)
  • contract_date — datetime
  • contract_expire_date — datetime
  • owner_identity_verified_at — datetime
  • buyer_identity_verified_at — datetime
  • owner_signed_at — datetime
  • buyer_signed_at — datetime
  • deposit_price — int
  • monthly_rent — int
  • maintenance_fee — int
  • created_at — datetime — NOT NULL

home

  • home_id — bigint
  • user_id — bigint — NOT NULL
  • addr1 — varchar(255) — NOT NULL
  • addr2 — varchar(255)
  • residence_type — enum — NOT NULL
  • lease_type — enum — NOT NULL
  • deposit_price — int — NOT NULL
  • monthly_rent — int
  • maintenance_fee — int
  • home_status — enum
  • view_cnt — int
  • like_cnt — int
  • chat_cnt — int
  • report_cnt — int
  • room_cnt — int — NOT NULL
  • supply_area — float — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • user_name — varchar(50) — NOT NULL
  • exclusive_area — float

home_detail

  • home_detail_id — bigint
  • home_id — bigint — NOT NULL
  • build_date — date
  • home_floor — int
  • building_total_floors — int
  • home_direction — enum
  • bathroom_count — int
  • is_pet — tinyint(1)
  • is_parking_available — tinyint(1)

home_facility

  • home_detail_id — bigint — Primary key — NOT NULL
  • item_id — bigint — Primary key — NOT NULL

home_identity_verification

  • home_identity_id — bigint
  • home_id — bigint — NOT NULL
  • user_id — bigint
  • name — varchar(20)
  • birth_date — date — NOT NULL
  • identity_verified_at — datetime

home_image

  • image_id — bigint
  • home_id — bigint — NOT NULL
  • image_url — varchar(255) — NOT NULL

home_like

  • user_id — bigint — Primary key — NOT NULL
  • home_id — bigint — Primary key — NOT NULL
  • liked_at — datetime

home_maintenance_fee

  • home_id — bigint — Primary key — NOT NULL
  • maintenance_id — bigint — Primary key — NOT NULL
  • fee — int — NOT NULL

home_report

  • report_id — bigint
  • user_id — bigint — NOT NULL
  • home_id — bigint — NOT NULL
  • report_reason — text — NOT NULL
  • report_at — datetime
  • report_status — enum

identity_verification

  • identity_id — bigint
  • user_id — bigint
  • contract_id — bigint
  • name — varchar(50) — NOT NULL
  • ssn_front — varchar(50) — NOT NULL
  • ssn_back — varchar(50) — NOT NULL
  • identity_verified_at — datetime
  • contract_step — enum — NOT NULL
  • addr1 — varchar(255) — NOT NULL
  • addr2 — varchar(255) — NOT NULL
  • phone_number — varchar(20) — NOT NULL

maintenance_item

  • maintenance_id — bigint
  • item_name — varchar(100) — NOT NULL

notification

  • noti_id — bigint
  • user_id — bigint — NOT NULL
  • title — varchar(255)
  • content — text
  • type — varchar(255)
  • related_id — bigint
  • is_read — tinyint(1)
  • create_at — timestamp
  • data — json

owner_jeonse_info

  • contract_chat_id — bigint — Primary key — NOT NULL
  • owner_jeonse_rent_id — bigint
  • allow_jeonse_right_registration — tinyint(1)

owner_precontract_check

  • contract_chat_id — bigint — NOT NULL
  • identity_id — bigint
  • rent_type — enum — NOT NULL
  • is_mortgaged — tinyint(1)
  • contract_duration — enum
  • renewal_intent — enum
  • response_repairing_fixtures — enum
  • has_condition_log — tinyint(1)
  • has_penalty — tinyint(1)
  • has_priority_for_extension — tinyint(1)
  • has_auto_price_adjustment — tinyint(1)
  • require_rent_guarantee_insurance — tinyint(1)
  • insurance_burden — enum
  • has_notice — enum
  • checked_at — datetime
  • contract_file_url — varchar(255)
  • owner_bank_name — varchar(50)
  • owner_account_number — varchar(50)
  • has_tax_arrears — tinyint(1) — 미납 국세·지방세 여부
  • tax_arrears_amount — int — 미납 국세·지방세 금액
  • has_prior_fixed_date — tinyint(1) — 선순위 확정일자 여부

owner_restore_scope

  • restore_category_id — bigint — Primary key — NOT NULL
  • owner_precheck_id — bigint — Primary key — NOT NULL

owner_wolse_info

  • contract_chat_id — bigint — Primary key — NOT NULL
  • owner_wolse_rent_id — bigint
  • payment_due_day — int
  • late_fee_interest_rate — decimal(5, 2)
  • check — (`payment_due_day` between 1 and 31)

restore_category

  • restore_category_id — bigint
  • restore_category_name — varchar(255) — NOT NULL

risk_check

  • riskck_id — bigint
  • user_id — bigint — NOT NULL
  • home_id — bigint — NOT NULL
  • risk_type — enum — NOT NULL
  • checked_at — datetime
  • registry_file_url — varchar(255)
  • building_file_url — varchar(255)
  • registry_file_date — datetime
  • building_file_date — datetime

risk_check_detail

  • riskck_id — bigint — Primary key — NOT NULL
  • title1 — varchar(255) — Primary key — NOT NULL
  • title2 — varchar(255)
  • content — varchar(255)

social_account

  • social_id — varchar(255) — NOT NULL
  • social_type — enum — NOT NULL
  • user_id — bigint — NOT NULL

tenant_jeonse_info

  • tenant_jeonse_rent_id — bigint
  • jeonse_loan_plan — tinyint(1)
  • jeonse_insurance_plan — tinyint(1)
  • tenant_precheck_id — bigint

tenant_precontract_check

  • contract_chat_id — bigint — NOT NULL
  • identity_id — bigint
  • riskck_id — bigint
  • rent_type — enum
  • deposit_adjustment — tinyint(1)
  • expected_move_in_date — datetime
  • contract_duration — enum
  • renewal_intent — enum
  • facility_repair_needed — tinyint(1)
  • interior_cleaning_needed — tinyint(1)
  • appliance_installation_plan — tinyint(1)
  • has_parking — tinyint(1)
  • parking_count — int
  • has_pet — tinyint(1)
  • pet_info — varchar(255)
  • pet_count — bigint
  • indoor_smoking_plan — tinyint(1)
  • early_termination_risk — tinyint(1)
  • nonresidential_use_plan — enum
  • risk_type — enum
  • resident_count — int
  • occupation — varchar(100)
  • emergency_contact — varchar(50)
  • relation — varchar(50)
  • request_to_owner — varchar(255)
  • checked_at — datetime

tenant_wolse_info

  • tenant_wolse_rent_id — bigint
  • wolse_loan_plan — tinyint(1)
  • wolse_insurance_plan — tinyint(1)
  • tenant_precheck_id — bigint

user

  • user_id — bigint
  • nickname — varchar(50) — NOT NULL
  • email — varchar(100) — NOT NULL
  • password — varchar(255) — NOT NULL
  • birth_date — date
  • gender — enum
  • profile_img_url — varchar(255)
  • created_at — datetime
  • updated_at — datetime
  • role — enum
  • notification_enabled — tinyint — NOT NULL