EHT

Tables (8)

CH

  • UID — VARCHAR(12) — Primary key — NOT NULL
  • CH_ROLE (Key) — VARCHAR(12) — Foreign key → CH_ROLE.UID — NOT NULL
  • CH_CLASS (Key2) — VARCHAR(12) — Foreign key → CH_CLASS.UID — NOT NULL
  • CH_NAME — VARCHAR(30)

CH_CLASS (Untitled2)

  • UID (Key) — VARCHAR(12) — Primary key — NOT NULL
  • CLASS_NAME (Field) — VARCHAR(100)

CH_ROLE (Untitled)

  • UID (ROLE_UID) — VARCHAR(12) — Primary key — NOT NULL
  • ROLE_NAME — VARCHAR(100)

CH_STATUS (Untitled3)

  • UID (Key) — VARHCAR(12) — Primary key — NOT NULL
  • CH (UID) — VARCHAR(12) — Foreign key → CH.UID — NOT NULL
  • STATUS_TYPE (Key2) — VARCHAR(12) — Foreign key → STATUS_TYPE.UID — NOT NULL
  • STATUS_LEVEL (Key3) — VARCHAR(12) — Foreign key → STATUS_LEVEL.UID — NOT NULL

EQUIP (Untitled7)

  • UID (Key) — VARCHAR(12) — Primary key — NOT NULL
  • Field

STATUS_LEVEL (Untitled5)

  • UID (Key) — VARCHAR(12) — Primary key — NOT NULL
  • LEVEL_NAME (Field) — VARCHAR(100)

STATUS_TYPE (Untitled4)

  • UID (Key) — VARCHAR(12) — Primary key — NOT NULL
  • TYPE_NAME (Field) — VARCHAR(100)

STATUS_TYPE_LEVEL (Untitled6)

  • UID (Key) — VARCHAR(12) — Primary key — NOT NULL
  • STATUS_TYPE (Key2) — VARCHAR(12) — Foreign key → STATUS_TYPE.UID — NOT NULL
  • STATUS_LEVEL (Key3) — VARCHAR(12) — Foreign key → STATUS_LEVEL.UID — NOT NULL
  • STATUS_VALUE (Field3) — NUMERIC