호ㅓㅠ
테이블 (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)