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