프로중개인

테이블 (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