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