LGL
Tables (4)
IS_SYSTEM
- SYS_CODE — NOT NULL — Primary key — NOT NULL
- ID — NOT NULL — Foreign key → IS_TEAM_MEMBER.ID — NOT NULL
- SYS_NAME — NOT NULL
- SYS_MANAGER — NOT NULL
- SYS_DESCRIPTION — NULL
IS_SYSTEM_SERVER
- SERVER_CODE — NOT NULL — Primary key — NOT NULL
- IP — NOT NULL
- HOST — NOT NULL
- SERVER_SYS (Field) — NOT NULL
IS_TEAM_MEMBER
- ID — NOT NULL — Primary key — NOT NULL
- MEMBERNAME (NAME) — NOT NULL
- PHONE_NUMBER — NULL
- DEPARTMENT — NOT NULL
- RANK — NOT NULL
- EMAIL — NOT NULL
SYSTEM_MAPPING (Untitled)
- SYS_CODE — NOT NULL — Foreign key → IS_SYSTEM.SYS_CODE — NOT NULL
- SERVER_CODE — NOT NULL — Foreign key → IS_SYSTEM_SERVER.SERVER_CODE — NOT NULL