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