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)