SSO
Tables (7)
department (Untitled2)
- id (Key) — varchar — Primary key — NOT NULL
- name (Field) — varchar — NOT NULL
- parent_id (Field2) — varchar
- order_by (Field3) — int
mapping (Untitled5)
- id (Key) — int — Primary key — NOT NULL
- member_id (id) — varchar — Foreign key → member.id
- dept_id (Key3) — varchar — Foreign key → department.id
- service_id (Key4) — varchar — Foreign key → service.id — NOT NULL
- role_id (Key5) — varchar — Foreign key → role.id — NOT NULL
member (Untitled)
- id — varchar — Primary key — NOT NULL
- dept_id (Key) — varchar — Foreign key → department.id
- name (Field) — varchar — NOT NULL
- position (Field2) — varchar
- email (Field3) — varchar
- hp (Field4) — varchar
- order_by (Field6) — int
permission (Untitled6)
- id (Key) — varchar — Primary key — NOT NULL
- name (Field) — varchar — NOT NULL
- order_by (Field2) — int
permission_mapping (Untitled7)
- id (Key) — int — Primary key — NOT NULL
- role_id (Key3) — varchar — Foreign key → role.id — NOT NULL
- permission_id (Key2) — varchar — Foreign key → permission.id — NOT NULL
- dept_id (Key4) — varchar — Foreign key → department.id
- c (Field4) — boolean — NOT NULL
- r (Field5) — boolean — NOT NULL
- u (Field6) — boolean — NOT NULL
- d (Field7) — boolean — NOT NULL
- scope (Field8) — varchar
role (Untitled3)
- id (Key) — varchar — Primary key — NOT NULL
- service_id (Key2) — varchar — Foreign key → service.id — NOT NULL
- name (Field2) — varchar — NOT NULL
service (Untitled4)
- id (Key) — varchar — Primary key — NOT NULL
- url (Field) — varchar — NOT NULL