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