2023_2학기_학사DB

테이블 (5)

Untitled (Student)

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

Untitled (Deptment)

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

Untitled (Course)

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

Untitled (Room)

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

Untitled (Sugang)

  • Key (studentid) — char(8) — 기본 키 — NOT NULL
  • Field (courseid) — char(8)