REGION

Tables (6)

MENU (Untitled6)

  • MENU_ID (Key) — Primary key — NOT NULL
  • HGRN_MENU_ID (Field)
  • MENU_NM (Field2)
  • SCRN_ID (Field3)
  • SCRN_ID (Key2) — Foreign key → SCREEN.SCRN_ID — NOT NULL
  • MENU_ID (Key3) — Foreign key → MENU.MENU_ID — NOT NULL

ROLE (Untitled3)

  • ROLE_ID (Key) — Primary key — NOT NULL
  • ROLE_NM (Field)
  • SCRN_ROLE_GRP_CD (Field2)

ROLE-SCREEN (Untitled5)

  • ROLE_ID (Key3) — Foreign key → ROLE.ROLE_ID — NOT NULL
  • SCRN_ID (Key4) — Foreign key → SCREEN.SCRN_ID — NOT NULL
  • SCRN_ROLE_ATHT_DVVL (Field)

SCREEN (Untitled4)

  • SCRN_ID (Key) — Primary key — NOT NULL
  • SCRN_NM (Field)
  • URL_NM (Field2)

USER (Untitled)

  • USER_ID (Key) — Primary key — NOT NULL
  • USER_NAME (Field)
  • SYST_AREA_CLASS_CD (Field2)
  • PWD_INTZ_YN (Field3)
  • PWD (Field4)
  • PWD_EXPT_DT (Field5)
  • LGN_ERR_NCNT (Field6)

USER-ROLE (Untitled2)

  • USER_ID (Key3) — Foreign key → USER.USER_ID — NOT NULL
  • ROLE_ID (Key4) — Foreign key → ROLE.ROLE_ID — NOT NULL