N-days-challenge

Tables (9)

dajim (다짐)

  • dajim_number (다짐 고유번호) — BIGINT — Primary key — NOT NULL
  • member_number (멤버 고유번호) — BIGINT — Foreign key → member.member_number — NOT NULL
  • room_number (름 고유번호) — BIGINT — Foreign key → room.room_number — NOT NULL
  • content (다짐 내용) — VARCHAR
  • open (공개 여부) — VARCHAR
  • created_date (생성 날짜) — DATETIME
  • updated_date (변경 날짜) — DATETIME

emotion (이모션)

  • emotion_number (이모션 고유번호) — BIGINT — Primary key — NOT NULL
  • dajim_number (다짐 고유번호) — BIGINT — Foreign key → dajim.dajim_number — NOT NULL
  • member_number (멤버 고유번호) — BIGINT — Foreign key → member.member_number — NOT NULL
  • sticker (감정 스티커) — VARCHAR
  • created_date (생성 날짜) — DATETIME
  • updated_date (변경 날짜) — DATETIME

member (회원)

  • member_number (멤버 고유번호) — BIGINT — Primary key — NOT NULL
  • authority (권한) — VARCHAR — NOT NULL
  • nickname (닉네임) — VARCHAR
  • id (아이디) — VARCHAR
  • pw (비밀번호) — VARCHAR
  • image (프로필사진) — INT

refresh_token (리프레쉬 토큰)

  • rt_key (토큰 키) — VARCHAR — Primary key — NOT NULL
  • rt_value (토큰 값) — VARCHAR
  • created_date (생성일자) — DATETIME

relationship (친구관계)

  • relationship_number (친구관계 고유번호) — BIGINT — Primary key — NOT NULL
  • user_member_number (사용자 고유번호) — BIGINT — Foreign key → member.member_number — NOT NULL
  • friend_member_number (친구 고유번호) — BIGINT — Foreign key → member.member_number — NOT NULL
  • requested_date (요청 날짜) — DATETIME
  • accepted_date (수락 날짜) — DATETIME
  • status (관계 상태) — VARCHAR

report (신고)

  • report_number (신고 고유번호) — BIGINT — Primary key — NOT NULL
  • dajim_number (다짐 고유번호) — BIGINT — Foreign key → dajim.dajim_number — NOT NULL
  • cause (신고 사유) — INT
  • is_dajim (다짐 상태) — BIT(1)
  • content (다짐 내용) — VARCHAR

room (챌린지룸)

  • room_number (룸 고유번호) — BIGINT — Primary key — NOT NULL
  • member_number (멤버 고유번호) — BIGINT — Foreign key → member.member_number — NOT NULL
  • stamp_number (스탬프 고유번호) — BIGINT — Foreign key → stamp.stamp_number — NOT NULL
  • dtype (룸 타입) — VARCHAR
  • category (챌린지 종류) — VARCHAR
  • room_name (룸 이름) — VARCHAR
  • pass_count (패스 횟수) — INT
  • reward (보상) — VARCHAR
  • start_date (시작 날짜) — DATE
  • end_date (완료 날짜) — DATE
  • status (챌린지 상태) — VARCHAR

room_member (챌린지룸 회원)

  • room_member_number (룸멤버 고유번호) — BIGINT — Primary key — NOT NULL
  • member_number (멤버 고유번호) — BIGINT — Foreign key → member.member_number — NOT NULL
  • room_number (룸 고유번호) — BIGINT — Foreign key → room.room_number — NOT NULL
  • stamp_number (스탬프 고유번호) — BIGINT — Foreign key → stamp.stamp_number — NOT NULL

stamp (스탬프)

  • stamp_number (스탬프 고유번호) — BIGINT — Primary key — NOT NULL
  • member_number (멤버 고유번호) — BIGINT — Foreign key → member.member_number — NOT NULL
  • room_number (룸 고유번호) — BIGINT
  • latest_date (최근 업데이트 날짜) — DATETIME
  • success_count (출석 성공 횟수) — INT
  • used_pass_count (패스 사용 횟수) — INT
  • day (출석 날짜) — VARCHAR