UMC_Spring_4th
Tables (8)
Mission (Untitled2)
- missionId (ID) — bigint — Primary key — NOT NULL
- storeId (ID2) — bigint — Foreign key → store.storeId — NOT NULL
- userID (Key) — bigint — Foreign key → store.userID — NOT NULL
- userID (Key2) — bigint — Foreign key → User.userID — NOT NULL
- price of mission (missionPrice) — bigint
- reservingRate (rate) — bigint
- status — int
- 사장님 구분번호 (classificationNum) — bigint
- created_at — datetime(6)
- updated_at — datetime(6)
Prefer food (Untitled8)
- FoodId (ID) — bigint — Primary key — NOT NULL
- userID (ID2) — bigint — Foreign key → User.userID — NOT NULL
- type — varchar(10)
- Field
User (Untitled)
- userID (ID) — bigint — Primary key — NOT NULL
- userName (name) — varchar(10)
- email — varchar(20)
- gender — int
- birth — datetime
- address — text
- userPoint (point) — int
- userStatus (status) — int
- 생성날짜 (created_at) — datetime(6)
- 갱신날짜 (updated_at) — datetime(6)
- 비활성 (inactive) — int
- Field
comment (Untitled6)
- CommentId (ID) — bigint — Primary key — NOT NULL
- reviewId (ID2) — bigint — Foreign key → review.reviewId — NOT NULL
- missionId (ID22) — bigint — Foreign key → review.missionId — NOT NULL
- storeId (ID222) — bigint — Foreign key → review.storeId — NOT NULL
- userID (Key) — bigint — Foreign key → review.userID — NOT NULL
- userID (Key2) — bigint — Foreign key → review.userID — NOT NULL
- userID (Key3) — bigint — Foreign key → review.userID — NOT NULL
- comment — text
- created_at — datetime(6)
- updated_at
point (Untitled5)
- PointId (ID) — bigint — Primary key — NOT NULL
- missionId (ID2) — bigint — Foreign key → Mission.missionId — NOT NULL
- storeId (ID22) — bigint — Foreign key → Mission.storeId — NOT NULL
- userID (Key) — bigint — Foreign key → Mission.userID — NOT NULL
- userID (Key2) — bigint — Foreign key → Mission.userID — NOT NULL
- point — bigint
- status — int
- created_at — datetime(6)
- updated_at — datetime(6)
- Field
query (Untitled7)
- QueryId (ID) — bigint — Primary key — NOT NULL
- userID (Key) — bigint — Foreign key → User.userID — NOT NULL
- query title (title) — text
- query content (content) — text
- query type (type) — varchar(20)
- image attached (image) — image
- status — int
- created_at — datetime(6)
- updated_at — datetime(6)
review (Untitled4)
- reviewId (ID) — bigint — Primary key — NOT NULL
- missionId (ID2) — bigint — Foreign key → Mission.missionId — NOT NULL
- storeId (ID22) — bigint — Foreign key → Mission.storeId — NOT NULL
- userID (Key) — bigint — Foreign key → Mission.userID — NOT NULL
- userID (Key2) — bigint — Foreign key → Mission.userID — NOT NULL
- userID (Key3) — bigint — Foreign key → User.userID — NOT NULL
- start (star) — int
- image — image
- created_at — datetime(6)
- updated_at — datetime(6)
- Field
store (Untitled3)
- storeId (ID) — bigint — Primary key — NOT NULL
- userID (Key) — bigint — Foreign key → User.userID — NOT NULL
- storeName (name) — varchar(20)
- reserving point (point) — bigint
- foodType (type) — varchar(10)
- resttime (rest) — bigint