비플페이
테이블 (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)