Capstone_ERD

Tables (7)

BASEENTITY (베이스엔티티)

  • createdAt (생성일) — LOCALDATETIME
  • updatedAt (수정일) — LOCALDATETIME
  • isDeleted (삭제여부) — Boolean

EXTRACURRICULAR (비교과 정보)

  • id (비교과 pk) — LONG — Primary key — NOT NULL
  • extra_id (비교과 고유 id) — LONG
  • title (비교과 이름) — VARCHAR(100)
  • url (비교과url) — VARCHAR(100)
  • applicationStart (신청시작일시) — DATETIME
  • applicationEnd (신청종료일시) — DATETIME
  • activityStart (활동시작일시) — DATETIME
  • activityEnd (활동종료일시) — DATETIME

INTEREST (관심정보)

  • id (관심정보 pk) — LONG — Primary key — NOT NULL
  • id (멤버pk) — LONG — Foreign key → MEMBER.id — NOT NULL
  • content (관심정보) — VARCHAR(30)

MEMBER (멤버)

  • id (멤버pk) — LONG — Primary key — NOT NULL
  • name (이름) — VARCHAR(30)
  • email (멤버 이메일) — VARCHAR(30) — 멤버 이메일, konkuk.ac.kr로 끝나여 함
  • password (비밀번호) — VARCHAR(100) — 암호화 해서 저장해야함
  • role (권한) — ENUM — TEMPORARY_MEMBER, MEMBER
  • academicStatus (재학상태) — ENUM — ENROLLED, LEAVE_OF_ABSENCE, GRADUATED
  • Grade (학년) — LONG
  • Collage (단과대학) — VARCHAR(30)
  • Department (학과) — VARCHAR(30)
  • fcmToken (fcm토큰) — VARCHAR(255)

Review (리뷰)

  • id (리뷰pk) — LONG — Primary key — NOT NULL
  • id (멤버pk) — LONG — Foreign key → MEMBER.id — NOT NULL
  • id (비교과 pk) — LONG — Foreign key → EXTRACURRICULAR.id — NOT NULL
  • content (리뷰내용) — VARCHAR(100)
  • star (별점) — LONG

SCHEDULE (일정)

  • id (스케쥴pk) — LONG — Primary key — NOT NULL
  • id (멤버pk) — LONG — Foreign key → MEMBER.id — NOT NULL
  • id (비교과 pk) — LONG — Foreign key → EXTRACURRICULAR.id — NOT NULL
  • start_date (시작일) — DATETIME
  • end_date (종료일) — DATETIME
  • schedule_type (일정구분) — ENUM — EXTRACURRICULAR, NORMAL
  • title (내용) — VARCHAR(50)
  • isAlarm (알림여부) — BOOLEAN

TIMETABLE (시간표)

  • id (시간표pk) — LONG — Primary key — NOT NULL
  • id (멤버pk) — LONG — Foreign key → MEMBER.id — NOT NULL
  • day (요일정보) — ENUM — MON, TUE, WEN, THU, FRI, SAT, SUN
  • startTIME (시작시간) — LOCALTIME
  • endTIME (끝시간) — LOCALTIME
  • eventName (활동명) — VARCHAR(30)
  • eventDetail (활동명상세) — VARCHAR(100)
  • color (색깔) — VARCHAR(50)