example

Tables (29)

flyway_schema_history

  • installed_rank — int — Primary key — NOT NULL
  • version — varchar(50)
  • description — varchar(200) — NOT NULL
  • type — varchar(20) — NOT NULL
  • script — varchar(1000) — NOT NULL
  • checksum — int
  • installed_by — varchar(100) — NOT NULL
  • installed_on — timestamp — NOT NULL
  • execution_time — int — NOT NULL
  • success — tinyint(1) — NOT NULL

tb_admin_language

  • adminLanguageId — bigint — Primary key — NOT NULL
  • admin_id — bigint — Foreign key → 중개인.중개인 ID — NOT NULL
  • admin_language_type — int — NOT NULL

tb_admin_managers

  • admin_manager_id — bigint — Primary key — NOT NULL
  • admin_id — bigint — Foreign key → 중개인.중개인 ID — NOT NULL
  • manager_name — varchar(255) — NOT NULL
  • phone_number — varchar(50) — NOT NULL

tb_agent_comment

  • agentCommentId — bigint — Primary key — NOT NULL
  • listing_id — bigint — Foreign key → tb_listing.listing_id — NOT NULL
  • agent_comment_type — int — NOT NULL

tb_basic_furniture

  • BasicFurnitureId — bigint — Primary key — NOT NULL
  • listing_id — bigint — Foreign key → tb_listing.listing_id — NOT NULL
  • basic_furniture_type — int — NOT NULL

tb_cart

  • cart_id — bigint — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • state — varchar(10) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • contract_period — int — NOT NULL
  • move_in — date — NOT NULL
  • listing_id — bigint — Foreign key → tb_listing.listing_id
  • member_id — bigint — Foreign key → 일반회원.일반회원 ID

tb_contract_date

  • contractDateId — bigint — Primary key — NOT NULL
  • order_id — bigint — Foreign key → tb_order_core.order_id — NOT NULL
  • member_contract_date — datetime(6) — NOT NULL

tb_contract_status

  • contractStatusId — bigint — Primary key — NOT NULL
  • order_id — bigint — Foreign key → tb_order_core.order_id — NOT NULL
  • account — varchar(30)
  • bank — varchar(30)
  • contract_date — datetime(6)
  • contract_status_type — int — NOT NULL
  • depositor — varchar(30)
  • is_remittance — char(1)
  • member_contract_period — int — NOT NULL
  • member_move_in — date — NOT NULL
  • member_resident_nums — int — NOT NULL
  • reject_reason — varchar(255)
  • reject_reason_type — int
  • status_update_date — datetime(6) — NOT NULL
  • listing_id — bigint — Foreign key → tb_listing.listing_id
  • is_notification_sent — char(1) — 가계약알림전송. 전송되었을 경우 Y, 전송되지않았을 경우 N
  • priority — int — 장바구니에 담긴 가계약 건에 대한 우선순위를 지정하여 앞 번호 순으로 결제를 진행합니다

tb_coupon_usage

  • coupon_usage_id — bigint — Primary key — NOT NULL
  • coupon_id — bigint — Foreign key → 쿠폰.쿠폰 ID — NOT NULL
  • member_id — bigint — Foreign key → 일반회원.일반회원 ID — NOT NULL
  • order_id — bigint — Foreign key → tb_order_core.order_id — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • state — varchar(10) — NOT NULL

tb_facility

  • facilityId — bigint — Primary key — NOT NULL
  • listing_id — bigint — Foreign key → tb_listing.listing_id — NOT NULL
  • facility_type — int — NOT NULL

tb_listing

  • listing_id — bigint — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • state — varchar(10) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • address — varchar(255) — NOT NULL
  • address_detail — varchar(255) — NOT NULL
  • address_en — varchar(255) — NOT NULL
  • agency_fee — int
  • area — double — NOT NULL
  • building_front_type — int — NOT NULL
  • deposit — int — NOT NULL
  • heating_type — int — NOT NULL
  • is_on_sale — char(1) — NOT NULL
  • is_semi_basement — char(1) — NOT NULL
  • is_visible — char(1) — NOT NULL
  • latitude — double — NOT NULL
  • longitude — double — NOT NULL
  • maintenance_fee — int — NOT NULL
  • min_contract_period — int — NOT NULL
  • monthly_rent — int — NOT NULL
  • move_in_date — date — NOT NULL
  • payment_type — int — NOT NULL
  • provisional_deposit — int — NOT NULL
  • resident_nums — int — NOT NULL
  • room_floor — int
  • room_type — int — NOT NULL
  • total_floor — int — NOT NULL
  • views — bigint — NOT NULL
  • window_direction_type — int — NOT NULL
  • admin_id — bigint — Foreign key → 중개인.중개인 ID
  • is_rooftop — char(1) — NOT NULL
  • agent_comment_detail_kr — varchar(200)
  • agent_comment_detail_en — varchar(500)
  • building_use_approval_date — date — NOT NULL — 기존 레코드에 디폴트 값 임의 지정이 어려워 임시로 Null 허용(추후 Not Null 변경 예정)
  • is_illegal_construction — char(1) — NOT NULL — 기존 레코드에 디폴트 값 임의 지정이 어려워 임시로 Null 허용(추후 Not Null 변경 예정)
  • has_parking_lot — char(1) — NOT NULL — 기존 레코드에 디폴트 값 임의 지정이 어려워 임시로 Null 허용(추후 Not Null 변경 예정)
  • parking_lot_count — int
  • bathroom_count — int — NOT NULL — 기존 레코드에 디폴트 값 임의 지정이 어려워 임시로 Null 허용(추후 Not Null 변경 예정)
  • room_count — int — NOT NULL — 기존 레코드에 디폴트 값 임의 지정이 어려워 임시로 Null 허용(추후 Not Null 변경 예정)
  • rental_type — int — NOT NULL — 기존 레코드에 디폴트 값 임의 지정이 어려워 임시로 Null 허용(추후 Not Null 변경 예정)
  • maintenance_fee_breakdown_kr — varchar(600)
  • maintenance_fee_breakdown_en — varchar(600)
  • agent_comment_detail_zh — varchar(500)
  • agent_comment_detail_vi — varchar(500)
  • maintenance_fee_breakdown_zh — varchar(600)
  • maintenance_fee_breakdown_vi — varchar(600)
  • is_translate_succeed — char(1) — NOT NULL

