책봇
테이블 (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)