Skip to content
Louvre Ops DB

Table

card_payment

Card and wallet details: first and last four digits, expiry month and year, issuing branch.

Replaces in 2020: EFTPOS

Download CSV Query in playground

Rows 776–800 of 4,762

card_payment, page 32 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
9436Atlanta MidtownUnited StatesAva Garcia4061406622019NULL
9441Paris OpéraFranceChloé Leroy49299354122018NULL
94516Sevilla TrianaSpainPaula Fernández4577951542017NULL
94613Bristol Corn StUnited KingdomFreddie Wright3786633512019NULL
9477Seattle Pike PlaceUnited StatesLogan Smith5588259692017NULL
94817Bilbao AbandoSpainLucía Martín4606868162019Apple Pay
94932Göteborg AvenynSwedenOscar Persson4803603382020NULL
95011London Canary WharfUnited KingdomAmelia Johnson4129508242018NULL
95126Adelaide Rundle MallAustraliaCharlotte Ryan4233249132018NULL
95235Toronto Bay StCanadaEmma Gagnon5278995912017Apple Pay
9536San Francisco Market StUnited StatesMia Miller52477028112020NULL
9544Strasbourg KléberFranceManon Thomas5108632432019Google Pay
95519München MarienplatzGermanyLeon Hoffmann5164506272021NULL
95630Saint Petersburg NevskyRussiaIvan Sokolov5327057312018NULL
95726Melbourne Collins StAustraliaIsla Jones51240333122019Google Pay
95818Frankfurt TaunusanlageGermanyElias Becker5279503712020NULL
95918Berlin Unter den LindenGermanyLeon Koch5521911632020Google Pay
9608Shanghai PudongChinaLei Chen5181251092019NULL
96120Rio CentroBrazilArthur Pereira4734573082021NULL
9637Seattle Pike PlaceUnited StatesMason Smith5352600742020NULL
9641Paris OpéraFranceLouis Bernard5356680432017NULL
9655Chicago LoopUnited StatesMason Smith5492928772020NULL
96615Roma TerminiItalyFrancesco Ricci4233931252020NULL
9701Lyon BellecourFranceLucas Durand4493027192019NULL
9733Toulouse CapitoleFranceArthur Martin4047976282020Apple Pay
Table definition
CREATE TABLE card_payment (
  payment_id     INTEGER PRIMARY KEY REFERENCES payment (payment_id),
  institution_id INTEGER NOT NULL REFERENCES financial_institution (institution_id),
  issuing_branch TEXT NOT NULL,
  issued_country TEXT NOT NULL,
  account_name   TEXT NOT NULL,
  card_first4    TEXT NOT NULL CHECK (length(card_first4) = 4 AND card_first4 NOT GLOB '*[^0-9]*'),
  card_last4     TEXT NOT NULL CHECK (length(card_last4) = 4 AND card_last4 NOT GLOB '*[^0-9]*'),
  expiry_month   INTEGER NOT NULL CHECK (expiry_month BETWEEN 1 AND 12),
  expiry_year    INTEGER NOT NULL CHECK (expiry_year BETWEEN 2000 AND 2099),
  wallet         TEXT CHECK (wallet IN ('Apple Pay', 'Google Pay'))
) STRICT;