tb_listing_admin_managers

  • listing_admin_manager_id — bigint — Primary key — NOT NULL
  • listing_id — bigint — Foreign key → tb_listing.listing_id — NOT NULL
  • admin_manager_id — bigint — Foreign key → tb_admin_managers.admin_manager_id — NOT NULL

tb_listing_building_registered_use_type

  • listing_building_registered_use_type_id — bigint — Primary key — NOT NULL
  • listing_id — bigint — Foreign key → tb_listing.listing_id — NOT NULL
  • building_registered_use_type — int — NOT NULL

tb_listing_image_url

  • imageOrderId — bigint — Primary key — NOT NULL
  • listing_id — bigint — Foreign key → tb_listing.listing_id — NOT NULL
  • image_url — varchar(1000) — NOT NULL

tb_main_listing

  • mainListingId — bigint — Primary key — NOT NULL
  • admin_id — bigint — Foreign key → 중개인.중개인 ID — NOT NULL
  • main_listing_type — int — NOT NULL

tb_member_billing_card

  • billing_card_id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → 일반회원.일반회원 ID — NOT NULL
  • card_kind — varchar(50) — NOT NULL
  • card_no — varchar(50) — NOT NULL
  • poq_token — varchar(255) — NOT NULL
  • is_default — char(1) — NOT NULL
  • state — varchar(10) — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL

tb_near_subway_station

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

tb_near_university

  • nearUniversityId — bigint — Primary key — NOT NULL
  • listing_id — bigint — Foreign key → tb_listing.listing_id — NOT NULL
  • university_type — int — NOT NULL

tb_notification

  • notification_id — bigint — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • state — varchar(10) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • description — varchar(255) — NOT NULL
  • notification_type — int — NOT NULL
  • order_id — bigint
  • title — varchar(100) — NOT NULL
  • member_id — bigint — Foreign key → 일반회원.일반회원 ID — NOT NULL

tb_order

  • order_id — bigint — Primary key — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • state — varchar(10) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL
  • birth — date — NOT NULL
  • commission — int — NOT NULL
  • country_code — varchar(2) — NOT NULL
  • email — varchar(255) — NOT NULL
  • first_name — varchar(100) — NOT NULL
  • gender — int — NOT NULL
  • last_name — varchar(100) — NOT NULL
  • nationality — varchar(50) — NOT NULL
  • occupation_type — int — NOT NULL
  • order_status_type — int — NOT NULL
  • passport_number — varchar(30) — NOT NULL
  • pay_token — varchar(255) — NOT NULL
  • payment_type — int — NOT NULL
  • phone_number — varchar(255) — NOT NULL
  • sub_total — int — NOT NULL
  • visa_type — int — NOT NULL
  • member_id — bigint — Foreign key → 일반회원.일반회원 ID — NOT NULL
  • refund_id — bigint — Foreign key → 환불.환불 ID
  • discount — int — NOT NULL

tb_order_billing_key

  • order_id — bigint — Foreign key → tb_order_core.order_id — NOT NULL
  • poq_token — varchar(255) — NOT NULL

tb_order_core

  • order_id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → 일반회원.일반회원 ID — NOT NULL
  • payment_type — int — NOT NULL
  • pay_token — varchar(255)
  • refund_id — bigint
  • order_type — int — NOT NULL
  • pay_amt — int — NOT NULL
  • state — varchar(10) — NOT NULL
  • createdAt — datetime(6) — NOT NULL
  • updatedAt — datetime(6) — NOT NULL

