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