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