Becok
Tables (9)
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 (이름)
- EndDate (마감날짜)
- Category (분야)
- Organizer (주최기관)
- thumbnailUrl (썸네일이미지url)
- LinkUrl (신청페이지url)
Interest (관심분야)
- Interest_Id (고유ID) — Primary key — NOT NULL
- intrest_type (관심 분야(마케팅, 창업 등))
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 (멤버이메일아이디)
- Passwrod (비밀번호)
- Grade (학년)
- Semester (학기)
- 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 (상태(모집,마감,예정))
- thumbnailUrl (썸네일이미지url)
- LinkUrl (신청페이지url)
- Point (포인트)
- Category (분야)
Recommended_Con (공모전_추천)
- Id (고유ID) — Primary key — NOT NULL
- Name (이름)
- EndDate (마감날짜)
- Category (분야)
- Organizer (주최기관)
- thumbnailUrl (썸네일이미지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 (모집대상)
- thumbnailUrl (썸네일이미지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