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