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