memore_project

Tables (6)

Untitled (book)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • Key (category_id) — int(11) — Foreign key → Untitled.Key — NOT NULL
  • id (member_id) — bigint(20) — Foreign key → person.id — NOT NULL
  • Field (title) — varchar(255) — NOT NULL
  • Field (isbn) — varchar(255) — NOT NULL
  • Field (cover) — varchar(255)
  • Field (link) — varchar(255)
  • Field (description) — text
  • Field (author) — varchar(255) — NOT NULL
  • Field (publisher) — varchar(255) — NOT NULL
  • Field (published_date) — date — NOT NULL
  • Field (approved) — boolean — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (modified_at) — datetime — NOT NULL

Untitled (wish_book)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • id (member_id) — bigint(20) — Foreign key → person.id — NOT NULL
  • Key (book_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • Field (created_at) — datetime — NOT NULL

Untitled (category)

  • Key (code) — int(11) — Primary key — NOT NULL
  • Field (name) — varchar(255) — NOT NULL
  • Field (description) — varchar(255)
  • Field (created_at) — datetime — NOT NULL

Untitled (question)

  • Key (id) — int(11) — Primary key — NOT NULL
  • id (member_id) — bigint(20) — Foreign key → person.id — NOT NULL
  • Field (title) — varchar(255) — NOT NULL
  • Field (content) — text — NOT NULL
  • Field (complete) — boolean — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (modified_at) — datetime — NOT NULL

article

  • id — bigint(20) — Primary key — NOT NULL
  • id (member_id) — bigint(20) — Foreign key → person.id — NOT NULL
  • Key (book_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
  • title — varchar(255) — NOT NULL
  • text (content) — text
  • Field (view_count) — int(11) — NOT NULL
  • Field (done) — boolean — NOT NULL
  • Field (start_date) — date — NOT NULL
  • Field (end_date) — date
  • Field (rating_score) — tinyint
  • Field (is_hide) — boolean — NOT NULL
  • date_created (created_at) — datetime — NOT NULL
  • last_updatedl (modified_at) — datetime — NOT NULL
  • Field (deleted_at) — datetime — NOT NULL

person (member)

  • id — bigint(20) — Primary key — NOT NULL
  • email — varchar(255) — NOT NULL
  • number — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • Field (picture) — varchar(255)
  • Field (created_at) — datetime — NOT NULL
  • Field (modified_at) — datetime — NOT NULL
  • Field (deleted_at) — datetime — NOT NULL