ReadingLog

Tables (9)

AUTHOR_ALIASES

  • alias_id — BIGSERIAL
  • work_id — BIGINT — Foreign key → WORKS.work_id — NOT NULL
  • alias_name — VARCHAR(50) — NOT NULL

WORKS

  • work_id — BIGSERIAL
  • normalized_title — VARCHAR(100) — NOT NULL
  • normalized_author — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP

book_editions

  • edition_id — BIGSERIAL
  • work_id — BIGINT — Foreign key → WORKS.work_id — NOT NULL
  • isbn — VARCHAR(20)
  • title — VARCHAR(100) — NOT NULL
  • publisher — VARCHAR(100)
  • cover_url — TEXT
  • google_books_id — VARCHAR(255)

comments

  • comment_id — BIGSERIAL
  • post_id — BIGINT — Foreign key → posts.post_id — NOT NULL
  • user_id — UUID — Foreign key → users.user_id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

follows

  • follower_id — UUID — Foreign key → users.user_id
  • following_id — UUID — Foreign key → users.user_id
  • created_at — TIMESTAMP

post_images

  • image_id — BIGSERIAL
  • post_id — BIGINT — Foreign key → posts.post_id — NOT NULL
  • image_url — TEXT — NOT NULL
  • created_at — TIMESTAMP

post_reactions

  • reaction_id — BIGSERIAL
  • post_id — BIGINT — Foreign key → posts.post_id — NOT NULL
  • user_id — UUID — Foreign key → users.user_id — NOT NULL
  • type — reaction_type — NOT NULL

posts

  • post_id — BIGSERIAL
  • user_id — UUID — Foreign key → users.user_id — NOT NULL
  • work_id — BIGINT — Foreign key → WORKS.work_id — NOT NULL
  • edition_id — BIGINT — Foreign key → book_editions.edition_id — NOT NULL
  • sentence — TEXT — NOT NULL
  • comment — TEXT — EX
  • filter_type — filter_type
  • underline_style — underline_style — NOT NULL
  • created_at — TIMESTAMP

users

  • user_id — UUID
  • email — VARCHAR(30) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(15) — NOT NULL
  • profile_image_url — TEXT
  • intro — VARCHAR(100)
  • created_at — TIMESTAMP