repectoring
Tables (17)
Untitled (LOGIC_DETAIL)
- Key (LOGIC_ID) — INT — Primary key — NOT NULL
- Key (INSP_ID) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (PARENT_ID) — INT
- Field (OPERATOR) — VARCHAR(50)
- Field (IS_REVERSE) — BOOL
- Field (IS_FINAL) — INT
- Field (NOTE) — VARCHAR(100)
- Field (CREATE_DT) — DATE
- Field (UPDATE_DT) — DATE
Untitled (RESULT_TOOL_DETAIL)
- Key (R_T_DETAIL) — INT — Primary key — NOT NULL
- Key (TOOL_ID) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (R_I_DETAIL_ID) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (TOOL_NAME) — VARCHAR(100)
- Field (RESULT) — DATE
- Field (VALUE) — DATE
- Field (CREATE_DT) — DATE
Untitled (RESULT_INSP_DETAIL)
- Key (R_I_DETAIL_ID) — INT — Primary key — NOT NULL
- Key (RESULT_ID) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (INSP_ID) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (RESULT) — BOOL
- Field (CREATE_DT) — DATE
Untitled (RESULT_MASTER)
- Key (RESULT_ID) — INT — Primary key — NOT NULL
- Key (SPEC_ID) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (PROD_NAME) — VARCHAR(100)
- Field (SERIAL) — DATE
- Field (RESULT) — BOOL
- Field (CREATE_DT) — DATE
Untitled (USER_ROLE_MAP)
- Key (USER_ID) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (ROLE_ID) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (IS_ALLOW) — BOOL
- Field (CREATE_DT) — DATE
- Field (UPDATE_DT) — DATE
Untitled (ROLE_MASTER)
- Key (ROLE_ID) — INT — Primary key — NOT NULL
- Field (NAME) — VARCHAR(100)
- Field (NOTE) — VARCHAR(100)
- Field (CREATE_DT) — DATE
- Field (UPDATE_DT) — DATE
Untitled (USER_MASTER)
- Key (USER_ID) — INT — Primary key — NOT NULL
- Field (NAME) — VARCHAR(100)
- Field (PASSWORD) — VARCHAR(100)
- Field (NOTE) — VARCHAR(100)
- Field (CREATE_DT) — DATE
- Field (UPDATE_DT) — DATE
Untitled (LOGIC_TOOL_MAP)
- Key (L_T_MAP_ID) — INT — Primary key — NOT NULL
- Key (LOGIC_ID) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (TOOL_ID) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (IS_REVERSE) — INT
- Field (CREATE_DT) — DATE
- Field (UPDATE_DT) — DATE
Untitled (TOOL_MASTER)
- Key (TOOL_ID) — INT — Primary key — NOT NULL
- Field (NAME) — VARCHAR(100)
- Field (CAM) — DATE
- Field (NOTE) — VARCHAR(100)
- Field (CREATE_DT) — DATE
- Field (UPDATE_DT) — DATE
Untitled (PROD_MASTER)
- Key (PROD_ID) — INT — Primary key — NOT NULL
- Field (NAME) — VARCHAR(100)
- Field2 (NOTE) — VARCHAR(100)
- Field3 (CREATE_DT) — DATE
- Field4 (UPDATE_DT) — DATE
Untitled (INSP_MASTER)
- Key (INSP_ID) — INT — Primary key — NOT NULL
- Key (SPEC_ID) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (NAME) — VARCHAR(100)
- Field (CAM) — INT
- Field (IS_USE_INSP) — BOOL
- Field (IS_USE_CAMERA) — BOOL
- Field (NOTE) — VARCHAR(100)
- Field (CREATE_DT) — DATE
- Field (UPDATE_DT) — DATE
Untitled (PROD_DETAIL_LIGHT_MAP)
- Key (P_DETAIL_ID) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (LIGHT_ID) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (VALUE) — INT
- Field (CREATE_DT) — DATE
- Field (UPDATE_DT) — DATE
Untitled (LIGHT_MASTER)
- Key (LIGHT_ID) — INT — Primary key — NOT NULL
- Field (NAME) — VARCHAR(100)
- Field (SERIAL) — VARCHAR(100)
- Field (NOTE) — VARCHAR(100)
- Field (CREATE_DT) — DATE
- Field (UPDATE_DT) — DATE
Untitled (SPEC_OPT_MAP)
- Key (SPEC_ID) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (OPT_ID) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (IS_ACTIVE) — BOOL
- Field (CREATE_DT) — DATE
- Field (UPDATE_DT) — DATE
Untitled (OPT_MASTER)
- Key (OPT_ID) — INT — Primary key — NOT NULL
- Field (NAME) — VARCHAR(100)
- Field (NOTE) — VARCHAR(100)
- Field (CREATE_DT) — DATE
- Field (UPDATE_DT) — DATE
Untitled (SPEC_MASTER)
- Key (SPEC_ID) — INT — Primary key — NOT NULL
- Key (P_DETAIL_ID) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (NAME) — VARCHAR(100)
- Field (NOTE) — VARCHAR(100)
- Field (CREATE_DT) — DATE
- Field (UPDATE_DT) — DATE
Untitled (PROD_DETAIL)
- Key (P_DETAIL_ID) — INT — Primary key — NOT NULL
- Key (PROD_ID) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (NAME) — VARCHAR(100)
- Field (NOTE) — VARCHAR(100)
- Field (CREATE_DT) — DATE
- Field (UPDATE_DT) — DATE