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 3,076–3,100 of 4,762

card_payment, page 124 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
35774Strasbourg KléberFranceArthur Durand4447721522023NULL
357828Rotterdam CoolsingelNetherlandsLucas Bakker4289272822022NULL
357914Torino CentroItalySofia Ferrari4514632772021Apple Pay
35801Nantes CommerceFranceHugo Robert47664999102020NULL
358116Sevilla TrianaSpainHugo Gómez4578751692022NULL
358217Bilbao AbandoSpainHugo Gómez4636806722020NULL
35831Nantes CommerceFranceLéa Martin43983633122022NULL
35842Lille Grand PlaceFranceLouis Leroy4115359772022NULL
358515Roma TerminiItalyAurora Marino4564211992019NULL
358614Torino CentroItalyGinevra Ferrari4527858782019NULL
358715Firenze Santa Maria NovellaItalyGinevra Ferrari4709022742023NULL
35884Paris LouvreFranceZoé Lefebvre4426350642020NULL
35891Paris OpéraFranceJules Thomas5381499872020NULL
359026WoolloomoolooAustraliaOliver Smith4000367772019NULL
359130Saint Petersburg NevskyRussiaAnastasia Ivanov4862502962023Apple Pay
35923Bordeaux ChartronsFranceArthur Simon4899218022019NULL
35932Lille Grand PlaceFranceHugo Moreau55039003112019NULL
35941Nantes CommerceFranceJules Martin4339493162020Google Pay
359525Seoul GangnamSouth KoreaHa-eun Yoon46207534102022NULL
359619München MarienplatzGermanyLeon Weber4641920662022NULL
359833Bergen BryggenNorwayIngrid Hansen5161168042023NULL
359928Rotterdam CoolsingelNetherlandsJulia van den Berg4453647182021NULL
36002Paris La DéfenseFranceArthur Robert4409803842021NULL
360112Birmingham New StUnited KingdomGeorge Walker4180476682019NULL
360226WoolloomoolooAustraliaWilliam Kelly4099331172020NULL
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;