edu
Tables (19)
attendance_records (Untitled17)
- attend_num (Key3) — Primary key — NOT NULL
- student_num (Key) — Foreign key → enrollments.student_num — NOT NULL
- course_num (Key2) — Foreign key → enrollments.course_num — NOT NULL
- session_num (Field) — notnull
- attend_status (Field2) — notnull
cart (Untitled7)
- cart_num (Key) — Primary key — NOT NULL
- student_num (Key2) — Foreign key → student.student_num — NOT NULL
- couse_num (Key3) — Foreign key → course.course_num — NOT NULL
course (Untitled3)
- course_num (Key) — Primary key — NOT NULL
- course_ name (Field) — notnull
- course_content (Field2)
- teacher_num (Key2) — Foreign key → teacher.teacher_num — NOT NULL
curriculum (Untitled14)
- course_num (Key) — Foreign key → course.course_num — NOT NULL
- session_num (Field) — notnull
- sesssion_content (Field2) — notnull
enrollments (Untitled8)
- student_num (Key) — Foreign key → student.student_num — NOT NULL
- course_num (Key2) — Foreign key → course.course_num — NOT NULL
grade (Untitled2)
- grade_num (Key) — Primary key — NOT NULL
- student_num (Key3) — Foreign key → student.student_num — NOT NULL
- test_num (Key2) — Foreign key → test.test_num — NOT NULL
- course_num (Key22) — Foreign key → test.course_num — NOT NULL
notices (Untitled15)
- notice_num (Key) — Primary key — NOT NULL
- course_num (Key2) — Foreign key → course.course_num — NOT NULL
- notice_title (Field)
- notice_content (Field2)
online_class (Untitled9)
- online_class_num (Key) — Primary key — NOT NULL
- couse_num (Key2) — Foreign key → course.course_num — NOT NULL
- session_num (Field) — notnull
- online_class_name (Field2) — notnull
- online_class_store (Field3) — notnull
payment (Untitled12)
- purchase_num (Key) — Foreign key → purchase.purchase_num — NOT NULL
- confirmnumber (Field)
- cardnum (Field2)
- tid (Field3)
- totalprice (Field4)
- resultmessage (Field5)
- paymethod (Field6)
- appidate (Field7)
- appltime (Field8)
- purchasename (Field9)
purchase (Untitled10)
- purchase_num (Key) — Primary key — NOT NULL
- student_num (Key2) — Foreign key → student.student_num — NOT NULL
- purchase_price (Field) — notnull
- purchase_date (Field2) — notnull
- purchase_status (Field3)
purchase_list (Untitled11)
- purchase_num (Key) — Foreign key → purchase.purchase_num — NOT NULL
- couse_num (Key2) — Foreign key → course.course_num — NOT NULL
qa_table (Untitled)
- question_num (Key) — Primary key — NOT NULL
- student_num (Key2) — Foreign key → student.student_num — NOT NULL
- teacher_num (Key3) — Foreign key → teacher.teacher_num — NOT NULL
- question_date (Field)
- answer_content (Field2)
- answer_date (Field3)
- update_date (Field4)
student
- student_num (Key) — Primary key — NOT NULL
- student_name (Field) — notnull
- student_Id (Field2) — notnull
- student_Pw (Field3) — notnull
- student_Birth (Field4) — notnull
- student_email (Field5) — notnull
- student_gender (Field6) — notnull
- student_phone (Field7) — notnull
- student_Addr (Field8) — notnull
- student_addr_detail (Field9)
student_alerts (Untitled4)
- student_num (Key2) — Foreign key → student.student_num — NOT NULL
- tc_alerts_num (Key3) — Foreign key → teacher_alerts.tc_alerts_num — NOT NULL
student_test_answer (Untitled19)
- test_num (Key2) — Foreign key → test_questions.test_num — NOT NULL
- course_num (Key22) — Foreign key → test_questions.course_num — NOT NULL
- student_num (Key3) — Foreign key → student.student_num — NOT NULL
- test_question_num (Field) — Foreign key → test_questions.test_question_num
- student_answer (Field2)
teacher (Untitled5)
- teacher_num (Key) — Primary key — NOT NULL
- teacher_id (Field) — notnull
- teacher_pw (Field2) — notnull
- teacher_jumin (Field3) — notnull
- teacher_addr (Field4) — notnull
- teacher_addr_detail (Field5)
- teacher_phone (Field6) — notnull
- teacher_email (Field7) — notnull
- teacher_name (Field8) — notnull
- teacher_gender (Field9) — notnull
- teacher_birth (Field10) — notnull
- teacher_register (Field11) — notnull
teacher_alerts (Untitled6)
- tc_alerts_num (Key) — notnull — Primary key — NOT NULL
- teacher_num (Key2) — Foreign key → teacher.teacher_num — NOT NULL
- alerts_title (Field) — notnull
- course_num (Key3) — Foreign key → course.course_num — NOT NULL
- alerts_content (Field2) — notnull
test (Untitled13)
- test_num (Key) — Primary key — NOT NULL
- course_num (Key2) — Foreign key → course.course_num — NOT NULL
- test_date (Field) — notnull
test_questions (Untitled18)
- test_question_num (Field) — Primary key
- test_num (Key2) — Foreign key → test.test_num — NOT NULL
- course_num (Key22) — Foreign key → test.course_num — NOT NULL
- test_question_content (Field2) — notnull
- test_question_category (Field3) — notnull
- test_question_answer (Field4) — notnull