2023-2학기_학사DB

테이블 (12)

Lab

  • id (Key) — char(8) — 기본 키 — NOT NULL
  • Field (name) — nvarchar(30)
  • id (profid) — char(8) — 외래 키 → Professor.id — NOT NULL

Paper

  • Key (id) — char(8) — 기본 키 — NOT NULL
  • title — nvarchar(50)
  • date — datetime2

Paper_Participate

  • Key (paperid) — char(8) — 외래 키 → Paper.Key — NOT NULL
  • key (profid) — char(8) — 외래 키 → Professor.id — NOT NULL
  • Key (studentid) — char(8) — 외래 키 → Untitled.Key — NOT NULL

Professor

  • id — char(8) — 기본 키 — NOT NULL
  • name — nvarchar(30)
  • phone — char(11)
  • depid — char(8) — 외래 키 → Untitled.Key — NOT NULL
  • Field (City) — nvarchar(10)
  • Field (Bunzi) — nvarchar(10)
  • Key (zip) — char(5) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Student)

  • Key (id) — char(8) — 기본 키 — NOT NULL
  • Field (name) — nvarchar(30)
  • Field (phone) — char(11)
  • Key (depid) — char(8) — 외래 키 → Untitled.Key — NOT NULL
  • key (jidoprof) — char(8) — 외래 키 → Professor.id — NOT NULL
  • id (labid) — char(8) — 외래 키 → Lab.id — NOT NULL
  • Field (City) — nvarchar(10)
  • Field (Bunzi) — nvarchar(10)
  • Key (zip) — char(5) — 외래 키 → Untitled.Key — NOT NULL
  • Field (juminnum) — char(15)

Untitled (Department)

  • Key (id) — char(8) — 기본 키 — NOT NULL
  • Field (name) — nvarchar(30)
  • Field (phone) — char(11)
  • Field (City) — nvarchar(10)
  • Field (bunzi) — nvarchar(10)
  • Key (zip) — char(5) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Course)

  • Key (id) — char(8) — 기본 키 — NOT NULL
  • Field (name) — nvarchar(50)
  • date — datetime2

Untitled (Sugang)

  • Key (studentid) — char(8) — 외래 키 → Untitled.Key — NOT NULL
  • Key (courseid) — char(8) — 외래 키 → Untitled.Key — NOT NULL
  • Field (grade) — char(2)
  • Field (year) — datetime2
  • Key (roomid) — char(8) — 외래 키 → Untitled.Key — NOT NULL
  • key (profid) — char(8) — 외래 키 → Professor.id — NOT NULL

Untitled (Classroom)

  • Key (id) — char(8) — 기본 키 — NOT NULL
  • Field (name) — nvarchar(30)

Untitled (Project)

  • Key (id) — char(8) — 기본 키 — NOT NULL
  • Field (name) — nvarchar(30)
  • Field (start) — datetime2
  • Field (end) — datetime2
  • Field (agency) — nvarchar(50)
  • Field

Untitled (Project_Participate)

  • id (profid) — char(8) — 외래 키 → Professor.id — NOT NULL
  • Key (projid) — char(8) — 외래 키 → Untitled.Key — NOT NULL
  • Key (studentid) — char(8) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Address)

  • Key (zip) — char(5) — 기본 키 — NOT NULL
  • Field (City) — nvarchar(30)
  • Field (Do) — nvarchar(30)