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)