erp

Tables (3)

Attitudes (Untitled2)

  • attitude_id (Key) — Primary key — NOT NULL
  • attitude_desc (Field)
  • attitude_date (Field2)
  • student_id (Key2) — INT — Foreign key → students.student_id — NOT NULL

Reports (Untitled3)

  • report_id (Key) — Primary key — NOT NULL
  • score (Field)
  • subject (Field2)
  • student_id (Key2) — INT — Foreign key → students.student_id — NOT NULL

students (Untitled)

  • student_id (Key) — INT — Primary key — NOT NULL
  • name (Field)
  • phone (Field2)
  • age (Field3)
  • gender (Field4)
  • addr (Field5)
  • phone2 (Field6)
  • teacher (Field10)
  • attendance_check (Field11)
  • check (Field12)
  • consult (Field13)
  • consult_check (Field14)
  • status (Field15)
  • student_id (Key2) — INT — Foreign key → students.student_id — NOT NULL