permission
Tables (8)
group (グループ그룹)
- id (Key) — uuid — Primary key — NOT NULL
- tenantId (Key3) — int/uuid — NOT NULL
- name (Field) — varchar
- description (Field4) — text
- Field3 — boolean
- talkEnabled (Field2) — boolean
- talkNoteEnabled (Field5) — boolean
- talkScheduleEnabled (Field6) — boolean
- talkTaskEnabled (Field7) — boolean
- talkFolderEnabled (Field8) — boolean
level (職級)
- id (Key) — int/uuid — Primary key — NOT NULL
- tenantId (Key2) — int/uuid — NOT NULL
- name (Field) — varchar
organization (グループと同じ 조직)
- id (Key) — uuid — Primary key — NOT NULL
- tenantId (Key3) — int/uuid — NOT NULL
- name (Field) — varchar
- description (Field4) — text
- Field3 — boolean
- talkEnabled (Field2) — boolean
- talkNoteEnabled (Field5) — boolean
- talkScheduleEnabled (Field6) — boolean
- talkTaskEnabled (Field7) — boolean
- talkFolderEnabled (Field8) — boolean
permission (管理テーブル)
- id (Key) — uuid — Primary key — NOT NULL
- type (Field) — enum(group, position, level, usagePermissionType) — Primary key
- userId (Key7) — int/uuid — Foreign key → user.id — NOT NULL
- tenantId (Key23) — int/uuid — Foreign key → user.tenantId — NOT NULL
- usagePermissionTypeId (Field2)
position (役職)
- id (Key) — uuid — Primary key — NOT NULL
- tenantId (Key2) — uuid — NOT NULL
- name (Field) — varchar
tenant (Untitled2)
- id (Key) — uuid — Primary key — NOT NULL
- name (Field) — varchar
- companyName (Field5)
- postcode (Field4)
- companyAddress (Field3)
- ceoName (Field2) — varchar
usagePermissionType (利用権限タイプ)
- id (Key) — uuid — Primary key — NOT NULL
- tenantId (Key2) — uuid — NOT NULL
- name (Field) — varchar
user (Untitled)
- id (Key) — uuid — Primary key — NOT NULL
- tenantId (Key2) — uuid — Primary key — NOT NULL
- name (Field) — varchar
- email (Field2) — varchar
- password (Field3) — varchar
- furiganaFirstName (Field4) — varchar
- furiganaLastName (Field5) — varchar
- telephone (Field6) — varchar
- mobilePhone (Field7) — varchar