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