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