tb_order_core_detail

  • order_id — bigint — Foreign key → tb_order_core.order_id — NOT NULL
  • birth — date — NOT NULL
  • commission — int — NOT NULL
  • country_code — varchar(2) — NOT NULL
  • email — varchar(255) — NOT NULL
  • first_name — varchar(100) — NOT NULL
  • gender — int — NOT NULL
  • last_name — varchar(100) — NOT NULL
  • nationality — varchar(50) — NOT NULL
  • occupation_type — int — NOT NULL
  • order_status_type — int — NOT NULL
  • passport_number — varchar(30) — NOT NULL
  • phone_number — varchar(255) — NOT NULL
  • sub_total — int — NOT NULL
  • visa_type — int — NOT NULL
  • discount — int — NOT NULL
  • billing_card_id — bigint — Foreign key → tb_member_billing_card.billing_card_id
  • order_detail_update_date — datetime(6) — NOT NULL
  • coupon_id — bigint — Foreign key → 쿠폰.쿠폰 ID

tb_rent_excludes

  • rentExcludesId — bigint — Primary key — NOT NULL
  • listing_id — bigint — Foreign key → tb_listing.listing_id — NOT NULL
  • rent_excludes_type — int — NOT NULL

일반회원 (tb_member)

  • 일반회원 ID (member_id) — bigint — Primary key — NOT NULL
  • 멤버 권한 (member_role) — enum — NOT NULL
  • email — varchar(255)
  • 비밀번호 (password) — varchar(255)
  • 이름 (first_name) — varchar(100)
  • 성 (last_name) — varchar(100)
  • 생년월일 (birth) — date
  • 국가 코드 (country_code) — varchar(2)
  • 성별 (gender) — enum
  • 국적 (nationality) — enum
  • 직업 구분 (occupation_type) — enum
  • 연락처 (phone_number) — varchar(255)
  • 알림 열람 시간 (read_notification_at) — datetime(6) — NOT NULL
  • 비자 구분 (visa_type) — enum
  • marketing_consent — char(1) — NOT NULL
  • 생성일자 (createdAt) — datetime(6) — NOT NULL
  • 수정일자 (updatedAt) — datetime(6) — NOT NULL
  • 상태 (state) — enum — NOT NULL

중개인 (tb_admin)

  • 중개인 ID (admin_id) — bigint — Primary key — NOT NULL
  • 소셜 ID (social_id) — varchar(255)
  • 비밀번호 (password) — varchar(255)
  • 멤버 권한 (member_role) — enum — NOT NULL
  • email — varchar(255)
  • 중개사 타입 (agency_type) — enum
  • 중개사 이름 (agency_name) — varchar(50)
  • 중개사 영문 이름 (agency_name_en) — varchar(50)
  • 중개사 연락처 (acency_phone_number) — varchar(50)
  • 부동산 등록 번호 (registration_number) — varchar(30)
  • 주소 (address) — varchar(100)
  • 주소 상세 (address_detail) — varchar(100)
  • 영문 주소 (address_en) — varchar(100)
  • 이름 (first_name) — varchar(30)
  • 성 (last_name) — varchar(30)
  • 이름(영문) (first_name_en) — varchar(100)
  • 성(영문) (last_name_en) — varchar(100)
  • 연락처 (phone_number) — varchar(50)
  • 로그인 형식 (login_type) — enum
  • 생성일자 (createdAt) — datetime(6) — NOT NULL
  • 수정일자 (updatedAt) — datetime(6) — NOT NULL
  • 상태 (state) — varchar(10) — NOT NULL

최고관리자 (tb_checkmate_admin)

  • 최고관리자 ID (admin_id) — bigint — Primary key — NOT NULL
  • 계정 아이디 (account_id) — varchar(255) — NOT NULL
  • 멤버 권한 (member_role) — varchar(255) — NOT NULL
  • 비밀번호 (password) — varchar(255) — NOT NULL

쿠폰 (tb_coupon)

  • 쿠폰 ID (coupon_id) — bigint — Primary key — NOT NULL
  • 쿠폰코드 (code) — varchar(50) — NOT NULL
  • 할인유형 (discount_type) — int — NOT NULL
  • 할인값 (discount_value) — int — NOT NULL
  • 쿠폰만료일시 (expires_at) — datetime(6) — NOT NULL
  • 생성일자 (createdAt) — datetime(6) — NOT NULL
  • 수정일자 (updatedAt) — datetime(6) — NOT NULL
  • 상태 (state) — varchar(10) — NOT NULL
  • 설명 (description) — varchar(255)
  • 쿠폰시작일시 (starts_at) — datetime(6) — NOT NULL
  • 쿠폰명 (title) — varchar(100) — NOT NULL

환불 (tb_refund)

  • 환불 ID (refund_id) — bigint — Primary key — NOT NULL
  • adjusted_commission — int — NOT NULL
  • adjusted_contract_fee — int — NOT NULL
  • payment_type — int — NOT NULL
  • refund_amount — int — NOT NULL
  • refund_type — int — NOT NULL
  • 생성일자 (createdAt) — datetime(6) — NOT NULL
  • 수정일자 (updatedAt) — datetime(6) — NOT NULL
  • 상태 (state) — varchar(10) — NOT NULL