비플페이

테이블 (7)

Copy Of Copy Of Copy Of User22 (Refunds)

  • Key (RefundID) — 기본 키 — NOT NULL
  • Field (PaymentID)
  • Field2 (Amount)
  • Field3 (RefundDate)
  • Field4 (Reason)
  • Field5 (Status)

Copy Of Copy Of User (Vouchers)

  • Key (VoucherID) — 기본 키 — NOT NULL
  • Field (UserID)
  • Field2 (VoucherType)
  • Field3 (Code)
  • Field4 (Value)
  • Field5 (ExpiryDate)
  • Field (Status)

Copy Of Copy Of User2 (Merchants)

  • Key (MerchantID) — 기본 키 — NOT NULL
  • Key (PaymentID) — 외래 키 → Copy Of User2.Key — NOT NULL
  • Key (VoucherID) — 외래 키 → Copy Of User2.Key — NOT NULL
  • Field (MerchantName)
  • Field2 (BusinessType)
  • Field3 (ContactNumber)
  • Field4 (Location)
  • Field5 (RegistrationDate)
  • Field (Status)

Copy Of Copy Of User22 (Transaction_History)

  • Key (TransactionID) — 기본 키 — NOT NULL
  • Key (PaymentID) — 외래 키 → Copy Of User2.Key — NOT NULL
  • Key (RefundID) — 외래 키 → Copy Of Copy Of Copy Of User22.Key — NOT NULL
  • Key (VoucherID) — 외래 키 → Copy Of User2.Key — NOT NULL
  • Field3 (Details)
  • Field4 (Timestamp)

Copy Of User (Payment_Accounts)

  • Key (AccountID) — 기본 키 — NOT NULL
  • Field (UserID)
  • Field2 (AccountType)
  • Field3 (AccountNumber)
  • Field4 (Balance)
  • Field5 (Status)
  • Field (MonthlyBalanceLimit)

Copy Of User2 (Payments)

  • Key (PaymentID) — 기본 키 — NOT NULL
  • Key (VoucherID) — 외래 키 → Copy Of Copy Of User.Key — NOT NULL
  • Field2 (MerchantID)
  • Field3 (Amount)
  • Field4 (PaymentMethod)
  • Field5 (TransactionDate)
  • Field (Status)
  • Field (UsageDate)

User

  • Key (UserID) — 기본 키 — NOT NULL
  • Field (Name)
  • Field2 (Email)
  • Field3 (PhoneNumber)
  • Field4 (RegisteredDate)
  • Field5 (AccountSatus)