payment

Tables (13)

Untitled (Payment)

  • Key (id) — int — Primary key — NOT NULL
  • Key (orderId) — string — Foreign key → Untitled.Key — NOT NULL
  • Field (key) — string
  • Field (currency) — string
  • Field (totalAmount) — int
  • Field (status) — string
  • Field (createdAt) — date
  • Field (updatedAt) — date

Untitled (CustomerDetail)

  • Key (id) — int — Primary key — NOT NULL
  • Key (userId) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (customerKey) — int
  • Field (authorizationCode) — string
  • Field (accessToken) — string
  • Field2 (refreshToken) — string
  • Field (code) — string
  • Field (tokenType) — string
  • Field (expiresIn) — int
  • Field (createdAt) — timestamp
  • Field (updatedAt) — timestamp

Untitled (Transaction)

  • Key (id) — int — Primary key — NOT NULL
  • Field (mId) — string
  • Field (key) — string
  • Key (paymentKey) — string — Foreign key → Untitled.Key — NOT NULL
  • Field (paymentType) — string
  • Field (paymentMethod) — string
  • Field (type) — string
  • Field (amount) — int
  • Field (balanceAmount) — int
  • Field (suppliedAmount) — int
  • Field (vat) — int
  • Field (taxFreeAmount) — int
  • Field (taxExemptionAmount) — int
  • Field (transferDiscountAmount) — int
  • Field (easyPayDiscountAmount) — int
  • Field (cultureExpense) — boolean
  • Field (stauts) — string
  • Field2 (reason) — string
  • Field (receiptKey) — string
  • Field (useEscrow) — boolean
  • Field (isPartialCancelable) — boolean
  • Field (country) — string
  • Field (currency) — string
  • Field (receiptUrl) — string
  • Field (checkoutUrl) — string
  • Field (secret) — string
  • Field (createdAt) — date
  • Field (updatedAt) — date

Untitled (Cancel)

  • Key (id) — int — Primary key — NOT NULL
  • Field (key) — string
  • Field (reason) — string
  • Field (amount) — int
  • Field (taxFreeAmount) — int
  • Field (taxExemptionAmount) — int
  • Field (refundableAmount) — int
  • Field (receiptKey) — string
  • Field (transferDiscountAmount) — int
  • Field (easyPayDiscountAmount) — int
  • Field (status) — string
  • Field (createdAt) — date

Untitled (ApprovedPayment)

  • Key (id) — int — Primary key — NOT NULL
  • Field (key) — string
  • Field (amount) — int
  • Field (taxFreeAmount) — int
  • Field (taxExemptionAmount) — int
  • Field (cultureExpense) — boolean
  • Field (receiptKey) — string
  • Field (createdAt) — date

Untitled (User)

  • Key (id) — Primary key — NOT NULL

Untitled (Order)

  • Key (id) — int — Primary key — NOT NULL
  • Key (userId) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (key) — string

Untitled (Product)

  • Key (id) — int — Primary key — NOT NULL
  • Field (type) — string
  • Field (domain) — string
  • Field (stockType) — string
  • Field (name) — string
  • Field (description) — string
  • Field (images) — string[]
  • Field (detailImages) — string[]
  • Field (originalPrice) — int
  • Field (stockQuantity) — int
  • Field (currency) — string
  • Field (createdAt) — timestamp
  • Field (updatedAt) — timestamp
  • Field

Untitled (OrderProduct)

  • Key (id) — int — Primary key — NOT NULL
  • Key (orderId) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (productId) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (amount / quantity) — int
  • Field (price) — int
  • Field (snapshot) — json
  • Field (status) — string
  • Field (createdAt) — timestamp
  • Field (updatedAt) — timestamp

Untitled (AccountDetail)

  • Key (id) — Primary key — NOT NULL
  • Field (currencyId) — int
  • Field (type) — string
  • Key (transactionId) — int — Foreign key → Untitled.Key — NOT NULL
  • Field2 (amount) — int
  • Field (balanceAmount) — int
  • Field2 (createdAt) — timestamp
  • Field (updatedAt) — timestamp

Untitled (ProductLike)

  • Key — Primary key — NOT NULL
  • Key (customerKey) — string — Foreign key → Untitled.Key — NOT NULL
  • Key (productId) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (createdAt) — timestamp
  • Field2 (updatedAt) — timestamp

Untitled (DeliveryProfile)

    Untitled (PackageDetail)

    • Key — Primary key — NOT NULL
    • Key (productId) — int — Foreign key → Untitled.Key — NOT NULL
    • Key (packageId) — int — Foreign key → Untitled.Key — NOT NULL
    • Field (quantity) — int
    • Field (isChangable) — boolean
    • Field