19,118rows
6 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
CreditCardID | INTEGER | no | PK | — |
CardType | TEXT | no | — | — |
CardNumber | TEXT | no | — | — |
ExpMonth | INTEGER | no | — | — |
ExpYear | INTEGER | no | — | — |
ModifiedDate | TEXT | no | — | — |
Keys and unique indexes
Physical SQLite metadataPrimary key is declared above.
Additional unique keys
Sales_CreditCard_AK_CreditCard_CardNumberCardNumber1 unique index inspected
Sales_CreditCard_AK_CreditCard_CardNumberCardNumberCREATE UNIQUE INDEX "Sales_CreditCard_AK_CreditCard_CardNumber" ON "Sales.CreditCard" ("CardNumber")Data preview
Sample records
| CreditCardID | CardType | CardNumber | ExpMonth | ExpYear | ModifiedDate |
|---|---|---|---|---|---|
| 1 | SuperiorCard | 33332664695310 | 11 | 2006 | 2024-07-28 00:00:00.000 |
| 2 | Distinguish | 55552127249722 | 8 | 2005 | 2024-12-04 00:00:00.000 |
| 3 | ColonialVoice | 77778344838353 | 7 | 2005 | 2025-01-13 00:00:00.000 |
| 4 | ColonialVoice | 77774915718248 | 7 | 2006 | 2024-05-19 00:00:00.000 |
| 5 | Vista | 11114404600042 | 4 | 2005 | 2024-02-01 00:00:00.000 |
| 6 | Distinguish | 55557132036181 | 9 | 2006 | 2025-04-09 00:00:00.000 |
| 7 | Distinguish | 55553635401028 | 6 | 2007 | 2024-02-01 00:00:00.000 |
| 8 | SuperiorCard | 33336081193101 | 7 | 2007 | 2024-06-29 00:00:00.000 |
Interactive explorer