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