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