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