SsuBooks

Tables (10)

Book

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • product_id (Key2) — NOT NULL — Foreign key → Product.member_id — NOT NULL
  • member_id (Key3) — NOT NULL — Foreign key → Member.id — NOT NULL
  • subject (Field6)
  • price (Field)

CartItem

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • product_id (Key2) — NOT NULL — Foreign key → Product.id — NOT NULL
  • member_id (Key3) — NOT NULL — Foreign key → Member.id — NOT NULL
  • createDate (Field) — NOT NULL
  • modifyDate (Field2) — NOT NULL

CashLog (CopyOfProduct)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • member_id (Key2) — NOT NULL — Foreign key → Member.id — NOT NULL
  • relTypeCode (Field6) — varchar(32)
  • relId (Field) — Type
  • price (Field2) — Type
  • eventType (Field3) — varchar(32)

Member

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • createDate (Field7) — NOT NULL — NOT NULL
  • modifyDate (Field8) — NOT NULL — NOT NULL
  • username (Field9) — NOTNULL — NOT NULL
  • password (Field) — NOT NULL — NOT NULL
  • email (Field2) — NULL
  • nickname (Field3) — NULL
  • emailVerified (Field4) — NULL
  • restCash (Field5) — NOT NULL

OrderItem

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • product_id (Key22) — NOT NULL — Foreign key → Product.member_id — NOT NULL
  • order_id (Key2) — NOT NULL — Foreign key → ProductOrder.id — NOT NULL
  • price (Field6)
  • salePrice (Field)
  • wholeslaePrice (Field2)
  • pgFee (Field3)
  • payPrice (Field4)
  • refundPrice (Field5)
  • isPaid (Field7)
  • payDate (Field8)

Post

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • member_id (Key2) — NOT NULL — Foreign key → Member.id — NOT NULL
  • createDate (Field5) — NOT NULL
  • modifyDate (Field4) — NOT NULL
  • subject (Field) — NOT NULL
  • content (Field2) — NOT NULL
  • contentHtml (Field3) — NOT NULL

Product

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • member_id (Key2) — NOT NULL — Foreign key → Member.id — NOT NULL
  • subject (Field6)
  • price (Field)

ProductOrder

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • member_id (Key2) — NOT NULL — Foreign key → Member.id — NOT NULL
  • name (Field6)
  • isPaid (Field)
  • isCancled (Field2)
  • isRefunded (Field3)

RebateOrderItem

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • orderItem_id (Key2) — NOT NULL — Foreign key → OrderItem.id — NOT NULL
  • productOrder_id (Key3) — NOT NULL — Foreign key → ProductOrder.id — NOT NULL
  • product_id (Key4) — NOT NULL — Foreign key → Product.id — NOT NULL
  • cashLog_id (Key5) — NOT NULL — Foreign key → CashLog.id — NOT NULL
  • member_id (Key6) — NOT NULL — Foreign key → Member.id — NOT NULL
  • price (Field)
  • salePrice (Field2)
  • wholesalePrice (Field3)
  • pgFee (Field4)
  • payPrice (Field5)
  • refundPrice (Field6)
  • isPaid (Field7) — boolean
  • payDate (Field8) — NOT NULL

WithdrawApply (CopyOfPost)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • member_id (Key2) — NOT NULL — Foreign key → Member.id — NOT NULL
  • cashLog_id (Key3) — NOT NULL — Foreign key → CashLog.id — NOT NULL
  • bankName (Field)
  • bankAccountNo (Field2)
  • price (Field3)
  • withdrawDate (Field4) — NOT NULL