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