test

Tables (14)

Badge

  • id — INT — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • description — varchar(255)
  • required_date — SMALLINT — NOT NULL — 획득 필요 일수
  • image_url — varchar(255) — NOT NULL
  • required_money — INT — NOT NULL

Challenge

  • id — INT — Primary key — NOT NULL
  • creator_id — INT — Foreign key → User.id — NOT NULL
  • category — SMALLINT — NOT NULL — 카페/디저트, 외식, 장보기, 쇼핑, 문화생활, 취미/여가, 술/담배, 교통, 기타 중 하나 선택
  • title — varchar(60) — NOT NULL — 20자 제한
  • description — TINYTEXT — 최대 85자
  • start_date — DATE — NOT NULL — 현재 날짜 불가
  • duration — SMALLINT — NOT NULL — 7, 14, 21, 28일 중 선택
  • end_date — DATE — NOT NULL — 자동 계산: start_date + duration
  • visibility — BOOLEAN — NOT NULL — false=공개, true=비공개
  • max_participants — SMALLINT — NOT NULL — 최대인원: 1-100명
  • budget — INT — NOT NULL
  • created_at — DATE — NOT NULL
  • status — SMALLINT — NOT NULL — 0=모집중, 1=진행중, 2=종료
  • progress_rate — float — NOT NULL

ChallengeInvite

  • id — INT — Primary key — NOT NULL
  • challenge_id — INT — Foreign key → Challenge.id — NOT NULL
  • from_user_id — INT — Foreign key → User.id — NOT NULL
  • to_user_id — INT — Foreign key → User.id — NOT NULL

ChallengeLike

  • challenge_id — INT — Foreign key → Challenge.id — NOT NULL
  • user_id — INT — Foreign key → User.id — NOT NULL
  • is_encouraged — BOOLEAN
  • is_wanted — BOOLEAN

ChallengeParticipant

  • challenge_id — INT — Foreign key → Challenge.id — NOT NULL
  • user_id — INT — Foreign key → User.id — NOT NULL
  • ocr_count — SMALLINT
  • initial_budget — INT — NOT NULL
  • balance — INT — NOT NULL
  • is_failed — BOOLEAN — false=성공, true=실패

Comment

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → User.id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME
  • deleted_at — DATETIME
  • is_active — BOOLEAN — 활성화 여부: false=비활성화, true=활성화

Expense

  • id — INT — Primary key — NOT NULL
  • challenge_id — INT — Foreign key → ChallengeParticipant.challenge_id — NOT NULL
  • user_id — INT — Foreign key → ChallengeParticipant.user_id — NOT NULL
  • store — VARCHAR(255) — NOT NULL
  • amount — INT — NOT NULL
  • payment_date — DATETIME — NOT NULL
  • is_handwritten — BOOLEAN — NOT NULL — false=OCR, true=수기

Follow

  • follower — INT — Foreign key → User.id — NOT NULL
  • following — INT — Foreign key → User.id — NOT NULL

Notification

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → User.id — NOT NULL
  • type — TINYINT — NOT NULL — 1=챌린지초대, 2=챌린지마감, 3=인증재촉, 4=팔로우
  • reference_id — INT — NOT NULL — 관련 챌린지/사용자 ID
  • content — TEXT — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • created_at — DATE — NOT NULL

Post

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → User.id — NOT NULL
  • challenge_id — INT — Foreign key → Challenge.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT
  • image_url — TEXT
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME
  • deleted_at — DATETIME
  • is_active — BOOLEAN — 활성화 여부: false=비활성화, true=활성화

PostLike

  • challenge_id — INT — Primary key — NOT NULL
  • post_id — INT — Foreign key → Post.id — NOT NULL
  • user_id — INT — Foreign key → User.id — NOT NULL
  • is_liked — BOOLEAN

User

  • id — INT — Primary key — NOT NULL
  • user_id — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • nickname — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • username — varchar(100) — NOT NULL
  • sex — CHAR(1) — NOT NULL — M or F
  • birth_date — DATE — NOT NULL
  • career — SMALLINT — NOT NULL
  • total_saving — INT
  • introduction — TEXT
  • profile_image — VARCHAR(255) — NOT NULL — 사진url 형식: 회원아이디_profile_image.jpg
  • created_at — DATE — NOT NULL
  • kakao_login — varchar(255)
  • challenge_streak — SMALLINT — NOT NULL — 연속 참여 챌린지 수

UserBadge

  • user_id — INT — Foreign key → User.id — NOT NULL
  • badge_id — INT — Foreign key → Badge.id — NOT NULL
  • is_achieved — BOOLEAN — NOT NULL
  • achieved_at — DATE — NOT NULL

UserChallengeCategory

  • user_id — INT — Foreign key → User.id — NOT NULL
  • cafe — BOOLEAN
  • restaurant — BOOLEAN
  • grocery — BOOLEAN
  • shopping — BOOLEAN
  • culture — BOOLEAN
  • hobby — BOOLEAN
  • drink — BOOLEAN
  • transportation — BOOLEAN
  • etc — BOOLEAN