24-2
Tables (8)
Untitled (학생)
- Key (학번) — Primary key — NOT NULL
- Key (주민번호) — Primary key — NOT NULL
- Field (전공)
- Field (부전공)
- Field (성별)
- Field (학년)
- Key (주소) — Foreign key → Untitled.Key — NOT NULL
- Key (이름) — Foreign key → Untitled.Key — NOT NULL
Untitled (학과)
- Key (학과명) — Primary key — NOT NULL
- Key (코드) — Primary key — NOT NULL
- Field (사무실번호)
- Field2 (전화번호)
- Field (소속단과대학)
Untitled (교수)
- Key (교번) — Primary key — NOT NULL
- Field (이름)
- Field (최종학위)
- Field2 (연구분야)
Untitled (분반)
- Key (분반번호) — Primary key — NOT NULL
- Field (개설연도)
- Field (개설학기)
- Key (과목번호) — Foreign key → Untitled2.Key — NOT NULL
- Key (교번) — Foreign key → Untitled.Key — NOT NULL
Untitled (수강)
- Key (학번) — Foreign key → Untitled.Key — NOT NULL
- Key (주민번호) — Foreign key → Untitled.Key — NOT NULL
- Key (분반번호) — Foreign key → Untitled.Key — NOT NULL
- Field (평점)
Untitled (주소)
- Key (주소) — Primary key — NOT NULL
- Field (CITY)
- Field (STATE)
- Field2 (ZIP)
Untitled (이름)
- Key (이름) — Primary key — NOT NULL
- Field (FISRT NAME)
- Field2 (LAST NAME)
Untitled2 (과목)
- Key (과목번호) — Primary key — NOT NULL
- Key (학과명) — Foreign key → Untitled.Key — NOT NULL
- Key (코드) — Foreign key → Untitled.Key — NOT NULL
- Field (과목명)
- Field2 (과목소개)
- Field (학점)
- Field (대상학년)