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 226–250 of 4,762

card_payment, page 10 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
2666Boston Back BayUnited StatesElla Moore48462937112016NULL
26720São Paulo PaulistaBrazilHeitor Silva54091118112019NULL
2681Paris OpéraFranceJules Petit5391043622020NULL
26928Rotterdam CoolsingelNetherlandsLucas de Jong5171369112020NULL
2701Paris OpéraFranceArthur Leroy49549046112018NULL
2714Paris LouvreFranceArthur Leroy51415431122019NULL
2721Lyon BellecourFranceZoé Durand5537002232018NULL
2732Paris La DéfenseFranceGabriel Moreau5590384582018NULL
2742Lille Grand PlaceFranceGabriel Lefebvre4828574212018NULL
27530Moscow TverskayaRussiaAlexander Vasiliev4945633612020NULL
2761Lyon BellecourFranceHugo Thomas4746663462019NULL
2787Seattle Pike PlaceUnited StatesAva Miller55496258102020NULL
2794Strasbourg KléberFranceGabriel Moreau5523681112020NULL
2809Guangzhou TianheChinaTao Zhao5503019782020NULL
2812Paris La DéfenseFranceLucas Moreau49032995102016NULL
2851Lyon BellecourFranceZoé Moreau4678202682018NULL
28617Barcelona EixampleSpainLucía Martín5342765962020NULL
28721Belo Horizonte SavassiBrazilValentina Ferreira40271188102019NULL
28816Madrid Gran VíaSpainPaula López4612551352017NULL
28913Edinburgh Princes StUnited KingdomJack Evans3756792842019NULL
2902Lille Grand PlaceFranceGabriel Thomas5229098932018NULL
29117Bilbao AbandoSpainPaula López54192746122016NULL
2922Paris La DéfenseFranceGabriel Thomas53867410102017NULL
29312Leeds BriggateUnited KingdomAlfie Davies55501174112020NULL
2941Paris OpéraFranceCamille Leroy4014307942018NULL
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;