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