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