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