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