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)