2023_2학기_학사DB

테이블 (8)

Untitled (Student)

  • Key (id) — char(8) — 기본 키 — NOT NULL
  • Field (name) — nvarchar(30)
  • Field (phone) — char(11)
  • Key (deptid) — char(8) — 외래 키 → Untitled.Key — NOT NULL
  • Field (labid) — char(8)
  • Field (jidopof) — char(8)
  • Key (zip) — char(5) — 외래 키 → Untitled.Key — NOT NULL
  • Field (Bunzi) — nvarchar(10)
  • Field (juminno) — char(13)
  • Field
  • Key (id2) — char(8) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Department)

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

Untitled (Course)

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

Untitled (Sugang)

  • Key (studentid) — char(8) — 외래 키 → Untitled.Key — NOT NULL
  • Key (Courseid) — char(8) — 외래 키 → Untitled.Key — NOT NULL
  • Field (grade) — char(2)
  • Field (year) — datetime(2)
  • Key (roomid) — char(8) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Room)

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

Untitled (Lab)

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

Untitled (Address)

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

Untitled (Professor)

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