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 1,626–1,650 of 4,762

card_payment, page 66 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
193435Toronto Bay StCanadaNoah Smith4550264542018Apple Pay
193514Torino CentroItalyLorenzo Colombo54939501102020NULL
193619München MarienplatzGermanyFinn Fischer55148563122019NULL
19371Nantes CommerceFranceLéa Martin5484929422019NULL
19407Denver Union StationUnited StatesMia Jones4778002042018NULL
19414Paris LouvreFranceLucas Lefebvre5575359022021NULL
19436Atlanta MidtownUnited StatesLiam Davis4894279182020NULL
194435Toronto Bay StCanadaNoah Smith44387076102018Google Pay
194525Incheon SongdoSouth KoreaDo-yun Choi4290495052021NULL
19464Paris LouvreFranceLéa Moreau5480648942022NULL
194723Yokohama MinatomiraiJapanYuto Yamamoto4889102772020Google Pay
19487Seattle Pike PlaceUnited StatesAva Garcia4181187872021Apple Pay
19496San Francisco Market StUnited StatesLogan Brown3726695222022NULL
19503Rennes RépubliqueFranceHugo Bernard48774627102018NULL
195125Seoul GangnamSouth KoreaHa-eun Kim4049471232022NULL
195216Sevilla TrianaSpainSofía Martín4459344762021NULL
195328Amsterdam ZuidasNetherlandsSem Visser48516085122018NULL
195416Madrid Gran VíaSpainMateo Sánchez42714362102021NULL
195515Firenze Santa Maria NovellaItalyFrancesco Esposito4795070612021NULL
19563Rennes RépubliqueFranceManon Leroy43723941102020NULL
19572Paris La DéfenseFranceLéa Laurent43584228112019NULL
195822Osaka UmedaJapanHaruto Nakamura3567737942019NULL
195911Manchester Market StUnited KingdomSophie Taylor4202462522020NULL
19605Austin DowntownUnited StatesMia Wilson4061030862021NULL
196233Bergen BryggenNorwayEmil Hansen47814648112019NULL
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;