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