property-service

Tables (17)

building (건물)

  • building_id (buildingId) — BIGINT (AutoIncrease) — Primary key — NOT NULL — 건물 ID
  • poc_office_id (pocOfficeId) — BIGINT — NOT NULL — 담당 중개사무소 ID
  • building_name (buildingName) — VARCHAR(255) — 건물 이름
  • zone_code (zoneCode) — VARCHAR(5) — NOT NULL — 우편번호
  • address — VARCHAR(255) — NOT NULL — 주소
  • jibun_address (jibunAddress) — VARCHAR(255) — 지번주소
  • completion_year (completionYear) — INT — NOT NULL — 준공연도
  • building_type (buildingType) — VARCHAR(255) — NOT NULL — 건물 용도
  • floor_count (floorCount) — VARCHAR(255) — NOT NULL — 층 수
  • parking_area_count (parkingAreaCount) — INT — NOT NULL — 총 주차대수
  • elevator_count (elevatorCount) — INT — NOT NULL — 엘레베이터 개수
  • main_door_direction (mainDoorDirection) — VARCHAR(255) — 건물 출입문 방향
  • common_password (commonPassword) — VARCHAR(255) — 공동현관물 비밀번호
  • has_illegal (hasIllegal) — BOOLEAN — NOT NULL — 위반건축물 여부
  • created_date (createdDate) — DATETIME — NOT NULL — 생성일
  • modified_date (modifiedDate) — DATETIME — 수정일
  • created_by_user_id (createdByUserId) — BIGINT — 생성자 ID
  • modified_by_user_id (modifiedByUserId) — BIGINT — 수정자 ID

building_photos (건물 사진)

  • building_photo_id (buildingPhotoId) — BIGINT (AutoIncrease) — Primary key — NOT NULL — 건물 사진 ID
  • building_id (buildingId) — BIGINT — Foreign key → building.building_id — NOT NULL — 건물 ID
  • is_main (isMain) — BOOLEAN — NOT NULL — 썸네일
  • photo_url (photoUrl) — TEXT — NOT NULL — 사진 경로
  • created_date (createdDate) — DATETIME — NOT NULL — 생성일
  • modified_date (modifiedDate) — DATETIME — 수정일
  • created_by_user_id (createdByUserId) — BIGINT — 생성자 ID
  • modified_by_user_id (modifiedByUserId) — BIGINT — 수정자 ID

building_remark (건물 특이사항)

  • building_remark_id (buildingRemarkId) — BIGINT (AutoIncrease) — Primary key — NOT NULL — 건물 특이사항 ID
  • building_id (buildingId) — BIGINT — Foreign key → building.building_id — NOT NULL — 건물 ID
  • building_remark (buildingRemark) — VARCHAR(255) — NOT NULL — 특이사항
  • created_date (createdDate) — DATETIME — NOT NULL — 생성일
  • modified_date (modifiedDate) — DATETIME — 수정일
  • created_by_user_id (createdByUserId) — BIGINT — 생성자 ID
  • modified_by_user_id (modifiedByUserId) — BIGINT — 수정자 ID

client (고객)

  • client_id (clientID) — BIGINT (AutoIncrease) — Primary key — NOT NULL — 고객 ID
  • office_user_id (officeUserId) — BIGINT — Foreign key → office_users.office_user_id — NOT NULL — 담당자 ID
  • office_id (officeId) — BIGINT — Foreign key → office_users.office_id — NOT NULL — 담당 중개사무소ID
  • client_status (clientStatus) — INT — NOT NULL — 고객 상태
  • client_name (clientName) — VARCHAR(255) — 고객 이름
  • client_phone_number (clientPhoneNumber) — VARCHAR(255) — NOT NULL — 고객 핸드폰 번호
  • client_gender (clientGender) — INT — NOT NULL — 고객 성별
  • client_source (clientSource) — VARCHAR(255) — 고객 유입경로
  • client_type (clientType) — VARCHAR(255) — 고객 유형
  • client_expected_move_in_date (clientExpectedMoveInDate) — DATE — 입주 희망일
  • created_date (createdDate) — DATETIME — NOT NULL — 생성일
  • modified_date (modifiedDate) — DATETIME — 수정일
  • created_by_user_id (createdByUserId) — BIGINT — 생성자 ID
  • modified_by_user_id (modifiedByUserId) — BIGINT — 수정자 ID

client_expected_transaction_type (고객 입주 희망 유형)

  • client_expected_transaction_type_id (clientExpectedTransactionTypeId) — BIGINT (AutoIncrease) — Primary key — NOT NULL — 입주 희망 유형 ID
  • client_id (clientId) — BIGINT — Foreign key → client.client_id — NOT NULL — 고객 ID
  • expected_transaction_type (expectedTransactionType) — INT — NOT NULL — 입주 희망 유형

