booklog
Tables (10)
BookLogs
- id — BIGINT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- visibility — BOOLEAN
- status — ENUM('DRAFT', 'PUBLISHED')
- created_at — TIMESTAMP
- user_id — BIGINT — Foreign key → Users.id — NOT NULL
- book_id — BIGINT — Foreign key → Books.id — NOT NULL
Books
- id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- author — VARCHAR(255)
- publisher — VARCHAR(100)
- pub_year — INT
- description — TEXT
- cover_url — TEXT
- tag_id — BIGINT — Foreign key → Tags.id — NOT NULL
Follows
- id — BIGINT — Primary key — NOT NULL
- follower_id — BIGINT — NOT NULL
- following_id — BIGINT — NOT NULL
- user_id — BIGINT — Foreign key → Users.id — NOT NULL
Interactions
- id — BIGINT — Primary key — NOT NULL
- type — ENUM('LIKE', 'BOOKMARK') — NOT NULL
- user_id — BIGINT — Foreign key → Users.id — NOT NULL
- log_id — BIGINT — Foreign key → BookLogs.id — NOT NULL
Log_Images
- id — BIGINT — Primary key — NOT NULL
- image_url — TEXT — NOT NULL
- sequence — INT
- log_id — BIGINT — Foreign key → BookLogs.id — NOT NULL
QnA (QAs)
- id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- user_id — BIGINT — Foreign key → Users.id — NOT NULL
Tags
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- type — ENUM('GENRE', 'STYLE', 'AUTHOR') — NOT NULL
User_Books
- id — BIGINT — Primary key — NOT NULL
- status — ENUM('READING_LATER', 'READING', 'COMPLETED', 'STOPPED') — NOT NULL
- book_format — ENUM('PAPER', 'EBOOK', 'AUDIO')
- total_page — INT
- current_page — INT
- start_date — DATE
- end_date — DATE
- user_id — BIGINT — Foreign key → Users.id — NOT NULL
- book_id — BIGINT — Foreign key → Books.id — NOT NULL
User_Interests
- id — BIGINT — Primary key — NOT NULL
- tag_id — BIGINT — NOT NULL
- user_id — BIGINT — Foreign key → Users.id — NOT NULL
Users
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- profile_img — TEXT
- monthly_goal — INT