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