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)