lotto

Tables (4)

Item

  • id (Key) — bigint — Primary key — NOT NULL
  • title (이름) — varchar
  • category (카테고리) — int
  • image_url (사진) — varchar
  • description (설명) — varchar

Like

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → User.id — NOT NULL
  • item_id — bigint — Foreign key → Item.id — NOT NULL

User

  • id — bigint — Primary key — NOT NULL
  • user_id (식별 id) — char
  • email — varchar
  • name (이름) — varchar
  • nick_name (닉네임) — varchar
  • password (비밀번호) — varchar

raffle (Raffle)

  • id — bigint — Primary key — NOT NULL
  • item (아이템) — bigint — Foreign key → Item.id — NOT NULL
  • winner (user) — bigint — Foreign key → User.id — NOT NULL
  • total_count (총 카운트) — int
  • current_count (현재 카운트) — int
  • status (상태) — enum
  • created_at (생성일) — date
  • finished_at (완료일) — date