기말고사
테이블 (8)
Untitled (Thesis)
- Key (Thesis_ID) — int — 기본 키 — NOT NULL
- Field (title) — varchar(200)
- Field (abstract) — varchar(1000)
- Field (degreeType) — varchar(50)
- Field (subYear) — int
- Field (file_URL) — varchar(200)
- Field (advisorID) — int
- Field (authorID) — int
- Key (dept_ID) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (Student_ID) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (PROFESSOR)
- Key (PROFESSOR_Id) — int — 기본 키 — NOT NULL
- Field (name) — varchar(100)
- Field (departmentID) — int
Untitled (Department)
- Key (dept_ID) — int — 기본 키 — NOT NULL
- Field (dept_name) — varchar(100)
- Field (dept_legacy) — int
- Field (collegeName) — varchar(100)
- Key (deptLeg_ID) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (Keyword)
- Key (keywordID) — int — 기본 키 — NOT NULL
- Field (keword)
Untitled (Person)
- Key (person_ID) — int — 기본 키 — NOT NULL
- Field (nameKo) — varchar(50)
- Field (nameEn) — varchar(100)
- Field (birth_Date) — date
- Field
- Field2
Untitled (DepartmentLegacy)
- Key (deptLeg_ID) — int — 기본 키 — NOT NULL
- Field (currentName) — varchar(100)
- Field (collegeName)
Untitled (Student)
- Key (Student_ID) — int — 기본 키 — NOT NULL
- Field (degree)
- Field (entrance_year)
- Field (graduate_year)
- Field (status)
- Key (person_ID) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled2 (author / student)
- Key (author_ID) — int — 기본 키 — NOT NULL
- Field (name) — varchar(100)
- Field (email) — varchar(150)
- Field (studentID) — int
- Field (dateOfBirth) — varchar