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