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)