FIMS

Tables (5)

API (Untitled2)

  • API (Key) — VARCHAR(100) — Primary key — NOT NULL
  • Field

CODE (Untitled)

  • LOW_CD — VARCHAR(100) — Primary key — NOT NULL
  • UPPR_CD — VARCHAR(100)
  • CD_DESC — VARCHAR(100)
  • CD_NM — VARCHAR(100)

FACILITY (Untitled3)

  • FCODE (PJCODE) — VARCHAR(100) — Primary key — NOT NULL

GROUP (Untitled4)

  • FCODE (PJCODE) — VARCHAR(100) — Foreign key → FACILITY.FCODE — NOT NULL
  • LOW_CD — VARCHAR(100) — Foreign key → CODE.LOW_CD — NOT NULL

GROUP_CONFIG (Untitled5)

  • FCODE (PJCODE) — VARCHAR(100) — Foreign key → GROUP.FCODE — NOT NULL
  • LOW_CD — VARCHAR(100) — Foreign key → GROUP.LOW_CD — NOT NULL
  • LOW_CD (Field) — VARCHAR(100)
  • VAL (Field2) — VARCHAR(100)