덕후감

테이블 (9)

books

  • id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • author — VARCHAR(100) — NOT NULL
  • description — TEXT
  • publisher — VARCHAR(100)
  • published_date — DATE
  • isbn — VARCHAR(20)
  • thumbnail_url — VARCHAR(255)
  • review_count — INT
  • rating — FLOAT
  • is_deleted — BOOLEAN

comments

  • id — BIGINT — 기본 키 — NOT NULL
  • review_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • is_deleted — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

dashboard_books

  • id — BIGINT — 기본 키 — NOT NULL
  • book_id — BIGINT — NOT NULL
  • score — FLOAT — NOT NULL
  • rank — INT — NOT NULL
  • period_type — ENUM('DAILY','WEEKLY','MONTHLY','ALL_TIME') — NOT NULL
  • calculated_at — TIMESTAMP

dashboard_reviews

  • id — BIGINT — 기본 키 — NOT NULL
  • review_id — BIGINT — NOT NULL
  • score — FLOAT — NOT NULL
  • rank — INT — NOT NULL
  • period_type — ENUM('DAILY','WEEKLY','MONTHLY','ALL_TIME') — NOT NULL
  • calculated_at — TIMESTAMP

dashboard_users

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — NOT NULL
  • score — FLOAT — NOT NULL
  • rank — INT — NOT NULL
  • period_type — ENUM('DAILY','WEEKLY','MONTHLY','ALL_TIME') — NOT NULL
  • calculated_at — TIMESTAMP

notifications

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — NOT NULL
  • review_id — BIGINT
  • content — VARCHAR(255)
  • is_read — BOOLEAN
  • created_at — TIMESTAMP
  • read_at — TIMESTAMP
  • deleted_at — TIMESTAMP

review_likes

  • id — BIGINT — 기본 키 — NOT NULL
  • review_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP

reviews

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — NOT NULL
  • book_id — BIGINT — NOT NULL
  • rating — FLOAT — NOT NULL
  • content — TEXT — NOT NULL
  • like_count — INT
  • comment_count — INT
  • is_deleted — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

users

  • id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • is_deleted — BOOLEAN
  • deleted_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP