기말고사

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