ㅁㄴㅇㄹ

Tables (18)

tb_admin

  • admin_id — bigint — Primary key — NOT NULL
  • social_id — varchar(255)
  • member_role — enum — NOT NULL
  • email — varchar(255)
  • agency_type — enum
  • agency_name — varchar(50)
  • agency_name_en — varchar(50)
  • registration_number — varchar(30)
  • address — varchar(100)
  • adress_detail — varchar(100)
  • address_en — varchar(100)
  • agency_phone_number — varchar(50)
  • first_name — varchar(30)
  • last_name — varchar(30)
  • first_name_en — varchar(100)
  • last_name_en — varchar(100)
  • phone_number — varchar(50)
  • admin_language — List<tb_admin_language>
  • main_listing — List<tb_main_listing>
  • create_at — date — NOT NULL
  • update_at — date — NOT NULL
  • state — enum — NOT NULL

tb_admin_language

  • admin_id — bigint — Foreign key → tb_admin.admin_id — NOT NULL
  • language_type — enum — NOT NULL

tb_agent_comment

  • listing_id — bigint — Foreign key → tb_listing.listing_id — NOT NULL
  • comment — enum — NOT NULL

tb_basic_furniture

  • listing_id — bigint — Foreign key → tb_listing.listing_id — NOT NULL
  • option_name — enum — NOT NULL

tb_cart

  • cart_id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → tb_member.member_id — NOT NULL
  • listing_id — bigint — Foreign key → tb_listing.listing_id — NOT NULL
  • move_in — date — NOT NULL
  • contract_period — int — NOT NULL
  • created_at — date — NOT NULL
  • updated_at — date — NOT NULL
  • state — enum — NOT NULL

tb_contract_date

  • order_id — bigint — Foreign key → tb_order.order_id — NOT NULL
  • contract_date — date — NOT NULL

tb_contract_status

  • order_id — bigint — Foreign key → tb_order.order_id — NOT NULL
  • listing_id — bigint — Foreign key → tb_listing.listing_id — NOT NULL
  • contract_status_type — enum — NOT NULL
  • member_move_in — date — NOT NULL
  • member_contract_period — int — NOT NULL
  • member_resident_nums — int — NOT NULL
  • status_update_date — date
  • contract_date — date
  • depositor — varchar(30)
  • bank — varchar(30)
  • account — varchar(30)
  • is_remittance — bool
  • reject_reason_type — eunm
  • reject_reason — varchar(255)

tb_facility

  • listing_id — bigint — Foreign key → tb_listing.listing_id — NOT NULL
  • facility — enum — NOT NULL

tb_listing

  • listing_id — bigint — Primary key — NOT NULL
  • admin_id — bigint — Foreign key → tb_admin.admin_id — NOT NULL
  • listing_image_urls — LIST<tb_listing_image_url> — NOT NULL
  • room_type — enum — NOT NULL
  • area — double — NOT NULL
  • agent_comments — LIST<tb_agent_comment>
  • address — varchar(255) — NOT NULL
  • address_detail — varchar(255) — NOT NULL
  • address_en — varchar(255) — NOT NULL
  • longitude — double — NOT NULL
  • latitude — double — NOT NULL
  • near_subway_stations — LIST<tb_near_subway_station> — NOT NULL
  • near_university — LIST<tb_near_university>
  • room_floor — int — NOT NULL
  • total_floor — int — NOT NULL
  • is_semi_basement — bool — NOT NULL
  • is_rooftop — bool — NOT NULL
  • facilities — LIST<tb_facility> — NOT NULL
  • heating_type — enum — NOT NULL
  • window_direction_type — enum — NOT NULL
  • building_front_type — enum — NOT NULL
  • basic_furnitures — LIST<tb_basic_furniture> — NOT NULL
  • deposit — int — NOT NULL
  • monthly_rent — int — NOT NULL
  • provisional_deposit — int — NOT NULL
  • agency_fee — int
  • payment_type — enum — NOT NULL
  • maintenance_fee — int — NOT NULL
  • rent_excludes — LIST<tb_rent_exclude> — NOT NULL
  • move_in_date — date — NOT NULL
  • min_contract_period — int — NOT NULL
  • resident_nums — int — NOT NULL
  • is_visible — bool — NOT NULL
  • is_on_sale — bool — NOT NULL
  • views — bigint — NOT NULL
  • created_at — date — NOT NULL
  • updated_at — date — NOT NULL
  • state — enum — NOT NULL

