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