mes

Tables (5)

SFU3_tag_data_with_material

  • timestamp — TIMESTAMPTZ — Primary key — NOT NULL
  • device_id — VARCHAR(50) — Foreign key → device.device_id — NOT NULL — 장비ID
  • collection_active — BOOLEAN — 수집활성여부
  • plc_published_ts — TIMESTAMPTZ — PLC발행시각
  • broker_ts — TIMESTAMPTZ — 브로커수신시각
  • rule_processed_ts — TIMESTAMPTZ — 룰처리시각
  • db_written_ts — TIMESTAMPTZ — DB기록시각
  • sfu3_power_status — BOOLEAN — 전원상태
  • sfu3_auto_mode — BOOLEAN — 자동모드
  • sfu3_man_mode — BOOLEAN — 수동모드
  • sfu3_system_fault — BOOLEAN — 시스템결함
  • sfu3_infeed_conv_speed — NUMERIC(10,2) — 인피드컨베이어속도

device

  • device_id — VARCHAR(50) — Primary key — NOT NULL
  • process_id — VARCHAR(20) — Foreign key → process.process_id — NOT NULL — 공정ID
  • device_name — VARCHAR(100) — NOT NULL — 장비명
  • device_type — VARCHAR(50) — 장비유형
  • vendor — VARCHAR(100) — 제조사
  • model_no — VARCHAR(100) — 모델번호
  • serial_no — VARCHAR(100) — 시리얼번호
  • ip_address — VARCHAR(50) — IP주소
  • status — VARCHAR(20) — 상태
  • installed_date — DATE — 설치일자
  • created_at — TIMESTAMPTZ — NOT NULL — 생성일시
  • updated_at — TIMESTAMPTZ — NOT NULL — 수정일시

process

  • process_id — VARCHAR(20) — Primary key — NOT NULL
  • shop_id — VARCHAR(20) — Foreign key → shop.shop_id — NOT NULL — 샵ID
  • process_name — VARCHAR(100) — NOT NULL — 공정명
  • process_seq — INT — 공정순서
  • created_at — TIMESTAMPTZ — NOT NULL — 생성일시
  • updated_at — TIMESTAMPTZ — NOT NULL — 수정일시

region

  • region_id — VARCHAR(20) — Primary key — NOT NULL
  • region_name — VARCHAR(100) — NOT NULL — 지역명
  • created_at — TIMESTAMPTZ — NOT NULL — 생성일시
  • updated_at — TIMESTAMPTZ — NOT NULL — 수정일시

shop

  • shop_id — VARCHAR(20) — Primary key — NOT NULL
  • region_id — VARCHAR(20) — Foreign key → region.region_id — NOT NULL — 지역ID
  • shop_name — VARCHAR(100) — NOT NULL — 샵명
  • shop_type — VARCHAR(50) — 샵유형
  • address — TEXT — 주소
  • manager_name — VARCHAR(100) — 관리자명
  • manager_contact — VARCHAR(50) — 관리자연락처
  • created_at — TIMESTAMPTZ — NOT NULL — 생성일시
  • updated_at — TIMESTAMPTZ — NOT NULL — 수정일시