tb_listing_image_url

  • listing_id — bigint — Foreign key → tb_listing.listing_id — NOT NULL
  • image_url — varchar(255) — NOT NULL

tb_main_listing

  • admin_id — bigint — Foreign key → tb_admin.admin_id — NOT NULL
  • main_listing_type — enum — NOT NULL

tb_member

  • member_id — bigint — Primary key — NOT NULL
  • member_role — enum — NOT NULL
  • email — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • first_name — varchar(100) — NOT NULL
  • last_name — varchar(100) — NOT NULL
  • gender_type — enum — NOT NULL
  • birth — date — NOT NULL
  • phone_number — varchar(50) — NOT NULL
  • country_code — char(2) — NOT NULL
  • nationality — varchar(50) — NOT NULL
  • occupation_type — enum — NOT NULL
  • visa_type — enum — NOT NULL
  • read_notification_at — date — NOT NULL
  • created_at — date — NOT NULL
  • updated_at — date — NOT NULL
  • state — enum — NOT NULL

tb_near_subway_station

  • listing_id — bigint — Foreign key → tb_listing.listing_id — NOT NULL
  • subway_station — varchar(30) — NOT NULL
  • duration — int — NOT NULL

tb_near_university

  • listing_id — bigint — Foreign key → tb_listing.listing_id — NOT NULL
  • university_name — enum — NOT NULL

tb_notification

  • notification_id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → tb_member.member_id — NOT NULL
  • notification_type — enum — NOT NULL
  • title — varchar(100) — NOT NULL
  • description — varchar(255) — NOT NULL
  • order_id — bigint
  • created_at — date — NOT NULL
  • updated_at — date — NOT NULL
  • state — enum — NOT NULL

tb_order

  • order_id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → tb_member.member_id — NOT NULL
  • order_status_type — enum — NOT NULL
  • contract_statuses — LIST<tb_contract_status> — NOT NULL
  • email — varchar(255) — NOT NULL
  • first_name — varchar(100) — NOT NULL
  • last_name — varchar(100) — NOT NULL
  • gender — enum — NOT NULL
  • birth — date — NOT NULL
  • phone_number — varchar(50) — NOT NULL
  • country_code — char(2) — NOT NULL
  • nationality — varchar(50) — NOT NULL
  • occupation_type — enum — NOT NULL
  • visa_type — enum — NOT NULL
  • passport_number — varchar(30) — NOT NULL
  • contract_dates — LIST<tb_contract_date> — NOT NULL
  • payment_type — enum — NOT NULL
  • sub_total — int — NOT NULL
  • commission — int — NOT NULL
  • refund — tb_refund
  • pay_token — varchar(255) — NOT NULL
  • created_at — date — NOT NULL
  • updated_at — date — NOT NULL
  • state — enum — NOT NULL

tb_refund

  • refund_id — bigint — Primary key — NOT NULL
  • order_id — bigint — Foreign key → tb_order.order_id — NOT NULL
  • refund_type — enum — NOT NULL
  • payment_type — enum — NOT NULL
  • adjusted_contract_fee — int — NOT NULL
  • adjusted_commission — int — NOT NULL
  • refund_amount — int — NOT NULL
  • created_at — date — NOT NULL
  • updated_at — date — NOT NULL
  • INACTIVE — enum — NOT NULL

tb_rent_excludes

  • listing_id — bigint — Foreign key → tb_listing.listing_id — NOT NULL
  • item_name — enum — NOT NULL