Book
Tables (6)
Book (book)
- 책id (id) — BIGINT — Primary key — NOT NULL
- 책이름 (title) — varchar(100)
- 작가 (author) — varchar(45)
- isbn — varchar(45)
- 평균별점 (star) — int
- 표지 (image) — text
- 줄거리 (plot) — text
- 출판날짜 (date) — date
- Field
Book_Comment (book_comment)
- idi (id) — Bigint — Primary key — NOT NULL
- 책id (book_id) — BIGINT — Foreign key → Book.책id — NOT NULL
- 유저id (user_id) — BIGINT — Foreign key → User.유저id — NOT NULL
- 별점 (star) — int
Book_categories (book_categories)
- id — BIGINT — Primary key — NOT NULL
- 카테고리id (category_id) — BIGINT — Foreign key → Category.카테고리id — NOT NULL
- 책id (book_id) — BIGINT — Foreign key → Book.책id — NOT NULL
Category (category)
- 카테고리id (category_id) — BIGINT — Primary key — NOT NULL
- 카테고리이름 (category)
Post (post)
- postid (id) — BIGINT — Primary key — NOT NULL
- 제목 (title) — varchar(100)
- 본문 (content) — text
- 유저id (id2) — BIGINT — Foreign key → User.유저id — NOT NULL
- startdate (start_date) — date
- enddate (end_date) — date
- 작성날짜 (date) — date
- Field2
User (user)
- 유저id (id) — BIGINT — Primary key — NOT NULL
- 이름 (name) — varchar(45)
- 이메일 (email) — varchar(50)
- 비밀번호 (password) — varchar(45)
- 역할 (role) — varchar(20)
- 프로필이미지 (image) — text
- Field