erp

Tables (5)

Untitled (student)

  • Key (student_code) — INT — Primary key — NOT NULL
  • Field (name)
  • Field (phone)
  • Field (age)
  • Field (gender)
  • Field (addr)
  • Field (phone2)
  • Field (consult)
  • Field (consult_check)
  • Field (status)
  • Key (teach_id) — Foreign key → Untitled.Key — NOT NULL

Untitled (Attitudes)

  • Key (attitude_id) — Primary key — NOT NULL
  • Field (attitude_desc)
  • Field (attitude_date)
  • Key (student_code) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (teach_id) — Foreign key → Untitled.Key — NOT NULL

Untitled (Teachers)

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

Untitled (Reports)

  • Key (report_id) — Primary key — NOT NULL
  • Field (score)
  • Field (subject)
  • Key (student_code) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (teach_id) — Foreign key → Untitled.Key — NOT NULL

Untitled (Attendances)

  • Key (attend_id) — Primary key — NOT NULL
  • Field (check_in)
  • Field (check_out)
  • Field (status)
  • Key (student_code) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (teach_id) — Foreign key → Untitled.Key — NOT NULL