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 — 현재 신청한 학점