MyHaksa
Tables (9)
Untitled (학생)
- Key (학번) — char(8) — Primary key — NOT NULL
- Field (이름) — nvarchar(20)
- Field (전화) — char(11)
- Field2 (주민번호) — char(13)
- Key (우편번호) — char(5) — Foreign key → Untitled.Key — NOT NULL
- Key (소속실험실명) — nvarchar(30) — Foreign key → Untitled.Key — NOT NULL
Untitled (교과목)
- Key (학수번호) — char(8) — Primary key — NOT NULL
- Field (과목명) — nvarchar(30)
- Field (학점) — tinyint
- Field (이수구분) — nvarchar(50)
Untitled (교수)
- Key (직번) — char(5) — Primary key — NOT NULL
- Field (이름) — nvarchar(30)
- Field (전화) — char(11)
- Key (우편번호) — char(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (수강정보)
- Key (학번) — char(8) — Foreign key → Untitled.Key — NOT NULL
- Key (학수번호) — char(8) — Foreign key → Untitled.Key — NOT NULL
- Field (성적) — char(2)
- Field (수강년도) — smallint
- Field (학기) — tinyint
- Key (직번) — char(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (주소)
- Key (우편번호) — char(5) — Primary key — NOT NULL
- Field (광역)
- Field (시군)
- Field (읍면동)
- Field (번지)
Untitled (수행과제)
- Key (과제코드) — char(8) — Primary key — NOT NULL
- Field (과제명) — nvarchar(100)
- Field (금액) — int
- Field (시작일자) — date
- Field (종료일자) — date
- Key (학번) — char(8) — Foreign key → Untitled.Key — NOT NULL
- Key (직번) — char(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (실험실)
- Key (실험실명) — nvarchar(30) — Primary key — NOT NULL
- Key (지도교수직번) — char(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (관심분야)
- Key (관심분야명) — nvarchar(30) — Primary key — NOT NULL
Untitled (관심_실험실)
- Key (관심분야명) — nvarchar(30) — Foreign key → Untitled.Key — NOT NULL
- Key (실험실명) — nvarchar(30) — Foreign key → Untitled.Key — NOT NULL