GCW_RBAC

Tables (4)

Roles (CopyOfCopyOfUntitled)

  • index (Key) — INTEGER — Primary key — NOT NULL
  • name (Field2) — VARCHAR(100) UNIQUE

Sessions (Untitled)

  • index (Key) — INTEGER — Primary key — NOT NULL
  • name (Field) — VARCHAR(64) UNIQUE
  • created (Field2) — DATETIME

Users (CopyOfUntitled2)

  • index (Key) — INTEGER — Primary key — NOT NULL
  • name (Field) — VARCHAR(64) UNIQUE
  • created (Field2) — DATETIME

sessionRole (CopyOfUntitled)

  • Roles.index (Key) — INTEGER — Foreign key → Roles.index — NOT NULL
  • Sessions.index (Key2) — INTEGER — Foreign key → Sessions.index — NOT NULL