flow_control_setting_tool
Tables (19)
MD_DEVICE (장비 마스터)
- DEVICE_CODE (CODE) — VARCHAR(20) — Primary key — NOT NULL
- EQ_CODE (설비 id) — VARCHAR(20) — Foreign key → MD_EQ.EQ_CODE — NOT NULL
- CFG_CODE (제어기) — VARCHAR(20) — Foreign key → MD_DEVICE_CTRL.CFG_CODE — NOT NULL
- canvas_device_seq (seq) — BIGINT — Foreign key → fcs_canvas_tool.canvas_device_seq — NOT NULL
MD_DEVICE_CTRL (제어 콘트롤러)
- CFG_CODE (CODE) — VARCHAR(20) — Primary key — NOT NULL
MD_DEVICE_LINK (설비 연결 관계 마스터)
- SEQ — VARCHAR(21) — Primary key — NOT NULL
- DEVICE_CODE (장비) — VARCHAR(20) — Foreign key → MD_DEVICE.DEVICE_CODE — NOT NULL
- T_DEVICE_CODE (목적 장비) — VARCHAR(20)
MD_EQ (설비 마스터)
- EQ_CODE (CODE) — VARCHAR(20) — Primary key — NOT NULL
MD_EXECUTION_DEVICE (운영실행설비)
- OP_CODE (CODE) — VARCHAR(10) — Foreign key → MD_OPERATION.OP_CODE — NOT NULL
- DEVICE_CODE (장비 id) — VARCHAR(20) — Foreign key → MD_DEVICE.DEVICE_CODE — NOT NULL
- EQ_CODE (설비 id) — VARCHAR(20) — Foreign key → MD_DEVICE.EQ_CODE — NOT NULL
MD_OPERATION (운영 마스터)
- OP_CODE (CODE) — VARCHAR(10) — Primary key — NOT NULL
MD_OPERATION_LINK (운영 설비 관계 마스터)
- SEQ (Key) — VARCHAR(21) — Primary key — NOT NULL
- DEVICE_LINK_SEQ (설비 연결 관계) — VARCHAR(21) — Foreign key → MD_DEVICE_LINK.SEQ — NOT NULL
- OP_CODE (CODE) — VARCHAR(10) — Foreign key → MD_OPERATION.OP_CODE — NOT NULL
REG_DEVICE (디바이스 타입)
- FUNC_TYPE (운영 타입) — VARCHAR(10) — Primary key — NOT NULL
- DEVICE_TYPE (장비 타입) — VARCHAR(10) — Primary key — NOT NULL
- DEVICE_TYPE__NAME (설명) — VARCHAR(200)
REG_PERMISSIONS (앱 라이센스)
- ORG_CODE (CODE) — VARCHAR(20) — Primary key — NOT NULL
fcs_canvas (캔버스)
- canvas_seq (seq) — BIGINT — Primary key — NOT NULL
- background_image (배경 이미지) — BYTEA
- meta_data (툴 메타 데이터) — JSON
fcs_canvas_device_link (캔버스 설비 연결 관계)
- canvas_device_link_seq (seq) — BIGINT — Primary key — NOT NULL
- canvas_seq (canvas id) — BIGINT — Foreign key → fcs_canvas.canvas_seq — NOT NULL
- SEQ — VARCHAR(21) — Foreign key → MD_DEVICE_LINK.SEQ — NOT NULL
fcs_canvas_operation_link (캔버스 운영 설비 관계)
- canvas_operation_link_seq (seq) — BIGINT — Primary key — NOT NULL
- canvas_seq (canvas id) — BIGINT — Foreign key → fcs_canvas.canvas_seq — NOT NULL
- DEVICE_LINK_SEQ (설비 연결 관계) — VARCHAR(21) — Foreign key → MD_OPERATION_LINK.DEVICE_LINK_SEQ — NOT NULL
- OP_CODE (CODE) — VARCHAR(10) — Foreign key → MD_OPERATION_LINK.OP_CODE — NOT NULL
fcs_canvas_tool (캔버스 도구)
- canvas_device_seq (seq) — BIGINT — Primary key — NOT NULL
- canvas_seq (canvas id) — BIGINT — Foreign key → fcs_canvas.canvas_seq — NOT NULL
- device_tool_seq (Key) — BIGINT — Foreign key → fcs_device_tool.device_tool_seq — NOT NULL
- meta_data (툴 메타 데이터) — JSON
fcs_device_link (장비 도구 관계)
- device_link_seq (seq) — BIGINT — Primary key — NOT NULL
- device_tool_seq (Key) — BIGINT — Foreign key → fcs_device_tool.device_tool_seq — NOT NULL
- FUNC_TYPE (운영 타입) — VARCHAR(10) — Foreign key → REG_DEVICE.FUNC_TYPE — NOT NULL
- DEVICE_TYPE (장비 타입) — VARCHAR(10) — Foreign key → REG_DEVICE.DEVICE_TYPE — NOT NULL
fcs_device_tool (도구 기초 정보)
- device_tool_seq (Key) — BIGINT — Primary key — NOT NULL
- meta_data (툴 메타 데이터) — JSON
fcs_scheme (스키마)
- scheme_seq (seq) — BIGINT — Primary key — NOT NULL
- scheme_code (DB에 사용되는 명칭) — VARCCHAR(50)
- scheme_name (명칭) — VAR_CHAR(100)
fcs_scheme_device_ctrl (스키마 제어 콘트롤러 관계)
- scheme_device_ctrl_seq (seq) — BITINT — Primary key — NOT NULL
fcs_scheme_equipment (스키마 설비 관계)
- scheme_equipment_seq (seq) — BITINT — Primary key — NOT NULL
fcs_scheme_operation (스키마 운영 관계)
- scheme_operation_seq (Key) — BIGINT — Primary key — NOT NULL