gcw_rbac

테이블 (11)

Copy Of Copy Of Copy Of Copy Of Copy Of Sessions3 (Objects)

  • index — INTEGER — 기본 키 — NOT NULL
  • name — VARCHAR(100) UNIQUE
  • Field (locked) — BOOLEAN

Copy Of Copy Of Copy Of Copy Of Copy Of Sessions32 (Operations)

  • index — INTEGER — 기본 키 — NOT NULL
  • name — VARCHAR(100) UNIQUE
  • Field (canCreate) — BOOLEAN
  • Field2 (canRead) — BOOLEAN
  • Field3 (canUpdate) — BOOLEAN
  • Field4 (canDelete) — BOOLEAN
  • Field5 (locked) — BOOLEAN

Copy Of Copy Of Copy Of Copy Of Sessions (RoleAssignment)

  • Key (index) — INTEGER — 기본 키 — NOT NULL
  • index (Roles.index) — INTEGER — 외래 키 → Copy Of Copy Of Copy Of Sessions.index — NOT NULL
  • index (Users.index) — INTEGER — 외래 키 → 사용자.사용자일련번호 — NOT NULL
  • index (UserGroups.index) — INTEGER — 외래 키 → Copy Of Copy Of Copy Of Sessions2.index — NOT NULL

Copy Of Copy Of Copy Of Copy Of Sessions2 (RolePermissions)

  • index — INTEGER — 기본 키 — NOT NULL
  • index (Roles.index) — INTEGER — 외래 키 → Copy Of Copy Of Copy Of Sessions.index — NOT NULL
  • index (Permisions.index) — INTEGER — 외래 키 → Copy Of Copy Of Copy Of Copy Of Sessions3.index — NOT NULL
  • name — VARCHAR(100) UNIQUE

Copy Of Copy Of Copy Of Copy Of Sessions22 (UserGroupMembers)

  • Key (index) — INTEGER — 기본 키 — NOT NULL
  • index (Users.index) — INTEGER — 외래 키 → 사용자.사용자일련번호 — NOT NULL
  • index (UserGroups.index) — INTEGER — 외래 키 → Copy Of Copy Of Copy Of Sessions2.index — NOT NULL
  • Field3 (created) — VARCHAR(100)

Copy Of Copy Of Copy Of Copy Of Sessions3 (Permissions)

  • index — INTEGER — 기본 키 — NOT NULL
  • index (Objects.index) — INTEGER — 외래 키 → Copy Of Copy Of Copy Of Copy Of Copy Of Sessions3.index — NOT NULL
  • index (Operation.index) — INTEGER — 외래 키 → Copy Of Copy Of Copy Of Copy Of Copy Of Sessions32.index — NOT NULL
  • name — VARCHAR(100) UNIQUE

Copy Of Copy Of Copy Of Sessions (Roles)

  • index — INTEGER — 기본 키 — NOT NULL
  • name — VARCHAR(100) UNIQUE

Copy Of Copy Of Copy Of Sessions2 (UserGroups)

  • index — INTEGER — 기본 키 — NOT NULL
  • name — VARCHAR(40) UNIQUE

Copy Of Copy Of Sessions2 (SessionRole)

  • index (Roles.index) — INTEGER — 외래 키 → Copy Of Copy Of Copy Of Sessions.index — NOT NULL
  • index (Sessions.index) — INTEGER — 외래 키 → Sessions.index — NOT NULL

Sessions

  • index — INTEGER — 기본 키 — NOT NULL
  • index (Users.index) — INTEGER — 외래 키 → 사용자.사용자일련번호 — NOT NULL
  • name — VARCHAR(64) UNIQUE
  • created — DATETIME

사용자 (Users)

  • 사용자일련번호 (index) — INTEGER — 기본 키 — NOT NULL
  • 사용자_이름 (name) — VARCHAR(40) UNIQUE
  • created (nonce) — DATETIME
  • Field (fitstName) — VARCHAR(50)
  • Field2 (familyName) — VARCHAR(100)
  • Field3 (email) — VARCHAR(100)