umc
Tables (6)
Missions
- missionID — INT — Primary key
- missionTitle — VARCHAR(255) — NOT NULL
- missionDescription — TEXT
- missionPoints — INT
- storeID — INT — Foreign key → Stores.storeID
Regions
- regionID — INT — Primary key
- regionName — VARCHAR(255) — NOT NULL
Reviews
- reviewID — SERIAL — Primary key
- rating — INT
- reviewText — TEXT
- reviewDate — TIMESTAMP
- userID — INT — Foreign key → Users.userID
Stores
- storeID — INT — Primary key
- storeName — VARCHAR(255) — NOT NULL
- address — VARCHAR(255)
- description — TEXT
- regionID — INT — Foreign key → Regions.regionID
UserMissions
- userMissionID — INT — Primary key
- completionDate — DATE
- status — VARCHAR(50)
- userID — INT — Foreign key → Users.userID
- missionID — INT — Foreign key → Missions.missionID
Users
- userID — INT — Primary key
- email — VARCHAR(255) — NOT NULL
- username — VARCHAR(255) — NOT NULL
- gender — VARCHAR(1) — NOT NULL
- birth — datetime
- address — varchar(255)
- prefer_food — varchar(2)
- point — varchar(10)