usan-erd
Tables (15)
administrative_boundary
- id — BIGINT — Primary key — NOT NULL
- adm_cd — VARCHAR(10) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- adm_level — VARCHAR(20) — NOT NULL
- parent_adm_cd — VARCHAR(10)
- geom — GEOMETRY — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
broker_info
- broker_code — BINARY(16) — Primary key — NOT NULL
- broker_name — VARCHAR(100) — NOT NULL
- office_name — VARCHAR(150)
- registration_number — VARCHAR(50) — NOT NULL
- tel — VARCHAR(30)
- phone — VARCHAR(30) — NOT NULL
- road_address — VARCHAR(255)
- jibun_address — VARCHAR(255)
- sido — VARCHAR(50)
- sigungu — VARCHAR(50)
- emd — VARCHAR(50)
- ri — VARCHAR(50)
- road_name — VARCHAR(50)
- building_number — VARCHAR(50)
- building_name — VARCHAR(100)
- land_number — VARCHAR(50)
- postal_code — VARCHAR(50)
- lat — DECIMAL(10,7) — NOT NULL
- lng — DECIMAL(10,7) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
broker_property_count
- broker_code — BINARY(16) — Foreign key → broker_info.broker_code — NOT NULL
- public_id — VARCHAR(6) — NOT NULL
- broker_name — VARCHAR(255)
- office_name — VARCHAR(255)
- registration_number — VARCHAR(255)
- tel — VARCHAR(255)
- phone — VARCHAR(255)
- sido — VARCHAR(255)
- sigungu — VARCHAR(255)
- emd — VARCHAR(255)
- road_name — VARCHAR(255)
- addr_road — VARCHAR(255)
- addr_jibun — VARCHAR(255)
- lat — DECIMAL(10,7) — NOT NULL
- lng — DECIMAL(10,7) — NOT NULL
- apt_cnt — INT
- officetel_cnt — INT
- villa_cnt — INT
- oneroom_cnt — INT
- tworoom_cnt — INT
- detached_cnt — INT
- rural_cnt — INT
- mixedhouse_cnt — INT
- hanok_cnt — INT
- store_cnt — INT
- office_cnt — INT
- building_cnt — INT
- factory_cnt — INT
- knowledge_cnt — INT
- land_cnt — INT
- apt_sale_cnt — INT
- officetel_sale_cnt — INT
- redevelopment_cnt — INT
- reconstruction_cnt — INT
- presale_cnt — INT
- total_cnt — INT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
credit_ledger
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → users.user_id — NOT NULL
- credit_order_id — BIGINT — Foreign key → credit_order.id
- payment_id — BIGINT — Foreign key → payment.id
- ledger_type — VARCHAR(30) — NOT NULL
- change_amount — INT — NOT NULL
- balance_after — INT — NOT NULL
- related_type — VARCHAR(30)
- related_id — BIGINT
- description — VARCHAR(255)
- created_at — DATETIME — NOT NULL
credit_order
- id — BIGINT — Primary key — NOT NULL
- order_no — VARCHAR(100) — NOT NULL
- member_id — BIGINT — Foreign key → users.user_id — NOT NULL
- credit_product_id — BIGINT — Foreign key → credit_product.id — NOT NULL
- product_code_snapshot — VARCHAR(50) — NOT NULL
- product_name_snapshot — VARCHAR(100) — NOT NULL
- price_amount_snapshot — INT — NOT NULL
- base_credit_snapshot — INT — NOT NULL
- bonus_credit_snapshot — INT — NOT NULL
- total_credit_snapshot — INT — NOT NULL
- depositor_name — VARCHAR(100)
- contact_phone — VARCHAR(20)
- order_status — VARCHAR(30) — NOT NULL
- ordered_at — DATETIME — NOT NULL
- paid_at — DATETIME
- canceled_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
credit_product
- id — BIGINT — Primary key — NOT NULL
- product_code — VARCHAR(50) — NOT NULL
- product_name — VARCHAR(100) — NOT NULL
- price_amount — INT — NOT NULL
- base_credit_amount — INT — NOT NULL
- bonus_credit_amount — INT — NOT NULL
- total_credit_amount — INT — NOT NULL
- is_active — TINYINT — NOT NULL
- sort_order — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
listing
- id — BIGINT — Primary key — NOT NULL
- public_id — VARCHAR(6) — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- role — VARCHAR(30) — NOT NULL
- type — VARCHAR(30) — NOT NULL
- address_name — VARCHAR(255) — NOT NULL
- road_address — VARCHAR(255)
- jibun_address — VARCHAR(255)
- address_detail — VARCHAR(255)
- lat — DECIMAL(10,7)
- lng — DECIMAL(10,7)
- owner_name — VARCHAR(50)
- carrier — VARCHAR(30)
- owner_phone — VARCHAR(20)
- trade_type — VARCHAR(30)
- deposit_manwon — INT
- rent_manwon — INT
- price_manwon — INT
- dongho — VARCHAR(50)
- floor_info — VARCHAR(50)
- area_m2 — DECIMAL(10,2)
- description — LONGTEXT
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
listing_info
- code — BINARY(16) — Primary key — NOT NULL
- broker_code — BINARY(16) — Foreign key → broker_info.broker_code — NOT NULL
- listing_type — VARCHAR(50) — NOT NULL
- lat — DECIMAL(10,7) — NOT NULL
- lng — DECIMAL(10,7) — NOT NULL
- sido_code — VARCHAR(2)
- sigungu_code — VARCHAR(5)
- emd_code — VARCHAR(10)
- created_at — DATETIME — NOT NULL
listing_photo
- id — BIGINT — Primary key — NOT NULL
- listing_id — BIGINT — Foreign key → listing.id — NOT NULL
- sort_order — INT — NOT NULL
- original_filename — VARCHAR(255)
- stored_filename — VARCHAR(255) — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- mime_type — VARCHAR(100)
- file_size — BIGINT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
listing_send_history
- id — BIGINT — Primary key — NOT NULL
- listing_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- broker_phone — VARCHAR(30) — NOT NULL
- sent_at — DATETIME — NOT NULL
member_credit_balance
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → users.user_id — NOT NULL
- balance — INT — NOT NULL
- version — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
payment
- id — BIGINT — Primary key — NOT NULL
- credit_order_id — BIGINT — Foreign key → credit_order.id — NOT NULL
- pg_provider — VARCHAR(30) — NOT NULL
- payment_key — VARCHAR(200)
- method — VARCHAR(50)
- payment_status — VARCHAR(30) — NOT NULL
- requested_amount — INT — NOT NULL
- approved_amount — INT
- failure_code — VARCHAR(100)
- failure_message — VARCHAR(500)
- requested_at — DATETIME — NOT NULL
- approved_at — DATETIME
- canceled_at — DATETIME
- raw_response_json — JSON
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
user_region
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- adm_cd — VARCHAR(10) — NOT NULL
- sido_name — VARCHAR(50) — NOT NULL
- sigungu_name — VARCHAR(50) — NOT NULL
- emd_name — VARCHAR(50) — NOT NULL
- emd_lat — DECIMAL(11,8) — NOT NULL
- emd_lng — DECIMAL(11,8) — NOT NULL
- created_at — DATETIME — NOT NULL
user_social_account
- social_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- provider — VARCHAR(20) — NOT NULL
- provider_user_id — VARCHAR(128) — NOT NULL
- email — VARCHAR(255)
- nickname — VARCHAR(255)
- access_token — TEXT
- refresh_token — TEXT
- token_expires_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- phone — VARCHAR(20)
- password_hash — VARCHAR(120)
- nickname — VARCHAR(100)
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL