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 (관심분야(마케팅, 창업 등))