umc chapter 5
Tables (9)
follows
- follower_user_id — INT — NOT NULL
- followed_user_id — INT — NOT NULL
- created_at — TIMESTAMP
missions
- mission_id — INT — NOT NULL
- store_id — INT — NOT NULL
- mission_content — VARCHAR(255)
- points_awarded — INT
- created_at — TIMESTAMP
posts
- post_id — INT — NOT NULL
- user_id — INT — NOT NULL
- title — VARCHAR(255)
- content — TEXT
- status — VARCHAR(50)
- created_at — TIMESTAMP
regions
- region_id — INT — NOT NULL
- region_name — VARCHAR(255) — NOT NULL
reviews
- review_id — INT — NOT NULL
- user_id — INT — NOT NULL
- store_id — INT — NOT NULL
- rating — INT
- content — TEXT
- created_at — TIMESTAMP
stores
- store_id — INT — NOT NULL
- region_id — INT — NOT NULL
- store_name — VARCHAR(255) — NOT NULL
- manager_number — VARCHAR(255)
- address — VARCHAR(255)
- created_at — TIMESTAMP
user_mission_completions
- completion_id — INT — NOT NULL
- user_id — INT — NOT NULL
- mission_id — INT — NOT NULL
- completed_at — TIMESTAMP
user_region_bonus
- bonus_id — INT — NOT NULL
- region_id — INT — NOT NULL
- awarded_at — TIMESTAMP
users
- user_id — INT — NOT NULL
- username — VARCHAR(255) — NOT NULL
- role — VARCHAR(255)
- created_at — TIMESTAMP