Book
Tables (8)
activity
- id — bigint — Primary key — NOT NULL
- status_id — bigint — Foreign key → status.status_id — NOT NULL
- activity_dt — datetime
- page — int
- current_page — int
- activity_type — ENUM
- created_dt — datetime
book (도서)
- book_id (도서 고유 아이디) — bigint — Primary key — NOT NULL
- title — varchar(200)
- isbn — varchar(50)
- author — varchar(100)
- publisher — varchar(100)
- page — int
- description — text
- image_url — varchar(1000)
- link — varchar(1000)
- published_date — date
- created_dt — datetime
- deleted_dt — datetime
delete_user
- id — bigint — Primary key — NOT NULL
- user_id — bigint
- role — VARCHAR(255)
- nickname — VARCHAR(255)
- email — VARCHAR(255)
- joined_at — VARCHAR(255)
- created_at — VARCHAR(255)
file
- id — bigint — Primary key — NOT NULL
- name — varchar(255)
- url — varchar(255)
- size — bigint
- type — varchar(50)
- created_dt — datetime
- updated_dt — datetime
review (리뷰)
- review_id (리뷰 고유 아이디) — bigint — Primary key — NOT NULL
- user_id (유저 고유 아이디) — bigint — Foreign key → user.user_id — NOT NULL
- book_id (도서 고유 아이디) — bigint — Foreign key → book.book_id — NOT NULL
- rating (평점(별점)) — decimal(2,1)
- content (내용) — varchar(800)
- created_dt (등록일시) — datetime
- updated_dt (수정일시) — datetime
- deleted_dt (삭제일시) — datetime
status (독서기록)
- status_id (독서기록 고유 아이디) — bigint — Primary key — NOT NULL
- user_id (유저 고유 아이디) — bigint — Foreign key → user.user_id — NOT NULL
- book_id (도서 고유 아이디) — bigint — Foreign key → book.book_id — NOT NULL
- status (독서 상태) — varchar(20)
- current_page (현재 페이지 수) — int
- start_dt (시작일) — date
- end_dt (종료일) — date
- created_dt (등록일시) — datetime
- updated_dt (수정일시) — datetime
- deleted_dt (삭제일시) — datetime
user (유저)
- user_id (유저 고유 아이디) — bigint — Primary key — NOT NULL
- role — varchar(10)
- nickname — varchar(50)
- email — varchar(100)
- social_id — varchar(100)
- social_type — varchar(10)
- refresh_token — varchar(255)
- created_dt — datetime
- updated_dt — datetime
user_book (사용자 도서)
- Key — Primary key — NOT NULL
- Field