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)