책봇

테이블 (4)

books

  • book_id (PK) — INT(11) — 기본 키 — NOT NULL
  • book_title (Field) — VARCHER(100)
  • book_author (Field2) — VARCHAR(100)
  • book_price (Field3) — VARCHAR(50)
  • book_grade (Field4) — INT(10)
  • book_content (Field5) — TEXT
  • book_genre (Field6) — VARCHAR(40)

chatbot_train_data

  • id (PK) — INT(10) — 기본 키 — NOT NULL
  • intent (Field) — VARCHAR(45)
  • ner (Field2) — VARCHAR(1024)
  • query (Field3) — TEXT
  • answer (Field4) — TEXT
  • answer_image (Field5) — VARCHAR(2048)

preference

  • preference_id (Key) — INT(11) — 기본 키 — NOT NULL
  • u_id (Key2) — INT(11) — 외래 키 → user.u_id — NOT NULL
  • preference_author (Field2) — VARCHAR(100)
  • preference_title (Field3) — VARCHAR(100)
  • preference_genre (Field4) — INT(10)

user

  • u_id (Key) — INT(11) — 기본 키 — NOT NULL
  • user_id (Field) — VARCHAR(100)
  • user_password (Field2) — VARCHAR(100)
  • user_age (Field3) — INT(10)
  • user_gender (Field4) — VARCHAR(10)