호ㅓㅠ

테이블 (5)

CommunityPost

  • post_id — BIGINT
  • lost_id — BIGINT
  • author_id — BIGINT
  • title — VARCHAR(100)
  • content — TEXT
  • created_at — DATETIME

FoundItem

  • found_id — BIGINT
  • user_id — BIGINT
  • description — TEXT
  • image_url — VARCHAR(255)
  • found_time — DATETIME
  • found_location — VARCHAR(255)
  • storage_place — VARCHAR(255)

LostItem

  • lost_id — BIGINT
  • user_id — BIGINT
  • description — TEXT
  • image_url — VARCHAR(255)
  • lost_time — DATETIME
  • lost_location — VARCHAR(255)
  • storage_place — VARCHAR(255)

Reward

  • reward_id — BIGINT
  • lost_id — BIGINT
  • amount — INT
  • status — VARCHAR(50)

User

  • user_id — BIGINT
  • nickname — VARCHAR(100)
  • email — VARCHAR(100)
  • avatar — VARCHAR(100)
  • role — VARCHAR(50)