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