java2ndfinal
Tables (3)
Untitled (Course)
- Key — bigint — Primary key — NOT NULL
- Key (member_id) — bigint — Foreign key → Untitled.Key — NOT NULL — 교수 ID
- Field (cout) — integer — NOT NULL — 등록한 인원수
- Field (occupancy) — integer — NOT NULL — 정원
- Field (weekday) — varchar — 월~금
- Field2 (start_at) — time — 강의 시작시간
- Field (end_at) — time — 강의 종료시간
- Field (credit) — integer — NOT NULL — 학점
Untitled (Register)
- Key (id) — bigint — Primary key — NOT NULL
- Key (member_id) — bigint — Foreign key → Untitled.Key — NOT NULL — 학생ID
- Key (course_id) — bigint — Foreign key → Untitled.Key — NOT NULL — 강의ID
- Field (status) — varchar — 수강 상태(장바구니, 완료, 찜)
Untitled (Member)
- Key (id) — bigint — Primary key — NOT NULL
- Field (email) — varchar — 이메일
- Field (password) — varchar — 패스워드
- Field (name) — varchar — 이름
- Field (type) — varchar — 학생/교수 구분
- Field (personal_number) — varchar — NOT NULL — 학번/사번
- Field (current_credit) — int — 현재 신청한 학점