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 276–300 of 4,762

card_payment, page 12 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
32221Belo Horizonte SavassiBrazilHeitor Oliveira43287716122018NULL
32319München MarienplatzGermanyPaul Wagner54338421102017NULL
32410Hangzhou XihuChinaJing Sun6274402162020NULL
3269Guangzhou TianheChinaJing Sun4696360732017Apple Pay
3272Lille Grand PlaceFranceGabriel Leroy5157604252016NULL
32822Osaka UmedaJapanSota Yamamoto4477942452020NULL
3299Shenzhen FutianChinaTao Zhao62503251102016NULL
33010Hangzhou XihuChinaFang Yang6281414442019NULL
3312Lille Grand PlaceFranceGabriel Robert4146375822018NULL
3323Rennes RépubliqueFranceGabriel Robert5383634572019NULL
33312Leeds BriggateUnited KingdomAlfie Evans46566584122019NULL
3361Paris OpéraFranceZoé Bernard4226559062020NULL
33716Sevilla TrianaSpainLucía González5244830512019NULL
33812Leeds BriggateUnited KingdomIsla Smith4136573072020NULL
33914Milano DuomoItalyLeonardo Bianchi5368238262016NULL
34014Milano DuomoItalyLeonardo Bianchi4028006442017NULL
3412Paris La DéfenseFranceCamille Thomas4442197632018NULL
34317Barcelona EixampleSpainLucía González4642606122017NULL
3445Austin DowntownUnited StatesHarper Anderson4353756872016NULL
34615Roma TerminiItalyBeatrice Bianchi4117214582018NULL
34713Edinburgh Princes StUnited KingdomIsla Smith5199308822018NULL
34926WoolloomoolooAustraliaOliver Brown5195384542019NULL
35024Busan SeomyeonSouth KoreaDo-yun Park5245716152016NULL
3513Bordeaux ChartronsFranceGabriel Durand4776085342019NULL
35218Frankfurt TaunusanlageGermanyMia Becker5359233442020Google 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;