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