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