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