SH_Education

Tables (4)

Untitled3

  • content_title (Field) — VARCHAR(50)
  • content_outline (Field2) — VARCHAR(100)
  • content_regist_date (Field3) — VARCHAR(8)
  • upper_content_no (Field4) — INT
  • content_no (Field5) — INT
  • contents (Field6) — VARCHAR(255)

exam_category (Untitle)

  • category_id (Field) — INT — Primary key — NOT NULL
  • exam_title (Field2) — VARCHAR(20)
  • exam_regdate (Field3) — INT
  • exam_outline (Field4) — VARCHAR(100)

quiz (Untitled)

  • quiz_id (Field) — INT — Primary key — NOT NULL
  • quiz_title (Field1) — VARCHAR(20)
  • quiz_regdate (Field2) — INT
  • quiz_contents (Field3) — VARCHAR(200)
  • quiz_registrant (Field4) — VARCHAR(20)

quiz_has_exam_category (Untitled2)

  • category_id (Key) — INT — Primary key — NOT NULL
  • quiz_id (Key2) — INT — Primary key — NOT NULL
  • category_id (Field) — INT — Foreign key → exam_category.category_id — NOT NULL
  • quiz_id (Field2) — INT — Foreign key → quiz.quiz_id — NOT NULL