challenge

Tables (3)

Ch_Attend (챌린지 참가)

  • idx (Ch_Attend_idx) — NOT NULL — Primary key — NOT NULL
  • time (참여시간) — NOT NULL
  • id (로그인아이디) — NOT NULL — Foreign key → User.idx — NOT NULL
  • title (챌린지제목) — NOT NULL — Foreign key → Ch_Info.idx — NOT NULL
  • preInput (사전입력) — NULL — Foreign key → Ch_Info.idx — NOT NULL
  • realInput (실제입력) — NULL — Foreign key → Ch_Info.idx — NOT NULL

Ch_Info (챌린지 정보)

  • idx (Ch_Info_idx) — NOT NULL — Primary key — NOT NULL
  • maker_id (만든사람) — NOT NULL — Foreign key → User.idx — NOT NULL
  • title (챌린지제목) — NOT NULL
  • intro (챌린지소개) — NOT NULL
  • condition (챌린지조건) — NOT NULL — NOT NULL
  • sTime (시작날짜) — NOT NULL — NOT NULL
  • eTime (종료날짜) — NOT NULL — NOT NULL
  • preInput1 (사전입력) — NULL
  • realInput1 (실제입력) — NULL
  • range (참여가능범위) — NOT NULL

User (회원)

  • idx (user_idx) — NOT NULL — Primary key — NOT NULL
  • id (로그인아이디) — NOT NULL
  • password (비밀번호) — NOT NULL
  • name (이름) — NOT NULL
  • school (학교) — NOT NULL
  • grade (학년) — NOT NULL
  • class (반) — NOT NULL
  • class_num (번호) — NOT NULL
  • gender (성별) — NOT NULL
  • role (역할) — NOT NULL
  • point (점수) — 0
  • email (이메일) — NULL
  • phone (전화번호) — NULL