becok
Tables (13)
Best_Program (비교과로드맵우수작)
- id (고유ID) — Primary key — NOT NULL
- Core_1 (핵심역량1)
- Core_2 (핵심역량2)
- Core_3 (핵심역량3)
- Field4 (대학생활적응)
- Field5 (역량개발)
- Field6 (도전과정성취)
Contest (공모전)
- id (고유ID) — Primary key — NOT NULL
- Name (공모전 이름)
- StartDate (접수시작날짜)
- EndDate (마감날짜)
- Category (분야)
- Organizer (주최기관)
- thumnailUrl (이미지url)
- LinkUrl (신청페이지url)
- Hits (조회수)
- Dday (디데이)
ContestBookmark (공모전 북마크)
- id (고유ID) — Primary key — NOT NULL
- Contest_id (공모전ID) — Long — Foreign key → Contest.id — NOT NULL
- Member_id (멤버고유 ID) — Long — Foreign key → Member.Member_id — NOT NULL
ContestNotification (공모전 알림)
- id (고유ID) — Primary key — NOT NULL
- Member_id (멤버고유 ID) — Foreign key → Member.Member_id — NOT NULL
- Program_id (비교과ID) — Foreign key → Program.id — NOT NULL
Joined_Pro (비교과_참여내역)
- id (고유ID) — Primary key — NOT NULL
- Title (프로그램 이름)
- Date (날짜)
- Member_id (멤버고유 ID) — Foreign key → Member.Member_id — NOT NULL
- Program_id (비교과프로그램 고유ID) — Foreign key → Program.id — NOT NULL
Member (사용자)
- Member_id (멤버고유 ID) — Primary key — NOT NULL
- email (이메일아이디) — NOT NULL
- password (비밀번호) — NOT NULL
- grade (학년) — NOT NULL
- semester (학기) — NOT NULL
- point (비교과포인트)
- Program (진행한 비교과프로그램)
- Remember (관심비교과프로그램)
- recommendType (추천 방향 설정)
- goal (목표)
Member_interest (멤버- 관심분야)
- id (고유ID) — Primary key — NOT NULL
- Member_id (멤버고유 ID) — Foreign key → Member.Member_id — NOT NULL
- interest_id (관심분야고유ID) — Foreign key → interest.interest_id — NOT NULL
Program (비교과)
- id (고유ID) — Primary key — NOT NULL
- Name (프로그램 이름)
- StartDate (모집시작날짜)
- EndDate (모집마감날짜)
- Creativity (창의력)
- Integration (융합능력)
- Management (자기관리능력)
- Interpersonal (대인관계능력)
- GlobalCommunication (글로벌소통능력)
- GlobalCitizenship (글로벌시민의식)
- Target (모집대상)
- Grade (학년)
- Semester (학기)
- Status (상태) — ENUM
- imgUrl (이미지url)
- linkUrl (신청페이지url)
- Point (포인트)
- Category (분야)
- Hit (조회수)
ProgramBookmark (비교과 북마크)
- id (고유ID) — Primary key — NOT NULL
- Member_id (멤버고유 ID) — Long — Foreign key → Member.Member_id — NOT NULL
- Program_id (비교과고유ID) — Long — Foreign key → Program.id — NOT NULL
ProgramNotification (비교과 알림)
- id (고유ID) — Primary key — NOT NULL
- Member_id (멤버고유 ID) — Long — Foreign key → Member.Member_id — NOT NULL
- Program_id (비교과ID) — Long — Foreign key → Program.id — NOT NULL
Recommended_Con (공모전_추천)
- id (고유ID) — Primary key — NOT NULL
- Name (공모전 이름)
- EndDate (마감 날짜)
- Category (분야)
- Organizer (주최기관)
- imgUrl (이미지url)
- LinkUrl (신청페이지url)
- Member_id (멤버고유 ID) — Foreign key → Member.Member_id — NOT NULL
- Contest_id (공모전고유ID) — Foreign key → Contest.id — NOT NULL
Recommended_Pro (비교과_추천)
- id (고유ID) — Primary key — NOT NULL
- Name (프로그램 이름)
- StartDate (모집시작날짜)
- EndDate (모집마감날짜)
- Category (분야)
- Target (모집대상)
- imgUrl (이미지url)
- LinkUrl (신청페이지url)
- Grade (대상학년)
- Semester (학기)
- Status (상태)
- Member_id (멤버고유 ID) — Foreign key → Member.Member_id — NOT NULL
- Program_id (비교과프로그램 고유ID) — Foreign key → Program.id — NOT NULL
interest (관심분야)
- interest_id (고유ID) — Primary key — NOT NULL
- interest_type (관심분야(마케팅, 창업 등))