g9
Tables (32)
Copy Of Copy Of Copy Of Copy Of Copy Of Untitled5 (PurchaseResponseFailLog)
- Key (Id) — Long — Primary key — NOT NULL
- Field (Product) — Product
- Field (Product_Discount) — Product_Discount
- Field (ProductOptionQuantity) — ProductOptionQuantity
- Field (MemberId) — MemberId
- Field (createDate) — LocalDateTime
- Field (TossPaymentObject) — TossPaymentObject
Copy Of Copy Of Copy Of Copy Of Untitled5 (PurchaseResponseSuccessLog)
- Key (Id) — Long — Primary key — NOT NULL
- Field (Product) — Product
- Field (Product_Discount) — Product_Discount
- Field (ProductOptionQuantity) — ProductOptionQuantity
- Field (MemberId) — MemberId
- Field (createDate) — LocalDateTime
- Field (TossPaymentObject) — TossPaymentObject
Copy Of Copy Of Copy Of Untitled5 (PurchaseRequestLog)
- Key (Id) — Long — Primary key — NOT NULL
- Field (Product) — Product
- Field (Product_Discount) — Product_Discount
- Field (ProductOptionQuantity) — ProductOptionQuantity
- Field (MemberId) — MemberId
- Field (createDate) — LocalDateTime
Copy Of Copy Of Untitled4 (FavoriteStore)
- Key (Id) — Long — Primary key — NOT NULL
- Key (Member) — Member — Foreign key → Member.Key — NOT NULL
- Key (Store) — Store — Foreign key → Untitled.Key — NOT NULL
Copy Of Copy Of Untitled5 (OrderDoneLog)
- Key (Id) — Long — Primary key — NOT NULL
- Field (Product) — Product
- Field (Product_Discount) — Product_Discount
- Field (ProductOptionQuantity) — ProductOptionQuantity
- Field (MemberId) — MemberId
- Field (createDate) — LocalDateTime
Copy Of Untitled (GroupBuyImage)
- Key (Id) — Long — Primary key — NOT NULL
- Key (GroupBuyChatRoom) — GroupBuyChatRoom — Foreign key → Untitled.Key — NOT NULL
- Field (image) — url
Copy Of Untitled2 (ReviewImage)
- Key (Id) — Long — Primary key — NOT NULL
- Key (Review) — Review — Foreign key → Untitled.Key — NOT NULL
- Field (image) — url
Copy Of Untitled3 (StoreChatMessage)
- Key (Id) — Long — Primary key — NOT NULL
- Key (StoreChatRoom) — StoreChatRoom — Foreign key → Untitled.Key — NOT NULL
- Field (content) — content
- Field (isStore) — Boolean
Copy Of Untitled4 (Wish)
- Key (Id) — Long — Primary key — NOT NULL
- Key (Member) — Member — Foreign key → Member.Key — NOT NULL
- Key (Product) — Product — Foreign key → Untitled.Key — NOT NULL
Copy Of Untitled5 (OrderStartRequestLog)
- Key (Id) — Long — Primary key — NOT NULL
- Field (Product) — Product
- Field (GroupBuy) — GroupBuy
- Field (Product_Discount) — Product_Discount
- Field (MemberId) — MemberId
- Field (createDate) — LocalDateTime
Member
- Key (Id) — Long — Primary key — NOT NULL
- 이름 (username) — String
- Field2 (role) — Authority
- Field (nickname) — String
- Field (phoneNumber) — phoneNumber
- Field (point) — Long
Order
- Key (Id) — Long — Primary key — NOT NULL
- Key (Member) — Member — Foreign key → Member.Key — NOT NULL
- Key (Store) — Store — Foreign key → Untitled.Key — NOT NULL
- Field (createDate) — LocalDateTime
- Field (orderStatus) — Enum
- Field (reciever) — String
- Field (phoneNumber) — phoneNumber — 삭제필요
- Field (mainAddress) — 삭제필요
- Field (subAddress) — 삭제필요
- Field (totalPrice) — Integer
- Field (shippingFee) — Integer
- Field (shippingStatus) — Enum
Untitled (StoreChatRoom)
- Key (Id) — Long — Primary key — NOT NULL
- Key (Member) — Member — Foreign key → Member.Key — NOT NULL
- Key (Store) — Store — Foreign key → Untitled.Key — NOT NULL
Untitled (Product)
- Key (Id) — Long — Primary key — NOT NULL
- Key (Store) — Store — Foreign key → Untitled.Key — NOT NULL
- Field (name) — String
- Field (price) — Integer — products` price
- Field (description) — text
- Field (image) — String
- Field (option1) — String
- Field (option2) — String
- Field (maxPurchaseNum) — Integer
Untitled (Store)
- Key (Id) — Long — Primary key — NOT NULL
- Field (name) — String
- Field2 (phoneNumber) — phoneNumber
- Key (Member) — Member — Foreign key → Member.Key — NOT NULL
Untitled (GroupBuy)
- Key (Id) — Long — Primary key — NOT NULL
- Key (Product) — Product — Foreign key → Untitled.Key — NOT NULL
- Field (startTime) — LocalDateTime
- Field (endTime) — LocalDateTime
- Field (name) — String
- Field (status) — Enum
Untitled (productInfo)
- Key (Id) — Long — Primary key — NOT NULL
- Field (Product) — Product
Untitled (shipInfo)
- Key (Id) — Long — Primary key — NOT NULL
- Field (reciever)
- Field2 (phoneNumber)
- Field3 (mainAddress)
- Field (subAddress)
- Field (memberId)
- Field (memberName)
- Field (productId)
- Field (productName)
- Field (storeId)
- Field (storeName)
Untitled (Product_Discount)
- Key (Id) — Long — Foreign key → Untitled.Key — NOT NULL
- Field (productCount) — Integer
- Field (discountRate) — Integer
Untitled (ProductOptionQuantity)
- Key (Id) — Long — Primary key — NOT NULL
- Key (ProductOption) — ProductOption — Foreign key → Untitled.Key — NOT NULL
- Field (quantity) — Integer
- Field (price) — Integer — price * quantity / discount
- Key (order) — Order — Foreign key → Order.Key — NOT NULL
Untitled (ProductOption)
- Key (Id) — Long — Primary key — NOT NULL
- Field (option1Name) — String
- Field (option2Name) — String
- Key (Product) — Product — Foreign key → Untitled.Key — NOT NULL
Untitled (GroupBuy_Member)
- Key — Long — Foreign key → Untitled.Key — NOT NULL
- Key (Member) — Member — Foreign key → Member.Key — NOT NULL
Untitled (ProductImage)
- Key (Id) — Long — Primary key — NOT NULL
- Key (Product) — Product — Foreign key → Untitled.Key — NOT NULL
- Field (image) — url
Untitled (MemberStoreImage)
- Key (Id) — Long — Primary key — NOT NULL
- Key (Member) — Member — Foreign key → Member.Key — NOT NULL
- Key (Store) — Store — Foreign key → Untitled.Key — NOT NULL
- Field (image) — url
Untitled (ProductAnswer)
- Key (Id) — Long — Primary key — NOT NULL
- Key (ProductQuestion) — ProductQuestion — Foreign key → Untitled.Key — NOT NULL
- Field (content) — text
Untitled (ProductQuestion)
- Key (Id) — Long — Primary key — NOT NULL
- Key (Product) — Product — Foreign key → Untitled.Key — NOT NULL
- Key (Member) — Member — Foreign key → Member.Key — NOT NULL
- Field (title) — String
- Field (content) — text
Untitled (ReviewTag)
- Key (Id) — Long — Primary key — NOT NULL
- Field2 (content) — String
- Field3 (rating) — Integer
- Key (Review) — Review — Foreign key → Untitled.Key — NOT NULL
- Key (Tag) — Tag — Foreign key → Untitled.Key — NOT NULL
Untitled (Tag)
- Key (Id) — Long — Primary key — NOT NULL
- Field (name) — String
Untitled (Review)
- Key (Id) — Long — Primary key — NOT NULL
- Key (Product) — Product — Foreign key → Untitled.Key — NOT NULL
- Key (Member) — Member — Foreign key → Member.Key — NOT NULL
- Field (content) — String
- Field (createDate) — LocalDateTime
- Field (rating) — Integer
Untitled (ChatRoomParticipants)
- Key (Id) — Long — Primary key — NOT NULL
- Key (Member) — Member — Foreign key → Member.Key — NOT NULL
- Key (GroupBuyChatRoom) — GroupBuyChatRoom — Foreign key → Untitled.Key — NOT NULL
- Field (chattingOffset) — chattingOffset
Untitled (GroupBuyChatRoom)
- Key (Id) — Long — Primary key — NOT NULL
- Key (GroupBuy) — GroupBuy — Foreign key → Untitled.Key — NOT NULL
- Field (name) — String
Untitled (GroupBuyChatMessage)
- Key (Id) — Long — Primary key — NOT NULL
- Field (chatType) — Enum
- Field (content) — text
- Field (createDate) — Date
- Field (isSeller) — Boolean
- Field (chatRoomId) — Long