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