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)