pageflow ERD
Tables (7)
account
- id — BIGINT — Primary key
- created_date — DATETIME
- modified_date — DATETIME
- provider — VARCHAR(255)
- username — VARCHAR(255)
- password — VARCHAR(255)
- email — VARCHAR(255)
- role — VARCHAR(255)
- profile_id — BIGINT
book
- id — BIGINT
- created_date — DATETIME
- modified_date — DATETIME
- title — VARCHAR(255)
- cover_img_url — VARCHAR(255)
- author_id — BIGINT
- is_published — BOOLEAN
chapter
- id — BIGINT
- created_date — DATETIME
- modified_date — DATETIME
- book_id — BIGINT
- title — VARCHAR(255)
- sort_priority — INT
comment
- id — BIGINT
- created_date — DATETIME
- modified_date — DATETIME
interaction
- id — BIGINT
- created_date — DATETIME
- modified_date — DATETIME
page
- id — BIGINT
- created_date — DATETIME
- modified_date — DATETIME
- chapter_id — BIGINT
- title — VARCHAR(255)
- content — LONGTEXT
- sort_priority — INT
preference
- id — BIGINT
- created_date — DATETIME
- modified_date — DATETIME