itbook
Tables (3)
book
- 책 ID (Key) — Primary key — NOT NULL
- title — VARCHAR(250) — NOT NULL
- writer — VARCHAR(250) — NOT NULL
- publisher — VARCHAR(250) — NOT NULL
- price — INT — NOT NULL
- pub_date — DATE — NOT NULL
- summery — LONGTEXT — NOT NULL
- content — LONGTEXT
comment
- comment_id — INT — NOT NULL
- content — LONGTEXT
- 책 ID (book_id) — int — Foreign key → book.책 ID
- Field
user
- id — INT — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL