week2

Tables (8)

Untitled (category)

  • Key (category_id) — BIGINT — Primary key — NOT NULL
  • Field (name) — VARCHAR(50) — NOT NULL

Untitled (book)

  • Key (book_id) — BIGINT — Primary key — NOT NULL
  • Field (title) — VARCHAR(100) — NOT NULL
  • Field (description) — TEXT
  • Field (created_at) — DATETIME — NOT NULL
  • Key (category_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (rental)

  • Key (rental_id) — BIGINT — Primary key — NOT NULL
  • Field (rented_at) — DATETIME — NOT NULL
  • Field (due_at) — DATETIME — NOT NULL
  • Field (returned_at) — DATETIME
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • Key (book_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (hashtag)

  • Key (hashtag_id) — BIGINT — Primary key — NOT NULL
  • Field (name) — VARCHAR(30) — NOT NULL

Untitled (book_hashtag)

  • Key (book_hashtag_id) — BIGINT — Primary key — NOT NULL
  • Key (book_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (hashtag_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (book_like)

  • Key (book_like_id) — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • Key (book_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (notification_allow_list)

  • Key (notification_allow_list_id) — BIGINT — Primary key — NOT NULL
  • Field (is_allow_notice) — BOOLEAN — NOT NULL
  • Field (is_allow_book_return) — BOOLEAN — NOT NULL
  • Field (is_allow_marketing) — BOOLEAN — NOT NULL

user

  • user_id — BIGINT — Primary key — NOT NULL
  • Field (kakao_id) — VARCHAR(100) — NOT NULL
  • Field (name) — VARCHAR(100) — NOT NULL
  • Field (nickname) — VARCHAR(100) — NOT NULL
  • Field (phone) — VARCHAR(20) — NOT NULL
  • Field (gender) — VARCHAR(10) — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL
  • Field (deleted_at) — DATETIME
  • Key (notification_allow_list_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL