학부2024_학사ERD

테이블 (7)

LAB

  • Key — char(2) — 기본 키 — NOT NULL
  • Field (_name) — char(30)
  • Field (room) — char(5)
  • Key (pid) — char(2) — 외래 키 → Untitled.Key — NOT NULL

Student

  • id — char(2) — 기본 키 — NOT NULL
  • _name — char(30)
  • iphak — datetime2
  • Field3 (phone) — char(11)
  • Field (email) — char(30)
  • Key (labid) — char(2) — 외래 키 → LAB.Key — NOT NULL

Untitled (Prof)

  • Key (id) — char(2) — 기본 키 — NOT NULL
  • Field (_name) — char(30)

Untitled (Sugang)

  • id — char(2) — 외래 키 → Student.id — NOT NULL
  • Key (cid) — char(2) — 외래 키 → Untitled2.Key — NOT NULL
  • Key (pid) — char(2) — 외래 키 → Untitled.Key — NOT NULL
  • Field (score) — char(2)
  • Field (openyear) — datetime2

Untitled (project)

  • Key (id) — char(2) — 기본 키 — NOT NULL
  • Field (_name) — char(30)
  • Field2 (from) — datetime2
  • Field (to) — datetime2
  • Field (price) — int

Untitled (Project_Suhang)

  • Key (pid) — char(2) — 외래 키 → Untitled.Key — NOT NULL
  • Key (projid) — char(2) — 외래 키 → Untitled.Key — NOT NULL
  • id (sid) — char(2) — 외래 키 → Student.id — NOT NULL
  • Field (s.참여율) — decimal
  • Field (p.참여율) — decimal
  • Field (From) — datetime2
  • Field (To) — datetime2

Untitled2 (Course)

  • Key (id) — char(2) — 기본 키 — NOT NULL
  • Field (_name) — char(30)
  • Field (credit) — int