challange
Tables (7)
callander_t (달력)
- callander_id (달력id) — Long — Primary key — NOT NULL
- challange_id (챌린지id) — Long — Foreign key → challange_t.challange_id — NOT NULL
- year (년도) — Int
- month (월) — String
- day (일) — String
- day_of_the_week (요일) — Int
- what_week (몇번째주) — Int
- del_yn (삭제유무) — Char
chall_day_t (Untitled4)
- chall_day_id (일간달성id) — Long — Primary key — NOT NULL
- chall_target_t (챌린지목표id) — Long — Foreign key → chall_target_t.chall_target_t — NOT NULL
- user_id (회원id) — Long — Foreign key → chall_target_t.user_id — NOT NULL
- challange_id (챌린지id) — Long — Foreign key → chall_target_t.challange_id — NOT NULL
- start_time (시작시간) — String
- end_time (종료시간) — String
- callander_id (달력id) — Long — Foreign key → callander_t.callander_id — NOT NULL
- del_yn (삭제유무) — Char
- challange_id (챌린지id2) — Long — Foreign key → callander_t.challange_id — NOT NULL
chall_peo_t (Untitled2)
- chall_peo_id (챌린지사람id) — Long — Primary key — NOT NULL
- challange_id (챌린지id) — Long — Foreign key → challange_t.challange_id — NOT NULL
- user_id (회원id2) — Long — Foreign key → user_t.user_id — NOT NULL
- user_id (회원id3) — Long — Foreign key → user_t.user_id — NOT NULL
- user_id (회원id4) — Long — Foreign key → user_t.user_id — NOT NULL
- user_id (회원id5) — Long — Foreign key → user_t.user_id — NOT NULL
- user_id (회원id6) — Long — Foreign key → user_t.user_id — NOT NULL
- user_id (회원id7) — Long — Foreign key → user_t.user_id — NOT NULL
- user_id (회원id8) — Long — Foreign key → user_t.user_id — NOT NULL
- user_id (회원id9) — Long — Foreign key → user_t.user_id — NOT NULL
- user_id (회원id10) — Long — Foreign key → user_t.user_id — NOT NULL
- del_yn (삭제유무) — Char
chall_target_t (Untitled3)
- chall_target_t (챌린지목표id) — Long — Primary key — NOT NULL
- user_id (회원id) — Long — Foreign key → user_t.user_id — NOT NULL
- challange_id (챌린지id) — Long — Foreign key → challange_t.challange_id — NOT NULL
- target_name (목표이름) — String
- color (색상) — String
- target_time (목표시간) — String
- min_time (하루최소시간) — String
- dayoftheweek (요일) — String
- del_yn (삭제유무) — Char
- Field
challange_t (Untitled)
- challange_id (챌린지id) — Long — Primary key — NOT NULL
- chall_name (챌린지이름) — String
- ava_people (정원수) — Int
- now_people (현재인원) — Int
- introduction (챌린지소개) — Text
- start_date (시작날짜) — String
- end_date (종료날짜) — String
- del_yn (삭제유무) — Char
- user_id (회원id) — Long — Foreign key → user_t.user_id — NOT NULL
cheering_t (응원)
- cherring_id (응원id) — Long — Primary key — NOT NULL
- user_id (회원id2) — Long — Foreign key → user_t.user_id — NOT NULL
- chall_day_id (일간달성id) — Long — Foreign key → chall_day_t.chall_day_id — NOT NULL
- chall_target_t (챌린지목표id) — Long — Foreign key → chall_day_t.chall_target_t — NOT NULL
- user_id (회원id) — Long — Foreign key → chall_day_t.user_id — NOT NULL
- challange_id (챌린지id) — Long — Foreign key → chall_day_t.challange_id — NOT NULL
- cherring_text (응원쓰기) — String
- del_yn (삭제유무) — Char
- Field
- challange_id (챌린지id2) — Long — Foreign key → chall_day_t.challange_id — NOT NULL
user_t (회원)
- user_id (회원id) — Long — Primary key — NOT NULL
- nick (닉네임) — String
- user_type (회원구분) — Int
- email (이메일) — String
- password (비밀번호) — String
- del_yn (삭제유무) — Char