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