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