2024신한해커톤
테이블 (11)
Cleanup (쓰레기)
- cleanup_id (PK) — NOT NULL — 기본 키 — NOT NULL
- cleanup_name (Field) — NOT NULL
- created_at (Field2) — NOT NULL
- island_id (PK2) — NOT NULL — 외래 키 → Island.island_id — NOT NULL
Contribution (기여도)
- contribution_id (PK) — NOT NULL — 기본 키 — NOT NULL
- user_id (FK) — NOT NULL — 외래 키 → User.user_id — NOT NULL
- type (Field2) — NOT NULL
- value (Field) — NOT NULL
- points (Field3) — NOT NULL
- created_at (Field4) — NOT NULL
Donation (기부)
- donation_id (PK) — NOT NULL — 기본 키 — NOT NULL
- amount (Field) — NOT NULL
- created_at (Field2) — NOT NULL
- user_id (FK) — NOT NULL — 외래 키 → User.user_id — NOT NULL
Endangered_Animal (멸종위기동물)
- animal_id (PK) — NOT NULL — 기본 키 — NOT NULL
- animal_name (VARCHAR) — NOT NULL
- appearance_level (Field) — NOT NULL
- created_at (Field2) — NOT NULL
Island (섬)
- island_id (PK) — NOT NULL — 기본 키 — NOT NULL
- name (Field) — NOT NULL
- description (Field2)
- price (Field3) — NOT NULL
Point (포인트)
- point_id (PK) — NOT NULL — 기본 키 — NOT NULL
- total_points (Field) — NOT NULL
- available_points (Field2) — NOT NULL
- created_at (Field3) — NOT NULL
- updated_at (Field4) — NOT NULL
- user_id (FK) — NOT NULL — 외래 키 → User.user_id — NOT NULL
Transaction (포인트 거래)
- transaction_id (PK) — NOT NULL — 기본 키 — NOT NULL
- type (Field) — NOT NULL
- amount (Field2) — NOT NULL
- created_at (Field3) — NOT NULL
- user_id (FK) — NOT NULL — 외래 키 → User.user_id — NOT NULL
Tree (나무)
- tree_id (PK) — NOT NULL — 기본 키 — NOT NULL
- tree_name (Field) — NOT NULL
- created_at (Field2) — NOT NULL
- island_id (PK2) — NOT NULL — 외래 키 → Island.island_id — NOT NULL
User (유저)
- user_id (유저ID) — NOT NULL — 기본 키 — NOT NULL
- username (Field) — NOT NULL
- password (Field2) — NOT NULL
- email (Field3) — NOT NULL
- created_at (Field4) — NOT NULL
- updated_at (Field5) — NOT NULL
User_Animal (유저_멸종위기동물)
- user_id (유저ID) — NOT NULL — 외래 키 → User.user_id — NOT NULL
- animal_id (PK) — NOT NULL — 외래 키 → Endangered_Animal.animal_id — NOT NULL
User_Island (유저-섬-N:M)
- user_island_id (PK) — NOT NULL — 기본 키 — NOT NULL
- user_id (유저ID) — NOT NULL — 외래 키 → User.user_id — NOT NULL
- island_id (PK2) — NOT NULL — 외래 키 → Island.island_id — NOT NULL