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