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