과제
테이블 (3)
Business card (business card)
- Korea Name (korea_name) — VARCHAR(10) — 외래 키 → Professor.Korea Name — NOT NULL
- China Name (china_name) — VARCHAR(10) — 외래 키 → Professor.China Name
- School Name (school name) — VARCHAR(10) — 외래 키 → School.School Name — NOT NULL
- Cell Phone (cell_phone) — VARCHAR(20) — 외래 키 → Professor.Cell Phone
- Fax (fax) — VARCHAR(20)
- Phone (phone) — VARCHAR(20)
- Degree (degree) — VARCHAR(10)
- Website (website) — VARCHAR(50)
- Field
Professor (professor)
- Korea Name (korea_name) — VARCHAR(10) — 기본 키 — NOT NULL
- China Name (china_name) — VARCHAR(10) — 기본 키
- Cell Phone (cell_phone) — VARCHAR(20) — 기본 키
- Email (email) — VARCHAR(20)
- Specialty (specialty) — VARCHAR(20) — NOT NULL
School (school)
- School Name (school name) — VARCHAR(10) — 기본 키 — NOT NULL
- Address (address) — VARCHAR(50)