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