neordinary_D
Tables (4)
challenge_participants
- part_id (참여 내역 ID) — BIGINT — Primary key — NOT NULL
- challenge_id (챌린지 ID) — BIGINT — Foreign key → challenges.challenge_id — NOT NULL
- user_id (유저 ID) — BIGINT — Foreign key → challenges.user_id — NOT NULL
- joined_at (생성일(참여일)) — TIMESTAMP
challenges
- challenge_id (챌린지 ID) — BIGINT — Primary key — NOT NULL
- user_id (유저 ID) — BIGINT — Foreign key → users.user_id — NOT NULL
- title (제목) — VARCHAR(100) — NOT NULL
- description (설명) — TEXT
- created_at (생성일(시작일)) — TIMESTAMP
- end_at (종료일) — DATETIME
- thumbnail_url (썸네일 이미지) — VARCHAR(500)
snaps
- snap_id (스냅 ID) — BIGINT — Primary key — NOT NULL
- challenge_id (챌린지 ID) — BIGINT — Foreign key → challenges.challenge_id — NOT NULL
- user_id (유저 ID) — BIGINT — Foreign key → challenges.user_id — NOT NULL
- image_url (인증샷) — VARCHAR(500) — NOT NULL
- created_at (생성일) — TIMESTAMP
- creator_id (스냅 생성자 ID) — BIGINT
users
- user_id (유저 ID) — BIGINT — Primary key — NOT NULL
- password (비밀번호) — VARCHAR(255)
- nickname (닉네임) — VARCHAR(50) — NOT NULL
- email (이메일) — VARCHAR(255) — NOT NULL
- created_at (생성일) — TIMESTAMP