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