umc

Tables (8)

Food (StoreInfo)

  • foodId — INT — Primary key
  • Description — TEXT
  • foodName (foodname) — VARCHAR(20)

Mission

  • missionID (MissionID) — INT — Primary key
  • Title — VARCHAR(100)
  • Description — TEXT
  • storeId (StoreId) — INT — Foreign key → StoreList.storeId
  • pointId (PointID) — INT — Foreign key → Point.pointId

Notification

  • notificationId (NotificationID) — INT — Primary key
  • message (Message) — TEXT

Point

  • pointId (PointID) — INT — Primary key
  • point (포인트) — INT
  • adjf; (Field)

StoreList (Store)

  • storeId (StoreId) — INT — Primary key
  • name (Name) — VARCHAR(100)
  • address (Address) — VARCHAR(200)
  • category (Category) — VARCHAR(50)
  • foodId — INT — Foreign key → Food.foodId

User

  • userId (Key) — Primary key — NOT NULL
  • userId (UserID) — INT
  • email (Email) — VARCHAR(50)
  • password (Password) — VARCHAR(50)
  • name — VARCHAR(50)
  • pointId (PointID) — INT — Foreign key → Point.pointId
  • inactive (date)
  • favoritfood (Field)

UserMission M:N Table (UserMission)

  • usermissionId (UserMissionID) — INT — Primary key
  • userId (UserID) — INT
  • missionId (MissionID) — INT
  • status (Status) — VARCHAR(20)
  • completedate — DATE
  • userId (Key) — Foreign key → User.userId — NOT NULL
  • missionId (MissionID2) — INT — Foreign key → Mission.missionID

date (Untitled)

  • dateId (Key) — Primary key — NOT NULL
  • createId (datetime) — datetime
  • updateId (Field2) — datetime
  • createUserId (Field3) — datetime
  • updateUserId (Field4) — datetime