Professor_browse

Tables (5)

Application

  • 신청ID (App_ID) — INT — Primary key — NOT NULL
  • 학생이름 (Std_Name) — VARCHAR — NOT NULL
  • 학생연락처 (Std_contact) — VARCHAR — NOT NULL
  • 신청유형 (App_type) — VARCHAR — NOT NULL
  • 희망날짜 (Desired_date) — DATETIME — NOT NULL
  • 신청내용 (Content) — TEXT — NOT NULL
  • 처리상태 (Status) — VARCHAR — NOT NULL
  • 교수ID (Professor_ID) — INT — Foreign key → Professor.교수ID — NOT NULL

College

  • 단과대ID (Col_ID) — INT — Primary key — NOT NULL
  • 단과대이름 (Col_Name) — VARCHAR — NOT NULL

Department

  • 학과ID (Dep_ID) — INT — Primary key — NOT NULL
  • 학과이름 (Dep_name) — VARCHAR
  • 단과대ID (Col_ID) — INT — Foreign key → College.단과대ID — NOT NULL

Professor

  • 교수ID (Professor_ID) — INT — Primary key — NOT NULL
  • 교수이름 (Name) — VARCHAR — NOT NULL
  • 키워드 (Keywords) — VARCHAR
  • 연구분야 (Research) — TEXT
  • 연구실이름 (Labname) — VARCHAR
  • 사무실위치 (Office_loc) — VARCHAR
  • 이메일 (Email) — VARCHAR
  • 모집상태 (Recruiting_Status) — VARCHAR
  • 교수이미지 (Profile_img) — VARCHAR
  • 랩이미지 (Lab_image) — VARCHAR
  • Key (Dep_ID) — INT — Foreign key → Department.학과ID — NOT NULL

Publication

  • 실적ID (Pub_ID) — INT — Primary key — NOT NULL
  • 구분 (Category) — VARCHAR
  • 제목 (Title) — VARCHAR
  • 연도 (Pub_year) — CHAR(4)
  • 교수ID (Professor_ID) — INT — Foreign key → Professor.교수ID — NOT NULL