2025

Tables (9)

Untitled (학생)

  • Key (Id) — int — Primary key — NOT NULL
  • Field (Name) — nvarchar(30)
  • Field (Phone) — char(11)
  • Field (InputDate) — date
  • Field (DetailAdd) — nvarchar(30)
  • Key (DepartId) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (PostNum) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (학과)

  • Key (Id) — int — Primary key — NOT NULL
  • Field (Name) — nvarchar(30)

Untitled (교수)

  • Key (id) — int — Primary key — NOT NULL
  • Field (Name) — nvarchar(30)
  • Field (Phone) — char(11)
  • Key (DepartId) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (DetailAdd) — nvarchar(30)
  • Key (PostNum) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (과목)

  • Key (Id) — int — Primary key — NOT NULL
  • Field (Name) — nvarchar(30)
  • Field (Score) — tinyint

Untitled (수강)

  • Key (Id) — int — Primary key — NOT NULL
  • Key (Sid) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (SubjId2) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (학점) — char(5)

Untitled (Project)

  • Key (Id) — int — Primary key — NOT NULL
  • Field (Name) — nvarchar(30)
  • Field (Budget) — int
  • Field (_from) — date
  • Field (_to) — date

Untitled (교수참여)

  • Key (ProId) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (ProjectId) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (참여율) — decimal
  • Field (_from) — date
  • Field (_to) — date

Untitled (학생참여)

  • Key (Sid) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (ProjectId) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (참여율) — decimal
  • Field (_from) — date
  • Field (_to) — date

Untitled (주소)

  • Key (PostNum) — int — Primary key — NOT NULL
  • Field (do) — nvarchar(30)
  • Field (si) — nvarchar(30)
  • Field (dong) — nvarchar(30)