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