test
Tables (33)
acs_connectors
- id — bigint — Primary key
- code — varchar(50) — NOT NULL
- name — varchar(50) — NOT NULL
- vendor — varchar(50) — NOT NULL
- mqtt_host — varchar(255)
- mqtt_port — integer
- socket_host — varchar(255)
- socket_port — integer
- http_host — varchar(255)
- http_port — integer
- active — boolean — NOT NULL
- description — varchar(255)
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
acs_messages
- id — bigint — Primary key
- acs_id — bigint — Foreign key → acs_connectors.id — NOT NULL
- name — varchar(100) — NOT NULL
- topic — varchar(255) — NOT NULL
- subject — varchar(100)
- type — varchar(30) — NOT NULL — publish|subscribe|request|response
- schema — jsonb — payload 스키마
- active — boolean — NOT NULL
- in_use — boolean — NOT NULL — 사용 여부(사용 버전)
- description — varchar(255)
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
- id (id2) — bigint — Foreign key → acs_connectors.id
alarm_emails
- id — bigint — Primary key
- user_id — bigint — Foreign key → users.id — 연결 수신자 id
- email — varchar(255) — NOT NULL
- name — varchar(50) — NOT NULL
- active — boolean — NOT NULL
- description — varchar(255)
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
amrs
- id — bigint — Primary key
- acs_id — bigint — Foreign key → acs_connectors.id
- robot_attribute_id — bigint — Foreign key → robot_attribute_defs.id
- code — varchar(50) — NOT NULL
- name — varchar(50) — NOT NULL
- serial — varchar(255)
- robot_type — varchar(50)
- vendor — varchar(50)
- state — varchar(20)
- mode — varchar(15) — NOT NULL — auto|manual|autoPending|manualPending
- active — boolean — NOT NULL
- description — varchar(255)
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
common_codes
- id — bigint — Primary key
- code — varchar(50) — NOT NULL
- name — varchar(50) — NOT NULL
- master_code — varchar(50) — NOT NULL
- level — integer — NOT NULL
- type — varchar(20) — NOT NULL
- orderby — integer — NOT NULL
- description — text
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
daily_statistics
- id — bigint — Primary key
- type — varchar(50)
- data — jsonb
- year — integer
- month — integer
- day — integer — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
dryrun_histories
- id — bigint — Primary key
- scenario_id — bigint — Foreign key → scenarios.id
- sequence_profile_id — bigint — Foreign key → sequence_profiles.id
- user_id — bigint — Foreign key → users.id
- mode — varchar(20) — normal|facility
- parameters — jsonb
- result — jsonb
- status — varchar(20) — NOT NULL — pending|running|completed|failed|canceled
- started_at — timestamptz
- ended_at — timestamptz
- description — varchar(255)
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
- id (id2) — bigint — Foreign key → users.id
- id (id3) — bigint — Foreign key → sequence_profiles.id
- id (id4) — bigint — Foreign key → scenarios.id
error_codes
- id — bigint — Primary key
- code — varchar(50) — NOT NULL
- error_from — varchar(20) — NOT NULL — WMS|FAC|MCS|ACS|ETC
- message_ko — text
- message_en — text
- message_es — text
- error_level — varchar(20) — NOT NULL — info|warning|error
- notify — boolean — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
event_histories
- id — bigint — Primary key
- user_id — bigint — Foreign key → users.id
- action — varchar(30) — NOT NULL — Create|BulkCreate|SelectList|SelectInfo|Update|Delete|Write
- table_name — varchar(100) — NOT NULL
- table_pks — integer
- request_log — jsonb
- response_log — jsonb
- client_ip — varchar(255)
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
facilities
- id — bigint — Primary key
- facility_group_id — bigint — Foreign key → facility_groups.id — NOT NULL
- plc_connector_id — bigint — Foreign key → plc_connectors.id — 통신 설정 id
- code — varchar(50) — NOT NULL
- name — varchar(50) — NOT NULL
- serial — varchar(255)
- type — varchar(4) — in|out
- system — varchar(3) — WMS|EQP
- state — varchar(20)
- ip — varchar(15)
- port — integer
- floor — varchar(10)
- active — boolean — NOT NULL
- is_trigger — boolean — NOT NULL — 트리거 여부
- is_check_call_type — boolean — NOT NULL
- always_fill — boolean — NOT NULL
- is_mission_order_capable — boolean — NOT NULL
- cancel_type — varchar(30) — NOT NULL
- mode — varchar(20) — NOT NULL — auto|manual
- priority — integer — NOT NULL
- is_active_call_trigger — boolean — NOT NULL
- is_wms_port — boolean — NOT NULL
- generated_call_count — integer
- linked_eqp_ids — integer — NOT NULL
- cancel_linked_eqp_ids — integer — NOT NULL
- linked_wms_ids — integer — NOT NULL
- custom_attributes — jsonb — 커스텀 속성
- description — varchar(255)
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
- id (id2) — bigint — Foreign key → facility_groups.id
- id (id3) — bigint — Foreign key → plc_connectors.id
facility_attribute_defs
- id — bigint — Primary key
- attr_key — varchar(50) — NOT NULL — facilities.custom_attributes 의 key
- attr_name — varchar(100) — NOT NULL
- data_type — varchar(20) — NOT NULL — string|number|boolean|enum|json
- options — jsonb — select 박스 같은 경우 값 목록
- default_value — text
- required — boolean — NOT NULL
- description — varchar(255)
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
facility_groups
- id — bigint — Primary key
- code — varchar(50) — NOT NULL
- name — varchar(50) — NOT NULL
- description — varchar(255)
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
facility_tags
- id — bigint — Primary key
- facility_id — bigint — Foreign key → facilities.id — NOT NULL
- tag_name — varchar(100) — NOT NULL
- identifier — jsonb — NOT NULL — Kepware 노드ID 등
- data_type — varchar(20) — NOT NULL
- input_type — varchar(20)
- initial_value — varchar(255)
- is_subscribed — boolean — NOT NULL
- description — varchar(255)
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
files
- id — bigint — Primary key
- title — varchar(255) — NOT NULL
- path — text — NOT NULL
- type — varchar(20)
- size — bigint
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
item_logs
- created_at — timestamptz — Primary key — NOT NULL
- id — bigint
- item_code — varchar(500)
- facility_code — varchar(50)
- facility_name — varchar(50)
- amr_code — varchar(50)
- amr_name — varchar(50)
- floor — varchar(10)
- topic — varchar(50)
- subject — varchar(50)
- body — jsonb
- tracking_log_id — bigint
- call_id — varchar(50)
- value — varchar(50)
- state — varchar(50)
- location — varchar(50)
- message — text
- result_status — varchar(20)
- created_date_time — varchar(50)
items
- id — bigint — Primary key
- code — varchar(255) — NOT NULL
- name — varchar(100) — 품목명 - 이미지 신규
- type — varchar(50)
- description — varchar(255)
- active — boolean — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
logs
- created_at — timestamptz — Primary key — NOT NULL
- id — bigint
- item_code — varchar(500)
- facility_code — varchar(50)
- facility_name — varchar(50)
- amr_code — varchar(50)
- amr_name — varchar(50)
- log_level — varchar(7) — debug|info|warning|error
- function — varchar(20)
- key — varchar(50)
- data — jsonb
mcs_alarms
- id — bigint — Primary key
- confirmed_user_id — bigint — Foreign key → users.id — 알람 확인자
- code — varchar(50) — NOT NULL
- error_from — varchar(20) — NOT NULL — WMS|FAC|MCS|ACS|ETC
- error_code — varchar(50)
- level — varchar(20) — NOT NULL — info|warning|error
- target — varchar(50) — 설비|로봇|시퀀스
- state — varchar(10) — NOT NULL — registered|confirmed|completed
- data — jsonb
- confirmed_at — timestamptz
- completed_at — timestamptz
- action_note — varchar(500) — 조치 내용
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
menu_permissions
- id — bigint — Primary key
- auth — varchar(20) — NOT NULL — viewer|staff|admin|system
- menu_path — varchar(255) — NOT NULL
- menu_name — varchar(100) — NOT NULL
- can_access — boolean — NOT NULL — 메뉴 진입 권한
- can_create — boolean — NOT NULL
- can_update — boolean — NOT NULL
- can_delete — boolean — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
monthly_statistics
- id — bigint — Primary key
- type — varchar(50)
- data — jsonb
- year — integer
- month — integer — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
plc_connectors
- id — bigint — Primary key
- name — varchar(50) — NOT NULL
- type — varchar(20) — NOT NULL — kepware|smartConnector|opcua|mqtt
- host — varchar(255) — NOT NULL
- port — integer — NOT NULL
- credential — jsonb — 인증정보
- refresh_cycle — integer — 갱신 주기(ms)
- active — boolean — NOT NULL
- description — varchar(255)
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
plc_data_change_history_logs
- ts — timestamptz — Primary key — NOT NULL — 이벤트 발생 시각
- id — bigint
- facility_code — varchar(50) — NOT NULL
- facility_type — varchar(50) — NOT NULL
- is_triggered — boolean — NOT NULL
- old_value — varchar(255)
- new_value — varchar(255)
- value_type — varchar(255)
- snapshot_data — jsonb
- user_id — bigint — 수동 쓰기 시
- created_at — timestamptz — NOT NULL
- facility_name — varchar(50) — NOT NULL
- tag_name — varchar(50) — NOT NULL
robot_attribute_defs
- id — bigint — Primary key
- source_key — varchar(100) — NOT NULL — ACS에서 들어오는 키 (예: VDA5050)
- target_code — varchar(50) — NOT NULL — mcs 내부 코드
- attr_name — varchar(100) — NOT NULL
- data_type — varchar(20) — NOT NULL
- input_type — varchar(20)
- description — varchar(255)
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
scenarios
- id — bigint — Primary key
- name — varchar(100) — NOT NULL
- type — varchar(20) — NOT NULL — normal|abnormal
- steps — jsonb — NOT NULL — nodes/edges/parameters
- version — integer — NOT NULL
- active — boolean — NOT NULL
- in_use — boolean — NOT NULL — 사용 여부(사용 버전)
- description — varchar(255)
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
sequence_profile_scenarios
- id — bigint — Primary key
- sequence_profile_id — bigint — Foreign key → sequence_profiles.id — NOT NULL
- scenario_id — bigint — Foreign key → scenarios.id — NOT NULL
- sort_order — integer — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
sequence_profiles
- id — bigint — Primary key
- name — varchar(100) — NOT NULL
- vendor — varchar(50)
- active — boolean — NOT NULL
- description — varchar(255)
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
settings
- id — bigint
- system — varchar(10) — NOT NULL
- type — varchar(30) — NOT NULL
- data — jsonb
- description — varchar(255)
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
system_logs
- created_at — timestamptz — Primary key — NOT NULL
- id — bigint
- facility_code — varchar(50)
- facility_name — varchar(50)
- send — varchar(10) — mcs|wcs|eqp|acs
- recv — varchar(10)
- type — varchar(7) — debug|warning|info
- request — jsonb
- response — jsonb
token_histories
- id — bigint — Primary key
- user_id — bigint — Foreign key → users.id
- action — varchar(30) — NOT NULL — Created|CreatedPin|Destroyed
- access_token — varchar(500)
- access_expire — timestamptz
- client_ip — varchar(255)
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
tracking_logs
- id — bigint — Primary key
- work_order_code — varchar(50) — Foreign key → work_orders.code — 작지 코드
- code — varchar(50) — 로그 코드(UUID)
- plc_name — varchar(20) — 출처 시스템(설비)
- port_name — varchar(20)
- call_id — varchar(50)
- call_type — varchar(20)
- eqp_call_id — varchar(10)
- transfer_id — varchar(50)
- subject — varchar(50) — 토픽
- detail — varchar(50)
- state — varchar(20)
- process_state — varchar(20) — NOT NULL
- start_facility — varchar(20) — 관련 설비 코드(출발)
- dest_facility — varchar(20) — 관련 설비 코드(도착)
- assigned_robot — varchar(50) — 관련 로봇 코드
- mission_destination — varchar(50)
- prev_value — varchar(255) — 이전 값
- new_value — varchar(255) — 이후 값
- message — varchar(255)
- description — varchar(255)
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
- id (id2) — bigint — Foreign key → work_orders.id
- id (id5) — bigint — Foreign key
users
- id — bigint — Primary key
- userid — varchar(50) — NOT NULL — 아이디(로그인)
- password — varchar(255) — NOT NULL
- pin — varchar(255) — 핀(해시) - 신규
- name — varchar(50) — NOT NULL
- email — varchar(255)
- mobile — varchar(20)
- auth — varchar(8) — NOT NULL — viewer|staff|admin|system
- language — varchar(10) — ko|en|es
- active — boolean — NOT NULL
- login_fail_count — integer — NOT NULL
- last_login — timestamptz
- last_logout — timestamptz
- updated_password — timestamptz
- other_date — timestamptz
- personal_setting — jsonb — 사용자 개인 세팅 - 신규
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
work_orders
- id — bigint — Primary key
- item_id — bigint — Foreign key → items.id
- from_facility_id — bigint — Foreign key → facilities.id — 출발 설비
- to_facility_id — bigint — Foreign key → facilities.id — 도착 설비
- from_amr_id — bigint — Foreign key → amrs.id — 할당 로봇
- cancel_user_id — bigint — Foreign key → users.id — 취소 사용자
- code — varchar(50) — NOT NULL — 작지 코드
- external_system_id — varchar(100) — 외부 시스템 ID (WMS/MES Call ID)
- eqp_call_id — varchar(50) — 설비 콜 ID
- type — varchar(10) — IN|OUT|MISSION
- state — varchar(30) — NOT NULL
- process_state — varchar(30) — 진행 상태
- is_closed — boolean — NOT NULL
- is_mission_order — boolean — NOT NULL
- call_priority — boolean — NOT NULL — 우선 순위
- cargo_type — varchar(20)
- cmd_id — varchar(40)
- level — integer
- always_call_count — integer
- trigger_call_count — integer
- waypoints — integer — NOT NULL — 경유지
- cancel_reason — varchar(255)
- cancel_date — timestamptz
- from_start_date — timestamptz
- from_end_date — timestamptz
- mission_start_date — timestamptz
- mission_end_date — timestamptz
- to_start_date — timestamptz
- to_end_date — timestamptz
- description — varchar(255)
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
zones
- id — bigint — Primary key
- name — varchar(50) — NOT NULL
- description — varchar(255)
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz