Book for
Tables (6)
book_list
- isbn (Key) — VARCHAR(125) — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- thumbnail — VARCHAR(255)
- authors — VARCHAR(125) — NOT NULL
- publisher — VARCHAR(50) — NOT NULL
- url — VARCHAR(500)
- kakao — BOOLEAN
collection (Untitled)
- c_code (Key) — Primary key — NOT NULL
- username (Key2) — Foreign key → user.username — NOT NULL
- c_name (Field)
collection_book (Untitled2)
- c_code (Key2) — Foreign key → collection.c_code — NOT NULL
- isbn (Key3) — VARCHAR(125) — Foreign key → book_list.isbn — NOT NULL
my_paragraph
- p_code (Key3) — BIGINT — Primary key — NOT NULL
- my_isbn — VARCHAR(50) — NOT NULL
- my_paragraph — VARCHAR(600)
user
- username (Key) — Primary key — NOT NULL
- password — VARCHAR(255) — NOT NULL
- profile_image — VARCHAR(255)
- nickname — VARCHAR(20) — NOT NULL
- birthdate — VARCHAR(255)
- level — INT
- delete_date — VARCHAR(255)
user_book
- username (Key) — Foreign key → user.username — NOT NULL
- isbn (Key2) — VARCHAR(125) — Foreign key → book_list.isbn — NOT NULL
- b_paragraph — VARCHAR(255)
- b_state — VARCHAR(20)
- b_reg_date — timestamp — NOT NULL
- b_buy_date — VARCHAR(125)
- b_start_date — VARCHAR(125)
- b_done_date — VARCHAR(125)
- my_star (Field)