booknote
Tables (4)
Untitled (user)
- Key (id) — INT — Primary key — NOT NULL
- Field (email) — VARCHAR(255) — NOT NULL
- Field (password) — VARCHAR(255) — NOT NULL
- Field (created_at) — DATETIME — NOT NULL
- Field (disabled_at) — DATETIME
Untitled (booknote)
- Key (id) — INT — Primary key — NOT NULL
- Key (user_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (book_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (start_date) — DATE
- Field (end_date) — DATE
- Field (rating) — TINYINT
- Field (created_at) — DATETIME — NOT NULL
Untitled (book)
- Key (id) — INT — Primary key — NOT NULL
- Field (title) — VARCHAR(255) — NOT NULL
- Field (isbn) — VARCHAR(24) — NOT NULL
- Field (thumbnail_path) — VARCHAR(255)
Untitled (booknote_memo)
- Key (id) — INT — Primary key — NOT NULL
- Key (booknote_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (content) — TEXT — NOT NULL
- Field (created_at) — DATETIME — NOT NULL