Haksa2025

Tables (9)

Untitled (학생)

  • Key (Id) — int — Primary key — NOT NULL
  • Field (_name) — nvarchar(30)
  • Field (phone) — char(11)
  • Field (ghak) — datetime2
  • Field (City) — nvarchar(30)
  • Field (Street) — nvarchar(30)
  • Key (depid) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (상세주소) — nvarchar(30) — Foreign key → Untitled.Key — NOT NULL

Untitled (학과)

  • Key (Id) — int — Primary key — NOT NULL
  • Field (학과명) — nvarchar(30)
  • Key (상세주소) — nvarchar(30) — Foreign key → Untitled.Key — NOT NULL

Untitled (교수)

  • Key (Id) — int — Primary key — NOT NULL
  • Field (이름) — nvarchar(30)
  • Field (Phone) — char(11)
  • Key (proId) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (City) — nvarchar(30)
  • Field (Street) — nvarchar(30)
  • Key (상세주소) — nvarchar(30) — Foreign key → Untitled.Key — NOT NULL

Untitled (과목)

  • Key (Id) — int — Primary key — NOT NULL
  • Field (과목명) — nvarchar(30)
  • Field (학점) — tinyint

Untitled (수강)

  • Key (Id) — int — Primary key — NOT NULL
  • Key (sId) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (cId) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (학점) — char(2)
  • Field (수강연도) — datetime2
  • Key (pid) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (Project)

  • Key (Id) — int — Primary key — NOT NULL
  • Field (프로젝트명) — nvarchar(30)
  • Field (예산) — int
  • Field (From) — datetime2
  • Field (to) — datetime2

Untitled (교수참여)

  • Key (proId) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (projId) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (참여율) — decimal
  • Field (_from) — datetime2
  • Field (_to) — datetime2

Untitled (학생참여)

  • Key (projId) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (sId) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (참여율) — decimal
  • Field (_from) — datetime2
  • Field (_to) — datetime2

Untitled (주소)

  • Key (우편번호) — int — Primary key — NOT NULL
  • Field (시) — nvarchar(30)
  • Field (구) — nvarchar(30)
  • Field (번길) — nvarchar(30)