client_remark (고객 특이사항)

  • client_remark_id (clientRemarkId) — BIGINT (AutoIncrease) — Primary key — NOT NULL — 고객 특이사항 ID
  • client_id (clientId) — BIGINT — Foreign key → client.client_id — NOT NULL — 고객 ID
  • client_remark (clientRemark) — VARCHAR(255) — NOT NULL — 고객 특이사항
  • created_date (createdDate) — DATETIME — NOT NULL — 생성일
  • modified_date (modifiedDate) — DATETIME — 수정일
  • created_by_user_id (CreatedByUserId) — BIGINT — 생성자 ID
  • modified_by_user_id (modifiedByUserID) — BIGINT — 수정자 ID

office (중개 사무소)

  • office_id (id) — BIGINT (AutoIncrease) — Primary key — NOT NULL — 중개사무소Id
  • office_code (officeCode) — VARCHAR(255) — 중개사무소 코드
  • office_name (officeName) — VARCHAR(255) — NOT NULL — 중개사무소 상호명
  • zonecode (zoneCode) — VARCHAR(5) — NOT NULL — 우편번호
  • office_address (officeAddress) — VARCHAR(255) — NOT NULL — 주소
  • address_detail (addressDetail) — VARCHAR(255) — 상세주소
  • president_name (presidentName) — VARCHAR(255) — 대표자명
  • president_email (presidentEmail) — VARCHAR(255) — 대표자 이메일
  • mobile_number (mobileNumber) — VARCHAR(255) — 대표자 핸드폰번호
  • phone_number (phoneNumber) — VARCHAR(255) — 전화번호

office_users (사용자)

  • office_user_id (officeUserId) — BIGINT (AutoIncrease) — Primary key — NOT NULL — 사용자 ID
  • office_id (officeId) — BIGINT — Foreign key → office.office_id — NOT NULL — 중개사무소ID
  • name — VARCHAR(255) — NOT NULL — 이름
  • email — VARCHAR(255) — NOT NULL — 이메일
  • password_hash (passwordHash) — TEXT — NOT NULL — 비밀번호
  • phone_number (phoneNumber) — VARCHAR(255) — 핸드폰번호
  • role — INT — NOT NULL — 권한 수준

property (매물)

  • property_id (propertyId) — BIGINT (AutoIncrease) — Primary key — NOT NULL — 매물 ID
  • building_id (buildingId) — BIGINT — Foreign key → building.building_id — NOT NULL — 빌딩 ID
  • office_user_id (officeUserId) — BIGINT — Foreign key → office_users.office_user_id — NOT NULL — 담당자 ID
  • property_status (propertyStatus) — VARCHAR(255) — NOT NULL — 매물 상태
  • owner_name (ownerName) — VARCHAR(255) — 임대인 이름
  • owner_phone_number (ownerPhoneNumber) — VARCHAR(255) — NOT NULL — 임대인 전화번호
  • owner_relation (ownerRelation) — VARCHAR(255) — 임대인 관계
  • property_room_number (propertyRoomNumber) — VARCHAR(255) — NOT NULL — 매물 호수
  • property_type (propertyType) — VARCHAR(255) — NOT NULL — 매물 유형
  • property_floor (propertyFloor) — VARCHAR(255) — 매물 층 수
  • room_bath_count (roomBathCount) — VARCHAR(255) — NOT NULL — 방/욕실 개수
  • main_room_direction (mainRoomDirection) — VARCHAR(64) — NOT NULL — 주실기준 방향
  • exclusive_area (exclusiveArea) — DOUBLE — 전용면적(m2)
  • supply_area (supplyArea) — DOUBLE — 공급면적(m2)
  • approval_date (approvalDate) — DATE — 사용승인일
  • move_in_date (moveInDate) — DATE — 입주일
  • move_out_date (moveOutDate) — DATE — 퇴실일
  • available_move_in_date (availableMoveInDate) — DATE — 입주 가능 일
  • heating_type (heatingType) — HeatingType — NOT NULL — 난방 방식
  • maintenance_price (maintenancePrice) — DECIMAL — 관리비

property_maintenance_items (매물 관리비 항목)

  • property_maintenance_item_id (propertyMaintenanceItemId) — BIGINT (AutoIncrease) — Primary key — NOT NULL — 관리비 항목 ID
  • property_id (propertyId) — BIGINT — Foreign key → property.property_id — NOT NULL — 매물 ID
  • maintenance_item (maintenanceItem) — VARCHAR(255) — 관리비 항목

property_options (매물 옵션 항목)

  • property_option_id (propertyOptionId) — BIGINT (AutoIncrease) — Primary key — NOT NULL — 매물 옵션 ID
  • property_id (propertyId) — BIGINT — Foreign key → property.property_id — NOT NULL — 매물 ID
  • option_item_type (optionItemType) — VARCHAR(255) — 옵션 항목

