pratice
Tables (5)
answerpdf (Untitled3)
- answer_pdf_id (Key) — INT — Primary key — NOT NULL
- pdf_path (Field) — VARCHAR(255)
- file_name (Field2) — VARCHAR(255)
- wb_id (Key2) — INT — Foreign key → workbook.wb_id — NOT NULL
user (Untitled5)
- id (Key) — INT — Primary key — NOT NULL
- email (Field) — VARCHAR(255)
- name (Field2) — VARCHAR(255)
- password (Field3) — VARCHAR(255)
- phone (Field4) — VARCHAR(50)
- loginInfo (Field5) — VARCHAR(10)
- token (Field6) — VARCHAR(255)
work_question (Untitled4)
- pr_id (Key) — INT — Primary key — NOT NULL
- pr_content (Field) — MEDIUMTEXT
- pr_wb_id (Field2) — INT
- wb_id (Key2) — INT — Foreign key → workbook.wb_id — NOT NULL
- pr_image_path (Field3) — VARCHAR(255)
- Field4
workbook (Untitled)
- wb_id (Key) — INT — Primary key — NOT NULL
- wb_title (Field) — VARCHAR(255)
- wb_sumtext (Field2) — MEDIUMTEXT
- wb_create (Field3) — DATE
- wb_title_answer (Field5) — VARCHAR(255)
- wb_content (Field6) — VARCHAR(45)
- wb_answer (Field7) — MEDIUMTEXT
- id (Key2) — INT — Foreign key → user.id — NOT NULL
workbookpdf (Untitled2)
- pdf_id (Key) — INT — Primary key — NOT NULL
- pdf_path (Field) — VARCHAR(255)
- file_name (Field2) — VARCHAR(255)
- wb_id (Key2) — INT — Foreign key → workbook.wb_id — NOT NULL