ㄷㅂㅅ

Tables (6)

certificate

  • CREATE — TABLE

course_history

  • course_history_id — INT — Primary key — NOT NULL
  • student_id — INT — NOT NULL
  • professor_id — INT — NOT NULL
  • course_name — VARCHAR(100) — NOT NULL
  • semester — VARCHAR(20) — NOT NULL
  • credit — INT — NOT NULL
  • grade — VARCHAR(10) — NOT NULL

major_history

  • major_id — INT — Primary key — NOT NULL
  • student_id — INT — NOT NULL
  • major_name — VARCHAR(100) — NOT NULL
  • department — VARCHAR(50)
  • admission_date — DATE — NOT NULL
  • graduation_date — DATE

professor

  • professor_id — INT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • department — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(15) — NOT NULL
  • email — VARCHAR(100) — NOT NULL

project

  • project_id — INT — Primary key — NOT NULL
  • student_id — INT — NOT NULL
  • professor_id — INT — NOT NULL
  • project_name — VARCHAR(100) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • description — TEXT

student

  • student_id — INT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • birth_date — DATE — NOT NULL
  • phone — VARCHAR(15) — NOT NULL
  • email — VARCHAR(100) — NOT NULL