books

Tables (3)

BOOKCATEGORY (도서카테고리)

  • bookId — BIGINT — Foreign key → BOOKS.id — NOT NULL
  • categoryId — BIGINT — Foreign key → CATEGORIES.id — NOT NULL

BOOKS (도서)

  • id — BIGINT — Primary key — NOT NULL
  • title (제목) — VARCHAR(255)
  • author (저자) — VARCHAR(255)
  • status (상태) — VARCHAR(15)
  • createdAt (생성일) — DATETIME
  • updatedAt (변경일) — DATETIME

CATEGORIES (카테고리)

  • id — BIGINT — Primary key — NOT NULL
  • name (카테고리명) — VARCHAR(100) — NOT NULL