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