11

테이블 (7)

major_student (Untitled2)

  • major (Field)
  • student_id (Field2)
  • name (Field3)

professor (Untitled4)

  • professor_no (Key) — 기본 키 — NOT NULL
  • name (Field)
  • specialty (Field2)
  • phone_number (Field3)
  • lab (Field4)

student (Untitled3)

  • student_id (Key) — 기본 키 — NOT NULL
  • name (Field)
  • res_no (Field2)
  • birth_date (Field3)
  • age (Field4)
  • major (Field5)
  • entrance_yn (Field6)
  • grade (Field7)
  • professor_no (Key2) — 외래 키 → professor.professor_no — NOT NULL

view_applicant_seoul (CopyOfUntitled3)

  • applic.ant_no (Key) — NOT NULL
  • name (Field)
  • address (Field2)
  • pgone_number (Field3)
  • apply_no (Field4)

광주 응모자 (CopyOfUntitled2)

  • applic.ant_no (Key) — 기본 키 — NOT NULL
  • name (Field)
  • address (Field2)
  • pgone_number (Field3)
  • apply_no (Field4)
  • win_no (Field5)
  • city_no(003) (Field6)

부산응모자 (CopyOfUntitled)

  • applic.ant_no (Key) — 기본 키 — NOT NULL
  • name (Field)
  • address (Field2)
  • pgone_number (Field3)
  • apply_no (Field4)
  • win_no (Field5)
  • city_no(004) (Field6)

서울 응모자 (Untitled)

  • applic.ant_no (Key) — 기본 키 — NOT NULL
  • name (Field)
  • address (Field2)
  • pgone_number (Field3)
  • apply_no (Field4)
  • win_no (Field5)
  • city_no(002) (Field6)