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