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