Haksa2025
Tables (9)
Untitled (학생)
- Key (id) — int — Primary key — NOT NULL
- Key (departid) — int — Foreign key → Untitled.Key — NOT NULL
- Field (_name) — nvarchar(30)
- Field (phone) — char(11)
- Field (entered) — datetime2
- Field (City) — nvarchar(30)
- Field — nvarchar(30)
Untitled (학과)
- Key (id) — int — Primary key — NOT NULL
- Field (학과명) — nvarchar(30)
Untitled (교수)
- Key (id) — int — Primary key — NOT NULL
- Field (name) — nvarchar(30)
- Field (phone) — char(11)
- Key (id2) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (과목)
- Key (id) — int — Primary key — NOT NULL
- Field (lecture) — nvarchar(30)
- Field (score) — tinyint
Untitled (수강)
- Key — int — Primary key — NOT NULL
- Key (sid) — int — Foreign key → Untitled.Key — NOT NULL
- Key (cid) — int — Foreign key → Untitled.Key — NOT NULL
- Key (pid) — int — Foreign key → Untitled.Key — NOT NULL
- Field (학점) — char(2)
- Field2 (수강년도) — datetime2
Untitled (프로젝트)
- Key (id) — int — Primary key — NOT NULL
- Field (프로젝트명) — nvarchar(30)
- Field (예산) — int
- Field (_From) — datetime2
- Field (_To) — dateTime2
Untitled (교수참여)
- Key (profid) — int — Foreign key → Untitled.Key — NOT NULL
- Key (proid) — int — Foreign key → Untitled.Key — NOT NULL
- Field (참여율) — decimal
- Field (참여기간) — datetime2
- Field (_from)
Untitled (학생참여)
- Key (proid) — int — Foreign key → Untitled.Key — NOT NULL
- Key (sid) — int — Foreign key → Untitled.Key — NOT NULL
- Field (참여율) — decimal
- Field (_From) — datetime2
- Field2 (_To) — datetime2
Untitled (주소)
- Key (우편번호) — int — Primary key — NOT NULL
- Field (시) — nvarchar(30)
- Field (구) — nvarchar(30)
- Field (번길) — nvarchar(30)