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