erp

Tables (7)

Attendances (Untitled2)

  • attend_id (Key) — Primary key — NOT NULL
  • check_in (Field)
  • check_out (Field2)
  • status (Field3)
  • student_code (student_id) — INT — Foreign key → Students.student_code — NOT NULL
  • teach_id (Key2) — Foreign key → Teachers.teach_id — NOT NULL

Attitudes

  • attitude_id (Key) — Primary key — NOT NULL
  • attitude_desc (Field)
  • attitude_date (Field2)
  • student_id (Field3)
  • student_code (student_id) — INT — Foreign key → Students.student_code — NOT NULL
  • teach_id (Key2) — Foreign key → Teachers.teach_id — NOT NULL

Classes (Untitled3)

  • class_id (Key) — Primary key — NOT NULL
  • name (Field)
  • position (Field2)

Consult (Untitled4)

    Reports

    • report_id — Primary key — NOT NULL
    • score
    • subject
    • student_code (student_id) — INT — Foreign key → Students.student_code — NOT NULL
    • teach_id (Key) — Foreign key → Teachers.teach_id — NOT NULL

    Students

    • student_code (student_id) — INT — Primary key — NOT NULL
    • name (Field)
    • phone (Field2)
    • age (Field3)
    • gender (Field4)
    • addr (Field5)
    • phone2 (Field6)
    • attitude (Field7)
    • score (Field8)
    • subject (Field9)
    • teacher (Field10)
    • attendance (Field11)
    • attend_check (Field12)
    • consult (Field13)
    • consult_check (Field14)
    • status (Field15)
    • class_id (Key) — Foreign key → Classes.class_id — NOT NULL
    • teach_id (Key2) — Foreign key → Teachers.teach_id — NOT NULL

    Teachers (Untitled)

    • teach_id (Key) — Primary key — NOT NULL
    • name (Field)
    • phone (Field2)