ex01

Tables (4)

PaymentMethods (Untitled2)

  • payID (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → Users.user_id — NOT NULL
  • providID (Key3) — Foreign key → Providers.providID — NOT NULL
  • methodType (Field)
  • providerName (Field2)
  • accNum (Field3)
  • expDate (Field4)
  • default (Field5)
  • createdAt (Field6)

Providers (Untitled4)

  • providID (Key) — Primary key — NOT NULL
  • name (Field)
  • type (Field2)
  • country (Field3)

Transactions (Untitled3)

  • transacID (Key) — Primary key — NOT NULL
  • payID (Key2) — Foreign key → PaymentMethods.payID — NOT NULL
  • user_id (Key22) — Foreign key → PaymentMethods.user_id — NOT NULL
  • providID (Key3) — Foreign key → PaymentMethods.providID — NOT NULL
  • amount (Field)
  • currency (Field2)
  • status (Field3)
  • createdAt (Field4)
  • updatedAt (Field5)

Users (Untitled)

  • user_id (Key) — Primary key — NOT NULL
  • email (Field)
  • pw (Field2)
  • createdAt (Field3)
  • updatedAt (Field4)