word_test_app

Tables (12)

Untitled (word_senses)

  • Key (id) — uuid — Primary key — NOT NULL
  • id (word_id) — uuid — Foreign key → words.id — NOT NULL
  • Field (definition) — varchar(100) — NOT NULL

Untitled (word_parts_of_speech)

  • id (word_id) — uuid — Foreign key → words.id — NOT NULL
  • id (part_of_speech_id) — uuid — Foreign key → wordclasses.id — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field2 (updated_at) — datetime — NOT NULL
  • Field3 (deleted_at) — datetime

Untitled (wordbook_spaces)

  • Key (id) — uuid — Primary key — NOT NULL
  • Field (name) — varchar(100) — NOT NULL
  • Field (visibility) — tinyint — NOT NULL
  • Field (description) — varchar(255)
  • Field (image) — varchar(255)

Untitled (wordbook_space_members)

  • id (member_id) — uuid — Foreign key → user.id — NOT NULL
  • Key (wordbook_space_id) — uuid — Foreign key → Untitled.Key — NOT NULL
  • Key (role_id) — uuid — Foreign key → Untitled.Key — NOT NULL
  • Field (privilege) — tinyint — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field2 (updated_at) — datetime — NOT NULL
  • Field3 (deleted_at) — datetime

Untitled (wordbook_space_role)

  • Key (id) — uuid — Primary key — NOT NULL
  • Key (wordbook_space_id) — uuid — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — varchar(10) — NOT NULL
  • Field (can_create) — boolean — NOT NULL
  • Field2 (can_update) — boolean — NOT NULL
  • Field3 (can_delete) — boolean — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field2 (updated_at) — datetime — NOT NULL
  • Field3 (deleted_at) — datetime

Untitled (wordbook_space_entry_codes)

  • Key (id) — uuid — Primary key — NOT NULL
  • Key (wordbook_space_id) — uuid — Foreign key → Untitled.Key — NOT NULL
  • Field (code) — uuid — NOT NULL
  • Field (expires_at) — datetime — NOT NULL

exams

  • id — uuid — Primary key — NOT NULL
  • UserId (examinee_id) — uuid — Foreign key → user.id — NOT NULL
  • name — varchar(30) — NOT NULL
  • minLevel (min_level) — int — NOT NULL
  • maxLevel (max_level) — int — NOT NULL
  • createdAt (created_at) — datetime — NOT NULL
  • updatedAt (updated_at) — datetime — NOT NULL
  • deletedAt (deleted_at) — datetime

examwords (exam_words)

  • WordId (word_id) — uuid — Foreign key → words.id — NOT NULL
  • ExamId (exam_id) — uuid — Foreign key → exams.id — NOT NULL
  • Field (is_correct) — boolean — NOT NULL
  • createdAt (created_at) — datetime — NOT NULL
  • updatedAt (updated_at) — datetime — NOT NULL
  • deletedAt (deleted_at) — datetime

user (users)

  • id — uuid — Primary key — NOT NULL
  • email — varchar(30) — NOT NULL
  • nickname — varchar(20) — NOT NULL
  • password — varchar(100) — NOT NULL
  • role — varchar(20) — NOT NULL
  • image — varchar(100)
  • Field (enabled) — boolean — NOT NULL
  • createdAt (created_at) — datetime — NOT NULL
  • updatedAt (updated_at) — datetime — NOT NULL
  • deletedAt (deleted_at) — datetime

wordbooks

  • id — uuid — Primary key — NOT NULL
  • id (owner_id) — uuid — Foreign key → user.id — NOT NULL
  • Key (wordbook_space_id) — uuid — Foreign key → Untitled.Key — NOT NULL
  • name — varchar(100) — NOT NULL
  • Field (image) — varchar(255)
  • createdAt (created_at) — datetime — NOT NULL
  • updatedAt (updated_at) — datetime — NOT NULL
  • deletedAt (deleted_at) — datetime

wordclasses (parts_of_speech)

  • id — uuid — Primary key — NOT NULL
  • name — varchar(10) — NOT NULL
  • createdAt (created_at) — datetime — NOT NULL
  • updatedAt (updated_at) — datetime — NOT NULL
  • deletedAt (deleted_at) — datetime

words

  • id — uuid — Primary key — NOT NULL
  • WordbookId (wordbook_id) — uuid — Foreign key → wordbooks.id — NOT NULL
  • kanji — varchar(20) — NOT NULL
  • hiragana — varchar(20) — NOT NULL
  • katakana — varchar(20)
  • level — tinyint — NOT NULL
  • createdAt (created_at) — datetime — NOT NULL
  • updatedAt (updated_at) — datetime — NOT NULL
  • deletedAt (deleted_at) — datetime