sirjin

Tables (17)

alarm_case (사용자 커스텀 알람 케이스)

  • Key (uuid) — uuid — Primary key — NOT NULL
  • Field (content) — varchar
  • Field (remarks) — varchar
  • Field (time) — timestamp

alarm_history (알람 히스토리(io,focas 통합) key 는 no)

  • Key (no) — int — Primary key — NOT NULL
  • Key2 (alarm_start_time) — timestamp — Primary key — NOT NULL
  • Key3 (alarm_end_time) — timestamp — Primary key — NOT NULL
  • Key (nc_id) — uuid — Foreign key → machine_list.Key — NOT NULL
  • Field (원인) — string
  • Field (case_no) — int
  • Field (content) — string
  • Field — varchar
  • Field2
  • Field3

alarm_history (알람 히스토리)

  • Key (no) — int — Primary key — NOT NULL
  • Key (nc_id) — uuid — Foreign key → machine_list.Key — NOT NULL
  • Field (machine_type) — varchar
  • Field (alarm_msg) — varchar
  • Field (alarm_code) — varchar
  • Field (alarm_start_time) — varchar
  • Field (alarm_end_time) — varchar
  • Field (cause) — varchar
  • Field (action) — varchar

correction_history (NC 교정 날짜)

  • Key (datetime) — date — Primary key — NOT NULL
  • Key (nc_id) — uuid — Foreign key → machine_list.Key — NOT NULL

daily_total_history (일별 종합 데이터)

  • Key (date) — date — Primary key — NOT NULL
  • Key (nc_id) — uuid — Foreign key → machine_list.Key — NOT NULL
  • Field (in_cycle_time) — int
  • Field (wait_time) — int
  • Field (alarm_time) — int
  • Field (no_connection_time) — int
  • Field (part_count) — int
  • Field (target_count) — int
  • Field (cycle_tiome) — int
  • Field (op_rate) — float

fault_case (사용자 커스텀 불량 케이스)

  • Key (uuid) — uuid — Primary key — NOT NULL
  • Field (content) — varchar
  • Field (remarks) — varchar
  • Field (time) — timestamp

fault_history (불량 등록 정보)

  • Key (no) — int — Primary key — NOT NULL
  • Field (nc_id) — int
  • Field (fault_info) — string
  • Field (......) — string
  • Field
  • Filed (case_no) — int

group_info (설비 그룹 정보)

  • Key (group_no) — int — Primary key — NOT NULL
  • Field (group_name) — varchar

machine_info (NC 상태 (보류))

  • Key (nc_id) — int — Primary key — NOT NULL
  • Field (raw_data) — json
  • Field2 (incycle_time) — int
  • Field3 (wait_time) — int
  • Field4 (alarm_time) — int
  • Field5 (no_connection_time) — int
  • Field6 (status) — string
  • Field9 (part_number) — string
  • Field10 (cycle_time) — int
  • Field (op_rate) — float

machine_list (설비 리스트(스펙 정보 포함))

  • Key (nc_id) — uuid — Primary key — NOT NULL
  • Field (name) — varchar
  • Field (group_no) — int
  • Field (model_name) — varchar
  • Field (nc_model) — varchar
  • Field (nc_serial_no) — varchar
  • Field (nctype) — varchar
  • Field (manufacturer) — varchar
  • Field (manufacture_date) — varchar
  • Field (pic) — varchar
  • Field (latest_check_date) — varchar
  • Field (remarks) — string

part_count_history (생산 history)

  • Key (datetime) — date — Primary key — NOT NULL
  • Key (nc_id) — uuid — Foreign key → machine_list.Key — NOT NULL
  • Field (part_count) — int
  • Field (total_count) — int

part_number_history (품번 사용내역 히스토리)

  • Key (part_number) — string — Primary key — NOT NULL
  • Key (input_time) — varchar — Primary key — NOT NULL
  • Key (nc_id) — uuid — Foreign key → machine_list.Key — NOT NULL
  • Field (start_time) — varchar
  • Field (end_time) — varchar
  • Field (cycle_time) — int

repair_history (NC 고장 수리 내역)

  • Key (datetime) — date — Primary key — NOT NULL
  • Key (nc_id) — uuid — Foreign key → machine_list.Key — NOT NULL
  • Field (breakdown) — varchar
  • Field (repair) — varchar
  • Field (result) — varchar
  • Field (remarks) — varchar

routing_info (공정 순서 세팅)

  • Key (part_number) — string — Primary key — NOT NULL
  • Key (order) — int — Primary key — NOT NULL
  • Field (nc_id) — uuid

target_plan (목표량 계획 등록)

  • Key (date) — date — Primary key — NOT NULL
  • Key (nc_id) — uuid — Foreign key → machine_list.Key — NOT NULL
  • Field (target) — int

time_chart_data (24시간 가동상태)

  • Key (datetime) — date — Primary key — NOT NULL
  • Key (nc_id) — uuid — Foreign key → machine_list.Key — NOT NULL
  • column (status) — varchar
  • column (nc_raw_data) — json

user_info (사용자 관리 (보류))

  • Key (id) — varchar — Primary key — NOT NULL
  • Fiel (pw) — varchar
  • Field (no) — varchar
  • Field (name) — varchar
  • Field (group) — varchar
  • Field (email) — varchar
  • Field (auth) — varchar