bi-system
Tables (14)
Authority (Untitled7)
- name (Key) — Primary key — NOT NULL
Bookmark (Untitled9)
- user_id (Key) — Foreign key → User.id — NOT NULL
- menu_id (Field)
Gate (Untitled)
- id (Key) — Primary key — NOT NULL
- title (Field)
- description (Field2)
- type (Field3)
Group (Untitled3)
- id (Key) — Primary key — NOT NULL
- title (Field)
- description (Field2)
GroupMenu (Untitled4)
- id (Key) — Primary key — NOT NULL
- menu_id (Key2) — Foreign key → Menu.id — NOT NULL
- group_id (Key3) — Foreign key → Group.id — NOT NULL
GroupPermission (Untitled12)
- Key — Primary key — NOT NULL
- group_id (Key2) — Foreign key → Group.id — NOT NULL
- permission_id (Key3) — Foreign key → Permission.id — NOT NULL
GroupUser (Untitled6)
- id (Key) — Primary key — NOT NULL
- group_id (Key2) — Foreign key → Group.id — NOT NULL
- user_id (Key3) — Foreign key → User.id — NOT NULL
Menu (Untitled2)
- id (Key) — Primary key — NOT NULL
- title (Field)
- description (Field2)
- uri (Field3)
- is tableau menu (Field4)
- activated (Field6)
- icon (Field7)
- parent_no (Field5)
- order_no (Field8)
- section_id (Key2) — Foreign key → Gate.id — NOT NULL
Params (Untitled8)
- menu_id (Key) — Foreign key → Menu.id — NOT NULL
- param (Field)
- value (Field2)
Permission (Untitled11)
- id (Key) — Primary key — NOT NULL
- title (Field)
- description (Field2)
PermissionColumn (Untitled13)
- permission_id (Key) — Foreign key → Permission.id — NOT NULL
- column (Field)
PermissionValue (Untitled14)
- permission_id (Key) — Foreign key → Permission.id — NOT NULL
- value (Field)
User (Untitled5)
- id (Key) — Primary key — NOT NULL
- login (Field)
- password (Field2)
- firstName (Field3)
- lastName (Field4)
- tableauId (Field5)
- email (Field6)
- activated (Field7)
- langKey (Field8)
- imageUrl (Field9)
- activationKey (Field10)
- resetKey (Field11)
- resetDate (Field12)
- Field13
UserAuthority (Untitled10)
- user_id (Key) — Foreign key → User.id — NOT NULL
- authority_name (Key2) — Foreign key → Authority.name — NOT NULL