property_photos (매물 사진)

  • property_photo_id (propertyPhotoId) — BIGINT (AutoIncrease) — Primary key — NOT NULL — 매물 사진 ID
  • property_id (propertyId) — BIGINT — Foreign key → property.property_id — NOT NULL — 매물 ID
  • is_main (isMain) — BOOLEAN — NOT NULL — 썸네일
  • photo_url (photoUrl) — TEXT — NOT NULL — 사진 경로
  • created_date (createdDate) — DATETIME — NOT NULL — 생성일
  • modified_date (modifiedDate) — DATETIME — 수정일
  • created_by_user_id (createdByUserId) — BIGINT — 생성자 ID
  • modified_by_user_id (modifiedByUserId) — BIGINT — 수정자 ID

property_remark (매물 특이사항)

  • property_remark_id (propertyRemarkId) — BIGINT (AutoIncrease) — Primary key — NOT NULL — 매물 특이사항 ID
  • property_id (propertyId) — BIGINT — Foreign key → property.property_id — NOT NULL — 매물 ID
  • property_remark (propertyRemark) — VARCHAR(255) — NOT NULL — 특이사항
  • created_date (createdDate) — DATETIME — NOT NULL — 생성일
  • modified_date (modifiedDate) — DATETIME — 수정일
  • created_by_user_id (createdByUserId) — BIGINT — 생성자 ID
  • modified_by_user_id (modifiedByUserId) — BIGINT — 수정자 ID

property_transaction_types (매물 거래 유형)

  • property_transaction_type_id (propertyTransactionTypeId) — BIGINT (AutoIncrease) — Primary key — NOT NULL — 매물 거래 유형 ID
  • property_id (propertyId) — BIGINT — Foreign key → property.property_id — NOT NULL — 매물 ID
  • transaction_type (transactionType) — VARCHAR(255) — 거래 유형
  • price1 — DECIMAL — 가격 1 (전세금, 보증금)
  • price2 — DECIMAL — 가격 2 (월세)

revenues (매출)

  • revenue_id (revenueId) — BIGINT (AutoIncrease) — Primary key — NOT NULL — 매출 ID
  • office_user_id (officeUserId) — BIGINT — Foreign key → office_users.office_user_id — NOT NULL — 사용자 ID
  • client_id (clientId) — BIGINT — NOT NULL — 고객 ID
  • property_id (propertyId) — BIGINT — NOT NULL — 매물 ID
  • property_transaction_type_id (propertyTransactionalFeeId) — BIGINT — NOT NULL — 매물 거래유형 ID
  • commision_fee (commisionFee) — DECIMAL — 중개 수수료
  • created_date (createdDate) — DATETIME — NOT NULL — 생성일
  • modified_date (modifiedDate) — DATETIME — 수정일
  • created_by_user_id (createdByUserId) — BIGINT — 생성자 ID
  • modified_by_user_id (modifiedByUserId) — BIGINT — 수정자 ID

schedule (일정)

  • schedule_id (scheduleId) — BIGINT (AutoIncrease) — Primary key — NOT NULL — 일정 ID
  • office_user_id (officeUserId) — BIGINT — Foreign key → office_users.office_user_id — NOT NULL — 사용자 ID
  • schedule_date (scheduleDate) — DATETIME — 일자
  • client_id (clientId) — BIGINT — NOT NULL — 고객 ID
  • schedule_type (scheduleType) — VARCHAR(255) — NOT NULL — 일정 유형
  • schedule_remark (scheduleRemark) — VARCHAR(255) — 일정 특이사항
  • is_completed (isCompleted) — BOOLEAN — NOT NULL — 완료 여부
  • created_date (createdDate) — DATETIME — NOT NULL — 생성일
  • modified_date (modifiedDate) — DATETIME — 수정일
  • created_by_user_id (createdByUserId) — BIGINT — 생성자 ID
  • modified_by_user_id (modifiedByUserId) — BIGINT — 수정자 ID

showing_properties (보여줄 매물)

  • showing_property_id (showingPropertyId) — BIGINT (AutoIncrease) — Primary key — NOT NULL — 보여줄 매물 ID
  • client_id (clientId) — BIGINT — Foreign key → client.client_id — NOT NULL — 고객 ID
  • property_id (propertyId) — BIGINT — Foreign key → property.property_id — NOT NULL — 매물 ID
  • office_user_id (officeUserId) — BIGINT — Foreign key → client.office_user_id — NOT NULL — 사용자 ID
  • office_id (officeId) — BIGINT — Foreign key → client.office_id — NOT NULL — 중개사무소ID
  • property_transaction_type_id (propertyTransactionTypeId) — BIGINT — NOT NULL — 매물 거래유형 ID