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