HealthApp

Tables (9)

CommnuityComment (Untitled3)

  • commentId (Key) — bigInt — Primary key — NOT NULL
  • content (Field) — varchar
  • author (Field2) — varchar
  • createdAt (Field3) — datetime
  • updateAt (Field4) — datetime
  • postId (Key2) — bigInt — Foreign key → Community.postId — NOT NULL
  • userId (Key3) — bigint — Foreign key → User.userId — NOT NULL

Community (Untitled2)

  • postId (Key) — bigInt — Primary key — NOT NULL
  • title (Field) — varchar
  • content (Field2) — varchar
  • category (Field3) — enum
  • author (Field4) — varchar
  • createdAt (Field5) — datetime
  • updatedAt (Field6) — datetime
  • userId (Key2) — bigint — Foreign key → User.userId — NOT NULL

Image (Untitled4)

  • imageId (Key) — bigint — Primary key — NOT NULL
  • imageUrl (Field) — varchar
  • isMain (Field2) — boolean
  • createdAt (Field3) — datetime
  • updatedAt (Field4) — datetime
  • ImageType (Field5) — enum
  • userId (Key2) — bigint — Foreign key → User.userId — NOT NULL
  • reviewId (Key3) — bigint — Foreign key → Reviews.reviewId — NOT NULL
  • postId (Key4) — bigInt — Foreign key → Community.postId — NOT NULL
  • commentId (Key5) — bigInt — Foreign key → CommnuityComment.commentId — NOT NULL
  • placeId (Key6) — bigint — Foreign key → Place.placeId — NOT NULL

Place (Untitled5)

  • placeId (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar
  • avgRating (Field2) — double
  • latitude (Field3) — varchar
  • longtitude (Field4) — varchar
  • createdAt (Field5) — datetime
  • updateAt (Field6) — datetime
  • description (Field7) — varchar
  • discountRate (Field8) — double
  • price (Field9) — int
  • address (Field10) — String
  • kakaoChannelUrl (Field11) — varchar
  • contactPhone (Field12) — varchar
  • category (Field13) — enum
  • userId (Key2) — bigint — Foreign key → User.userId — NOT NULL
  • regionId (Key3) — bigint — Foreign key → Region.regionId — NOT NULL

ProductSchedule (Untitled6)

  • scheduleId (Key) — bigint — Primary key — NOT NULL
  • dayOfWeek (Field) — datetime
  • startTime (Field2) — datetime
  • endTime (Field3) — datetime
  • buissnessType (Field4) — enum
  • placeId (Key2) — bigint — Foreign key → Place.placeId — NOT NULL

Purchase (Untitled8)

  • purchaseId (Key) — bigint — Primary key — NOT NULL
  • totalPrice (Field) — int
  • purchaseType (Field7) — enum
  • purchaseStatus (Field3) — enum
  • paymentMethod (Field4) — enum
  • purchaseCancelReasonType (Field5) — enum
  • purchaseCancelReasonDetail (Field6) — varchar
  • sellStatus (Field2) — enum
  • sellCancelType (Field8) — enum
  • sellCancelDetail (Field9) — varchar
  • paidAt (Field10) — datetime
  • cancelRequestAt (Field11) — datetime
  • sellerConfirmedAt (Field12) — datetime
  • sellerCancelledAt (Field13) — datetime
  • userId (Key2) — bigint — Foreign key → User.userId — NOT NULL
  • scheduleId (Key3) — bigint — Foreign key → ProductSchedule.scheduleId — NOT NULL

Region (Untitled)

  • regionId (Key) — bigint — Primary key — NOT NULL
  • mainRegion (Field) — varchar
  • subRegion (Field2) — varchar
  • latittude (Field3) — double
  • longitude (Field4) — double

Reviews (Untitled7)

  • reviewId (Key) — bigint — Primary key — NOT NULL
  • content (Field) — varchar
  • rating (Field2) — double
  • name (Field3) — varchar
  • createdAt (Field4) — datetime
  • updatedAt (Field5) — datetime
  • userId (Key2) — bigint — Foreign key → User.userId — NOT NULL
  • placeId (Key3) — bigint — Foreign key → Place.placeId — NOT NULL

User (유저)

  • userId (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar
  • email (Field2) — varchar
  • category (Field4) — enum
  • createdAt (Field5) — datetime
  • updatedAt (Field6) — datetime
  • role (Field7) — enum