측량시스템

테이블 (17)

단말기 사용자 정보 (sap_endpoint_user)

  • lpi_idx — bigserial — 기본 키 — NOT NULL
  • Key2 (user_id) — varchar — 기본 키 — NOT NULL
  • Key (device_type) — smallint — 기본 키 — NOT NULL
  • user_type — smallint — 1: 관리자 2: 유저
  • user_id (access_key) — text
  • os_type — smallint
  • access_key (device_id) — varchar
  • Field5 (created_at) — timestamp
  • Field (updated_at) — timestamp

도크 작업 세션 정보 (sap_dock_job_session)

  • Key (lpi_idx) — bigint — 기본 키 — NOT NULL
  • Field (sdi_idx) — bigint
  • Field (session_id) — varchar

도크 정보 (sap_dock_info)

  • Key (sdi_idx) — bigserial — 기본 키 — NOT NULL
  • Field (lpi_idx) — bigint
  • Field (epc) — varchar
  • Field (dock_name) — varchar
  • Field (dock_number) — varchar
  • Field (dock_code) — varchar
  • Field (zone_id) — varchar
  • Field (identifier) — varchar
  • Field (status) — smallint — 1: empty 2: working 3: pending 4: error
  • Field (creator_id) — varchar
  • Field (updater_id) — varchar
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp
  • Field (active_flag) — boolean
  • Field (delete_flag) — boolean

도크 허가 요청 내역 (sap_dock_job_approval_history)

  • Key (sdjah_idx) — bigserial — 기본 키 — NOT NULL
  • Field (sdi_idx) — bigint
  • Field (lpi_idx) — bigint
  • Field (requester_id) — varchar
  • Field (processor_id) — varchar
  • Field (identifier) — varchar
  • Field (file_idx) — bigint
  • Field (status) — smallint — 1: pending 2:approved 3:rejected
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

로그 (sap_all_log)

  • Key (sal_idx) — bigserial — 기본 키 — NOT NULL
  • Field (lpi_idx) — bigint
  • Field (type) — smallint
  • Field (json_str) — jsonb
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

상차 처리 (sap_action)

  • Key (sa_idx) — bigserial — 기본 키 — NOT NULL
  • Field (lpi_idx) — bigint
  • Field (vehicle_id) — varchar
  • Field (sdi_idx) — bigint
  • Field (identifier) — varchar
  • Field (action_tp) — smallint — 1: 상차
  • Field (status) — smallint — 1: 상차 2: 상차완료
  • Field (processor_id) — varchar
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp

식별자 정보 (sap_identifier_info)

  • Key (sii_idx) — bigserial — 기본 키 — NOT NULL
  • Field (lpi_idx) — bigint
  • Field (json_str) — jsonb

용어사전 (sap_terms_dictionary)

  • Key (std_idx) — bigserial — 기본 키 — NOT NULL
  • Field (lpi_idx) — bigint
  • Field (json_str) — jsonb

장비 명령 정보 (sap_equipment_command)

  • Key (sec_idx) — bigserial — 기본 키 — NOT NULL
  • Field (se_idx) — bigint
  • Field (command_type) — varchar
  • Field (control_path) — varchar

장비 정보 (sap_equipment)

  • Key (se_idx) — bigserial — 기본 키 — NOT NULL
  • Field (lpi_idx) — bigint
  • Field (sdi_idx) — bigint
  • Field (name) — varchar
  • Field (type) — smallint — 1: BEACON
  • Field (ip_address) — varchar
  • Field (port) — smallint
  • Field (protocol) — smallint — 1: HTTP
  • Field (description) — text
  • Field (status) — smallint — 0: 정상 1:에러
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp
  • Field (active_flag) — boolean
  • Field (delete_flag) — boolean

측량 내역 (sap_measurement_history)

  • Key (sml_idx) — bigserial — 기본 키 — NOT NULL
  • Field (lpi_idx) — bigint
  • Field (identifier) — varchar
  • Field (logistics_product_id) — varchar
  • Field (vehicle_id) — varchar
  • Field (load_weight) — numeric
  • Field (load_width) — numeric
  • Field (load_height) — numeric
  • Field (load_depth) — numeric
  • Field (status) — smallint — 1: 측량

패킹리스트 내 물류 데이터 (sap_logistics_object_check_data)

  • Key (slocd_idx) — bigserial — 기본 키 — NOT NULL
  • Field (project_idx) — bigint
  • Field (sloch_idx) — bigint
  • Field (slocf_idx) — bigint
  • Field (sloci_idx) — bigint
  • Field (lpfl_idx) — bigint
  • Field (logistics_id) — varchar
  • Field (lot_number) — varchar
  • Field (json_str) — jsonb
  • Field (status) — smallint
  • Field (load_weight) — numeric
  • Field (vision_width) — numeric
  • Field (vision_height) — numeric
  • Field (vision_depth) — numeric
  • Field (sortno) — smallint
  • Field (chk) — smallint — 0: 측량 전 1: 진행 중 2:측량 3: 수동측량
  • Field (pl_matrix) — text
  • Field (qr) — varchar
  • Field (identifier) — varchar
  • Field (create_id) — varchar
  • Field (update_id) — varchar
  • Field (create_date) — timestamp
  • Field (update_date) — timestamp
  • Field (active_flag) — boolean
  • Field (delete_flag) — boolean

패킹리스트 작업(어떤 용도일까..) (sap_logistics_object_check_work)

  • Key (slocw_idx) — bigserial — 기본 키 — NOT NULL
  • Field (project_idx) — bigint
  • Field (vehicle_id) — varchar
  • Field (vidx) — bigint
  • Field (slocd_idx) — bigint
  • Field (json_str) — jsonb
  • Field (create_date) — timestamp

패킹리스트 작업자 (sap_logistics_object_check_hinfo)

  • Key (sloci_idx) — bigserial — 기본 키 — NOT NULL
  • Field (project_idx) — bigint
  • Field (hinfo) — varchar
  • Field (create_id) — varchar
  • Field (update_id) — varchar
  • Field (create_date) — timestamp
  • Field (updated_at) — timestamp
  • Field (active_flag) — boolean
  • Field (delete_flag) — boolean

패킹리스트 파일 (sap_logistics_object_check_file)

  • Key (slocf_idx) — bigserial — 기본 키 — NOT NULL
  • Field (project_idx) — bigint
  • Field (sdi_idx) — bigint
  • Field (order_number) — varchar
  • Field (slocl_filename) — varchar
  • Field (slocl_filepath) — varchar
  • Field (sloch_idx) — bigint
  • Field (fkey) — varchar
  • Field (identifier) — varchar
  • Field (status) — smallint — 1: 작업전 2:작업중 3:작업완료
  • Field (slocl_aws_filename) — varchar
  • Field (create_id) — varchar
  • Field (update_id) — varchar
  • Field (create_date) — timestamp
  • Field (update_date) — timestamp
  • Field (active_flag) — boolean
  • Field (delete_flag) — boolean

패킹리스트 헤더 (sap_logistics_object_check_header)

  • Key (sloch_idx) — bigserial — 기본 키 — NOT NULL
  • Field (project_idx) — bigint
  • Field (json_str) — jsonb
  • Field (create_id) — varchar
  • Field (update_id) — varchar
  • Field (create_date) — timestamp
  • Field (update_date) — timestamp
  • Field (activee_flag) — boolean
  • Field (delete_flag) — boolean

프로젝트 서비스 운영 상태 (lms_project_service)

  • Key (lpi_idx) — bigint — 기본 키 — NOT NULL
  • Field (status) — smallint — 1-서비스on 2-서비스off