과제

테이블 (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)