측량시스템
테이블 (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