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