MetaPay
Tables (3)
BankAccount (bank_accounts)
- bank_account_id — BIGINT — Primary key — NOT NULL
- paymentMethodId (payment_method_id) — BIGINT — Foreign key → PaymentMethod.payment_method_id — NOT NULL
- token — VARCHAR(255)
- accountNumber (account_number) — VARCHAR(20)
- bankName (bank_name) — VARCHAR(25)
- createdAt (created_at) — TIMESTAMP
- updatedAt (updated_at) — TIMESTAMP
Card (Untitled)
- card_id — BIGINT — Primary key — NOT NULL
- paymentMethodId (payment_method_id) — BIGINT — Foreign key → PaymentMethod.payment_method_id — NOT NULL
- token — VARCHAR(255)
- cardType (card_type) — VARCHAR(25)
- cardNumber (card_number) — VARCHAR(16)
- expirationDate (expiration_date) — DATE
- createdAt (created_at) — TIMESTAMP
- updatedAt (updated_at) — TIMESTAMP
PaymentMethod (payment_methods)
- payment_method_id — BIGINT — Primary key — NOT NULL
- customerId (customer_id) — VARCHAR(30)
- paymentType (payment_type) — VARCHAR(15)
- isDefault (is_default) — BOOLEAN
- alias — VARCHAR(255)
- createdAt (created_at) — TIMESTAMP
- updatedAt (updated_at) — TIMESTAMP