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 201–225 of 4,762

card_payment, page 9 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
23114Milano DuomoItalyLorenzo Ferrari4242526072018NULL
23216Sevilla TrianaSpainSofía López4904271842017NULL
2339Guangzhou TianheChinaYang Wu62803162112016NULL
2349Shenzhen FutianChinaMin Wang4599852982018NULL
2356San Francisco Market StUnited StatesAva Taylor37254158112019NULL
23610Chengdu JinjiangChinaXin Sun6256462422019NULL
2394Paris LouvreFranceLéa Simon4634506632019NULL
24121Brasília Asa SulBrazilLaura Souza45882486122016NULL
24233Bergen BryggenNorwayFilip Hansen4616071862019Apple Pay
2436Boston Back BayUnited StatesLogan Davis49890178122020NULL
2445Chicago LoopUnited StatesOlivia Davis45606345122019NULL
24611London Canary WharfUnited KingdomGrace Walker5551828462020NULL
2471Nantes CommerceFranceCamille Laurent43967391122020NULL
24831Kraków RynekPolandAntoni Kowalczyk4280927382019NULL
2494Paris LouvreFranceGabriel Dubois4817706962016Apple Pay
2509Shenzhen FutianChinaJing Li5186054112018NULL
2522Lille Grand PlaceFranceZoé Simon46938617112017NULL
2534Paris LouvreFranceArthur Petit4480987772017NULL
25414Torino CentroItalySofia Colombo42477894112019NULL
25818Frankfurt TaunusanlageGermanyEmma Müller4853716592017NULL
25924Seoul YeouidoSouth KoreaSeo-jun Jung5341466762016NULL
26016Sevilla TrianaSpainMateo López5141679182017NULL
2613Rennes RépubliqueFranceHugo Leroy4871950112019Apple Pay
26329Utrecht CentrumNetherlandsTess Visser4952054832017NULL
2652Lille Grand PlaceFranceArthur Leroy55683390102019NULL
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;