permission-architecture
Tables (28)
Copy Of Copy Of permission_group (CopyOfCopyOfCopyOfpermission_group)
- api_id (Key) — serial — Foreign key → Copy Of api.api_id — NOT NULL
- permission_group_id — serial — Foreign key → Copy Of permission_group.permission_group_id — NOT NULL
Copy Of action (CopyOfUntitled2)
- action_id (Key) — serial — Primary key — NOT NULL
- keyword (Field) — varchar(100) — NOT NULL — unique
- is_action_api (Field2) — bool — NOT NULL — defalut(false)
Copy Of action_permission_group (CopyOfCopyOfapi_permission_group)
- action_permission_gropu_id (Key4) — serial — Primary key — NOT NULL
- action_id (Key) — serial — Foreign key → Copy Of action.action_id — NOT NULL
- page_id (Key2) — serial — Foreign key → Copy Of page.page_id — NOT NULL
- permission_group_id — serial — Foreign key → Copy Of permission_group.permission_group_id — NOT NULL
- api_id (Key3) — serial — Foreign key → Copy Of api.api_id
- is_action_api (Field) — bool — NOT NULL — deafult(false)
Copy Of api (CopyOfUntitled82)
- api_id (Key) — serial — Primary key — NOT NULL
- path (Field) — varchar(100) — NOT NULL
- method (Field2) — varchar(10) — NOT NULL
Copy Of page (CopyOfUntitled3)
- page_id (Key) — serial — Primary key — NOT NULL
- path (Field) — varchar(100) — NOT NULL
Copy Of permission_group (CopyOfCopyOfpermission_group)
- permission_group_id — serial — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
action
- action_id — serial — Primary key — NOT NULL
- keyword — varchar(100)
action_permission_group (Untitled)
- action_id — serial — Foreign key → action.action_id — NOT NULL
- permission_group_id — serial — Foreign key → permission_group.permission_group_id — NOT NULL
- page_id — serial — Foreign key → page.page_id — NOT NULL
api (CopyOfUntitled8)
- api_id (Key) — serial — Primary key — NOT NULL
- path (Field) — varchar(100) — NOT NULL — unique(path + method)
- method (Field2) — varchar(10) — NOT NULL — unique(path + method)
api
- api_id — serial — Primary key — NOT NULL
- path — varchar(100)
- method
api_permission_group
- permission_group_id — integer — Foreign key → permission_group.permission_group_id — NOT NULL
- api_id — integer — Foreign key → api.api_id — NOT NULL
fuction(action) (Untitled2)
- function_id (Key) — serial — Primary key — NOT NULL
- api_id (Key2) — integer — Foreign key → api.api_id
- keyword — varchar(100) — unique
function_permission_group (CopyOfapi_permission_group)
- function_id (Key) — integer — Foreign key → fuction(action).function_id — NOT NULL
- permission_group_id — serial — Foreign key → permission_group.permission_group_id — NOT NULL
- page_id (Key2) — serial — Foreign key → page.page_id
menu
- menu_id — serial — Primary key — NOT NULL
- parent_menu_id — integer — Foreign key → menu.menu_id — NOT NULL
- name — varchar(100)
menu (Untitled6)
- menu_id (Key) — serial — Primary key — NOT NULL
- page_id (Key3) — serial — Foreign key → page.page_id
- name (Field) — varchar(100) — NOT NULL
- path — varchar(100) — NOT NULL
menu_permission_group (menu_page_permission_group)
- menu_id — serial — Foreign key → menu.menu_id — NOT NULL
organization
- organization_id — serial — Primary key — NOT NULL
- name — varchar(100)
organization (Untitled8)
- organization_id (Key) — serial — Primary key — NOT NULL
- name (Field) — varchar(100) — NOT NULL
page (Untitled3)
- page_id (Key) — serial — Primary key — NOT NULL
- path (Field) — varchar(100) — NOT NULL
- active (Field2) — bool — NOT NULL
page
- page_id — serial — Primary key — NOT NULL
- path — varchar(100)
page_permission_group (Untitled4)
- permission_group_id — integer — Foreign key → permission_group.permission_group_id — NOT NULL
- page_id (Key) — integer — Foreign key → page.page_id — NOT NULL
permission_group
- permission_group_id — serial — Primary key — NOT NULL
- name
- isSuper — NOT NULL
permission_group (CopyOfpermission_group)
- permission_group_id — serial — Primary key — NOT NULL
- service_id — serial — Foreign key → service.service_id
- name — varchar(100) — NOT NULL — unique
- is_super — NOT NULL
service (Untitled5)
- service_id — serial — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- organization_id (Field) — NOT NULL
user (Untitled7)
- user_id (Key) — serial — Primary key — NOT NULL
- name (Field) — varchar(100) — NOT NULL — unique
- password (Field2) — varchar(100) — NOT NULL
user
- user_id — Primary key — NOT NULL
- name
- password
user_permission_group (Untitled10)
- user_id (Key) — integer — Foreign key → user.user_id — NOT NULL
- permission_group_id — integer — Foreign key → permission_group.permission_group_id — NOT NULL
user_permission_group
- user_id — integer — Foreign key → user.user_id — NOT NULL
- permission_group_id — integer — Foreign key → permission_group.permission_group_id — NOT NULL