BICI

Tables (10)

AUTH GROUP (Untitled2)

  • ID (Key) — Primary key — NOT NULL
  • NAME (Field)
  • JOB GRADE (Field2)
  • LAST MODIFY DATE (Field3)
  • LAST MODIFY STF NO (Field4)
  • LAST MODIFY STF NM (Field5)

AUTH GROUP <-> USER (Untitled3)

  • ID (Key) — Primary key — NOT NULL
  • AUTH GROP ID (Key2) — Foreign key → AUTH GROUP.ID — NOT NULL
  • USER ID (id) — long — Foreign key → User.ID — NOT NULL

AUTH GROUP<-> CODE DETAIL (Untitled4)

  • Key — Primary key — NOT NULL
  • CODE DETAIL ID (Key2) — Foreign key → CODE DETAIL.ID — NOT NULL
  • AUTH GROUP ID (Key3) — Foreign key → AUTH GROUP.ID — NOT NULL

AuthGroup <-> LeftMenu (CopyOfcomm_menu_group)

  • ID (id) — long — Primary key — NOT NULL
  • AUTH GROUP ID (Key) — Foreign key → AUTH GROUP.ID — NOT NULL
  • MENU ID (id2) — long — Foreign key → LeftMenu.ID — NOT NULL

CODE DETAIL (Untitled5)

  • ID (Key) — Primary key — NOT NULL
  • CODE NAME1 (Field)
  • CODE NAME2 (Field2)
  • SORT (Field3)
  • USE YN (Field4)
  • LSH_DTM (Field5)
  • LSH_STF_NO (Field6)

Group (comm_group)

  • ID (id) — long — Primary key — NOT NULL
  • TITLE (title) — String

Group <-> LeftMenu (comm_menu_group)

  • ID (id) — long — Primary key — NOT NULL
  • GROUP ID (id2) — long — Foreign key → Group.ID — NOT NULL
  • MENU ID (id3) — long — Foreign key → LeftMenu.ID — NOT NULL

Group <-> User (Untitled)

  • ID (Key) — Primary key — NOT NULL
  • GROUP ID (id2) — long — Foreign key → Group.ID — NOT NULL
  • USER ID (id) — long — Foreign key → User.ID — NOT NULL

LeftMenu (comm_left_menu)

  • ID (id) — long — Primary key — NOT NULL
  • TITLE (title) — String
  • URI (uri) — String
  • Field3 (authUri) — String
  • ICON (icon) — String
  • USER YN (orderYn) — int
  • ORDER NO (groupNo) — long
  • GROUP NO (tenantId) — String
  • Field3 (childList) — List<LeftMenu>
  • group id (groupId) — long — Foreign key → Group.ID — NOT NULL

User (comm_user)

  • ID (id) — long — Primary key — NOT NULL
  • EMAIL (email) — String
  • PASSWORD (password) — String
  • NAME (name) — String
  • STATE (state) — Boolean
  • DEPARTMENT (dept)
  • USER GRADE (userGrade) — UserGrade
  • LAST LOGIN DATE (lastLoginDate) — LocalDateTime
  • POST DATE (postDate) — LocalDateTime