1

Tables (3)

E-mail (Untitled)

  • E-mail (e-mail) — VARCHAR(50) — Foreign key → Professor.E-mail — NOT NULL
  • professor (Professor) — VARCHAR(10) — Foreign key → Professor.professor — NOT NULL
  • school_email (School_email) — VARCHAR(50)
  • indiviual_email (Indiviual_email) — VARHCAR(50)

Professor (professor)

  • E-mail (e-mail) — VARCHAR(50) — Primary key — NOT NULL
  • professor (Professor) — VARCHAR(10) — Foreign key → School.professor — NOT NULL
  • Phone_n (phone_n) — VARCHAR(20)
  • Cellphone_n (cellphone_n) — VARCHAR(20)
  • Fax (fax) — VARCHAR(20)
  • Website (website) — VARCHAR(50)

School (school)

  • professor (Professor) — VARCHAR(10) — Primary key — NOT NULL
  • korea name (Korea name) — VARCHAR(20)
  • English name (english name) — VARCHAR(30)
  • Address (address) — VARCHAR(50)
  • Major (major) — VARCHAR(20)