방과후 관리 프로그램 erd

테이블 (6)

afterschool

  • program_id — INT
  • teacher_id — INT — NOT NULL
  • title — VARCHAR(100)
  • description — TEXT
  • schedule — VARCHAR(50)
  • room — VARCHAR(20)
  • capacity — INT

attendance

  • attendance_id — INT
  • student_id — INT — NOT NULL
  • program_id — INT — NOT NULL
  • date — DATE
  • status — VARCHAR(20)

enrollment

  • enrollment_id — INT
  • student_id — INT — NOT NULL
  • program_id — INT — NOT NULL
  • apply_date — DATE
  • status — VARCHAR(20)

student

  • student_id — INT
  • user_id — INT — NOT NULL
  • grade — INT
  • class — VARCHAR(20)
  • parent_name — VARCHAR(50)
  • parent_phone — VARCHAR(20)

teacher

  • teacher_id — INT
  • user_id — INT — NOT NULL
  • dept — VARCHAR(50)
  • phone — VARCHAR(20)
  • email — VARCHAR(50)
  • hire_date — DATE

user

  • user_id — INT
  • login_id — VARCHAR(50) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • password — VARCHAR(100) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20)
  • created_at — DATETIME