프로중개인
테이블 (23)
건물 (pr_building)
- Key (building_no) — int — 기본 키 — NOT NULL
- Field (land_code) — varchar
- Field (building_code) — varchar
- Field (room_code) — varchar
- Field (building_name) — varchar
- Field (building_gate1) — varchar
- Field (building_gate2) — varchar
- Field (building_pt) — varchar
- Field (building_pn) — varchar
- Field (building_memo) — varchar
- Field (building_udate) — varchar
- Field (building_utime) — varchar
- Field (building_wdate) — varchar
- Field (building_wtime) — varchar
- Field (building_del) — varchar — NOT NULL
관계자 (pr_officials)
- Key (officials_no) — int — 기본 키 — NOT NULL
- Field (client_code) — varchar
- Field (officials_code) — varchar
- Field (officials_type) — varchar
- Field (officials_name) — varchar
- Field (officials_gender) — varchar
- Field (officials_phone) — varchar
- Field (officials_memo) — varchar
- Field (officials_udate) — varchar
- Field (officials_utime) — varchar
- Field (officials_wdate) — varchar
- Field (officials_wtime) — varchar
- Field (officials_del) — varchar — NOT NULL
관계자항목 (pr_officialssub)
- Key (osub_no) — int — 기본 키 — NOT NULL
- Field (osub_code) — varchar
- Field (osub_content) — varchar
- Field (osub_del) — varchar — NOT NULL
관리자 (pr_manager)
- Key (manager_no) — int — 기본 키 — NOT NULL
- Field (building_code) — varchar
- Field (manager_code) — varchar
- Field (manager_name) — varchar
- Field (manager_phone1) — varchar
- Field (manager_phone2) — varchar
- Field (manager_gender) — varchar
- Field (manager_email) — varchar
- Field (manager_memo) — varchar
- Field (manager_udate) — varchar
- Field (manager_utime) — varchar
- Field (manager_wdate) — varchar
- Field (manager_del) — varchar — NOT NULL
매물 (pr_sale)
- Key (sale_no) — int — 기본 키 — NOT NULL
- Field (sale_code) — varchar
- Field (land_code) — varchar
- Field (building_code) — varchar
- Field (room_code) — varchar
- Field (master_code) — varchar
- Field (manager_code) — varchar
- Field (admin_id) — varchar
- Field (admin_name) — varchar
- Field (sale_title) — varchar
- Field (sale_m) — varchar
- Field (sale_udate) — varchar
- Field (sale_utime) — varchar
- Field (sale_wdate) — varchar
- Field (sale_wtime) — varchar
- Field (sale_del) — varchar — NOT NULL
상담기록 (pr_record)
- Key (record_no) — int — 기본 키 — NOT NULL
- Field (record_code) — varchar
- Field (request_code) — varchar
- Field (client_code) — varchar
- Field (record_contact1) — varchar
- Field (record_contact2) — varchar
- Field (record_memo) — varchar
- Field (record_date) — varchar
- Field (record_time) — varchar
- Field (record_udate) — varchar
- Field (record_utime) — varchar
- Field (record_wdate) — varchar
- Field (record_wtime) — varchar
- Field (record_del) — varchar — NOT NULL
소유주 (pr_master)
- Key (master_no) — int — 기본 키 — NOT NULL
- Field (land_code) — varchar
- Field (building_code) — varchar
- Field (room_code) — varchar
- Field (master_code) — varchar
- Field (master_type) — varchar
- Field (master_name) — varchar
- Field (master_phone1) — varchar
- Field (master_phone2) — varchar
- Field (master_gender) — varchar
- Field (master_memo) — varchar
- Field (master_email) — varchar
- Field (master_udate) — varchar
- Field (master_utime) — varchar
- Field (master_wdate) — varchar
- Field (master_wtime) — varchar
- Field (master_del) — varchar — NOT NULL
알림 (pr_alarm)
- Key (alarm_no) — int — 기본 키 — NOT NULL
- Field (alarm_code) — varchar
- Field (admin_bid) — varchar
- Field (admin_bname) — varchar
- Field (admin_id) — varchar
- Field (admin_name) — varchar
- Field (alarm_title) — varchar
- Field (alarm_content) — varchar
- Field (alarm_rdate) — varchar
- Field (alarm_rtime) — varchar
- Field (alarm_udate) — varchar
- Field (alarm_utime) — varchar
- Field (alarm_wdate) — varchar
- Field (alarm_wtime) — varchar
- Field (alarm_r) — varchar
- Field (alarm_del) — varchar — NOT NULL
어드민 (pr_admin)
- Key (admin_no) — int — 기본 키 — NOT NULL
- Field (admin_id) — varchar — NOT NULL
- Field (admin_pw) — varchar — NOT NULL
- Field (admin_name) — varchar — NOT NULL
- Field (admin_gender) — varchar — NOT NULL
- Field (admin_phone1) — varchar — NOT NULL
- Field (admin_phone2) — varchar — NOT NULL
- Field (admin_email) — varchar — NOT NULL
- Field (admin_part) — varchar — NOT NULL
- Field (admin_position) — varchar — NOT NULL
- Field (admin_rank) — varchar — NOT NULL
- Field (admin_udate) — varchar
- Field (admin_utime) — varchar
- Field (admin_wdate) — varchar
- Field (admin_wtime) — varchar
- Field (admin_del) — varchar — NOT NULL
유입경로(대) (pr_funnel)
- Key (funnel_no) — int — 기본 키 — NOT NULL
- Field (funnel_code) — varchar
- Field (funnel_content) — varchar
- Field (funnel_del) — varchar — NOT NULL
유입경로(소) (pr_funnelsub)
- Key (funnel_no) — int — 기본 키 — NOT NULL
- Field (funnel_code) — varchar
- Field (funnel_content) — varchar
- Field (funnel_del) — varchar — NOT NULL
의뢰 (pr_request)
- Key (request_no) — int — 기본 키 — NOT NULL
- Field (request_code) — varchar
- Field (sale_code) — varchar
- Field (land_code) — varchar
- Field (building_code) — varchar
- Field (room_code) — varchar
- Field (client_code) — varchar
- Field (object_type) — varchar
- Field (tr_type) — varchar
- Field (tr_range) — varchar
- Field (tr_target) — varchar
- Field (request_date) — varchar
- Field (request_udate) — varchar
- Field (request_utime) — varchar
- Field (request_wdate) — varchar
- Field (request_wtime) — varchar
- Field (request_t) — varchar
- Field (request_del) — varchar — NOT NULL
의뢰서브 (pr_requestsub)
- Key (request_no) — int — 기본 키 — NOT NULL
- Field (request_code) — varchar
- Field (request_main) — varchar
- Field (request_rdate) — varchar
- Field (request_room) — varchar
- Field (request_bathroom) — varchar
- Field (request_deposit1) — varchar
- Field (request_deposit2) — varchar
- Field (request_deposit3) — varchar
- Field (request_rent1) — varchar
- Field (request_rent2) — varchar
- Field (request_rent3) — varchar
- Field (request_trading) — varchar
- Field (request_ttip) — varchar
- Field (request_rtip) — varchar
- Field (request_officetel) — varchar
- Field (request_loan) — varchar
- Field (request_floor) — varchar
- Field (request_area1) — varchar
- Field (request_area2) — varchar
- Field (request_areatype1) — varchar
- Field (request_areatype2) — varchar
- Field (request_location) — varchar
- Field (request_term1) — varchar
- Field (request_term2) — varchar
- Field (request_term3) — varchar
- Field (request_funnel1) — varchar
- Field (request_funnel2) — varchar
- Field (request_funnel3) — varchar
- Field (request_contact1) — varchar
- Field (request_contact2) — varchar
- Field (request_memo) — varchar
의뢰인 (pr_client)
- Key (client_no) — int — 기본 키 — NOT NULL
- Field (client_code) — varchar
- Field (client_name) — varchar
- Field (client_phone1) — varchar
- Field (client_phone2) — varchar
- Field (client_gender) — varchar
- Field (client_memo) — varchar
- Field (client_udate) — varchar
- Field (client_utime) — varchar
- Field (client_wdate) — varchar
- Field (client_wtime) — varchar
- Field (client_del) — varchar — NOT NULL
의뢰인 추가정보 (pr_cinfo)
- Key (cinfo_no) — int — 기본 키 — NOT NULL
- Field (client_code) — varchar
- Field (cinfo_title) — varchar
- Field (cinfo_content) — varchar
- Field (cinfo_udate) — varchar
- Field (cinfo_utime) — varchar
- Field (cinfo_wdate) — varchar
- Field (cinfo_wtime) — varchar
- Field (cinfo_del) — varchar — NOT NULL
의뢰인 추가정보(부) (pr_cinfo2)
- Key (cinfo_no) — int — 기본 키 — NOT NULL
- Field (cinfo_code) — varchar
- Field (cinfo_content) — varchar
- Field (cinfo_del) — varchar — NOT NULL
의뢰인 추가정보(주) (pr_cinfo1)
- Key (cinfo_no) — int — 기본 키 — NOT NULL
- Field (cinfo_code) — varchar
- Field (cinfo_content) — varchar
- Field (cinfo_del) — varchar — NOT NULL
접촉경로(대) (pr_contact)
- Key (contact_no) — int — 기본 키 — NOT NULL
- Field (contact_code) — varchar
- Field (contact_content) — varchar
- Field (contact_del) — varchar — NOT NULL
접촉경로(소) (pr_contactsub)
- Key (contact_no) — int — 기본 키 — NOT NULL
- Field (contact_code) — varchar
- Field (contact_content) — varchar
- Field (contact_del) — varchar — NOT NULL
중요도 (pr_star)
- Key (star_no) — int — 기본 키 — NOT NULL
- Field (request_code) — varchar
- Field (request_purpose) — varchar
- Field (request_rdate) — varchar
- Field (request_deposit) — varchar
- Field (request_rent) — varchar
- Field (request_loan) — varchar
- Field (request_room) — varchar
- Field (request_bathroom) — varchar
- Field (request_area) — varchar
- Field (request_location) — varchar
- Field (request_floor) — varchar
- Field (request_term) — varchar
중요체크 (pr_important)
- Key (im_no) — int — 기본 키 — NOT NULL
- Field (request_code) — varchar
- Field (request_purpose) — varchar
- Field (request_rdate) — varchar
- Field (request_deposit) — varchar
- Field (request_rent) — varchar
- Field (request_loan) — varchar
- Field (request_room) — varchar
- Field (request_bathroom) — varchar
- Field (request_area) — varchar
- Field (request_location) — varchar
- Field (request_floor) — varchar
- Field (request_term) — varchar
층호실 (pr_room)
- Key (room_no) — int — 기본 키 — NOT NULL
- Field (land_code) — varchar
- Field (building_code) — varchar
- Field (room_code) — varchar
- Field (room_num) — varchar
- Field (room_floor) — varchar
- Field (room_nmemo) — varchar
- Field (room_gate1) — varchar
- Field (room_gate2) — varchar
- Field (room_memo) — varchar
- Field (room_udate) — varchar
- Field (room_utime) — varchar
- Field (room_wdate) — varchar
- Field (room_wtime) — varchar
- Field (room_del) — varchar — NOT NULL
토지 (pr_land)
- Key (land_no) — int — 기본 키 — NOT NULL
- Field (land_code) — varchar
- Field (building_code) — varchar
- Field (room_code) — varchar
- Field (land_do) — varchar
- Field (land_si) — varchar
- Field (land_dong) — varchar
- Field (land_jibun) — varchar
- Field (land_address) — varchar
- Field (land_memo) — varchar
- Field (land_udate) — varchar
- Field (land_utime) — varchar
- Field (land_wdate) — varchar
- Field (land_wtime) — varchar
- Field (land_del) — varchar — NOT NULL