테스트

테이블 (5)

books

  • book_id — INT — 기본 키 — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • author — VARCHAR(100) — NOT NULL
  • publisher — VARCHAR(100)
  • genre — VARCHAR(50)
  • cover_img — VARCHAR(500)
  • pub_date — DATE

goals

  • goal_id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → users.user_id — NOT NULL
  • month — VARCHAR(7) — NOT NULL
  • target — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

reading_records

  • record_id — INT — 기본 키 — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • start_date — DATE
  • end_date — DATE
  • memo — TEXT
  • created_at — DATETIME — NOT NULL
  • user_id — INT — 외래 키 → users.user_id — NOT NULL
  • book_id — INT — 외래 키 → books.book_id — NOT NULL

reviews

  • review_id — INT — 기본 키 — NOT NULL
  • rating — TINYINT — NOT NULL
  • content — VARCHAR(500) — NOT NULL
  • is_deleted — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • user_id — INT — 외래 키 → users.user_id — NOT NULL
  • book_id — INT — 외래 키 → books.book_id — NOT NULL

users

  • user_id — INT — 기본 키 — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL