permission

Tables (10)

tb_documentation

  • documentation_id — INT — Primary key — NOT NULL
  • navigation_id — INT — Foreign key → tb_navigation.navigation_id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — MEDIUMTEXT
  • create_user_id — INT — NOT NULL
  • create_date — TIMESTAMP — NOT NULL
  • update_user_id — INT
  • update_date — TIMESTAMP

tb_grant (tb_grants)

  • grant_id (Key) — INT — Primary key — NOT NULL
  • group_id — INT — Foreign key → tb_group.group_id — NOT NULL
  • user_id — INT — Foreign key → tb_user.user_id — NOT NULL
  • navigation_id — INT — Foreign key → tb_navigation.navigation_id — NOT NULL
  • is_inherited (Field) — BOOLEAN
  • create_user_id — INT — NOT NULL
  • create_date — TIMESTAMP — NOT NULL
  • update_user_id — INT
  • update_date — TIMESTAMP

tb_grant_permission (tb_grant_paths)

  • grant_path_id — INT — Primary key — NOT NULL
  • grant_id — INT — Foreign key → tb_grant.navigation_id — NOT NULL
  • permission — VARCHAR(100) — NOT NULL
  • create_user_id — INT — NOT NULL
  • create_date — TIMESTAMP — NOT NULL

tb_group (tb_groups)

  • group_id — INT — Primary key — NOT NULL
  • project_id (project_id2) — INT — Foreign key → tb_project.project_id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(255)
  • is_all (Field) — BOOLEAN
  • create_user_id — INT — NOT NULL
  • create_date — TIMESTAMP — NOT NULL
  • update_user_id — INT
  • update_date — TIMESTAMP

tb_navigation

  • navigation_id — INT — Primary key — NOT NULL
  • project_id (project_id2) — INT — Foreign key → tb_project.project_id — NOT NULL
  • parent_id — INT — Foreign key → tb_navigation.navigation_id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • role — VARCHAR(100)
  • url — VARCHAR(255)
  • is_enabled (is_visible) — BOOLEAN
  • is_public (Field) — BOOLEAN
  • order — INT
  • create_user_id — INT — NOT NULL
  • create_date — TIMESTAMP — NOT NULL
  • update_user_id — INT
  • update_date — TIMESTAMP

tb_navigation_permission (tb_navigation_paths)

  • navigation_path_id — INT — Primary key — NOT NULL
  • navigation_id — INT — Foreign key → tb_navigation.navigation_id — NOT NULL
  • path — VARCHAR(255) — NOT NULL
  • permission — VARCHAR(100) — NOT NULL
  • create_user_id — INT — NOT NULL
  • create_date — TIMESTAMP — NOT NULL
  • update_user_id — INT
  • update_date — TIMESTAMP

tb_project (tb_projects)

  • project_id — INT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • uuid — CHAR(36) — NOT NULL
  • create_user_id — INT — NOT NULL
  • create_date — TIMESTAMP — NOT NULL
  • update_user_id — INT
  • update_date — TIMESTAMP

tb_project_permission

  • project_permission_id — INT — Primary key — NOT NULL
  • project_id (project_id2) — INT — Foreign key → tb_project.project_id — NOT NULL
  • type (Field) — VARCHAR(50)
  • permission — VARCHAR(100) — NOT NULL
  • create_user_id — INT — NOT NULL
  • create_date — TIMESTAMP — NOT NULL
  • update_user_id — INT
  • update_date — TIMESTAMP

tb_user (tb_users)

  • user_id — INT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • create_user_id — INT — NOT NULL
  • create_date — TIMESTAMP — NOT NULL
  • update_user_id — INT
  • update_date — TIMESTAMP

tb_user_group

  • user_id — INT — Foreign key → tb_user.user_id — NOT NULL
  • group_id — INT — Foreign key → tb_group.group_id — NOT NULL
  • create_user_id — INT — NOT NULL
  • create_date — TIMESTAMP — NOT NULL