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,251–1,275 of 4,762

card_payment, page 51 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
150635Montréal Ville-MarieCanadaBenjamin Gagnon4642252752021Google Pay
150735Montréal Ville-MarieCanadaBenjamin Gagnon47824962102018NULL
15089Shenzhen FutianChinaLin Huang62215748122021NULL
15093Toulouse CapitoleFranceCamille Thomas4052434882017NULL
151014Milano DuomoItalyGiulia Greco45478313112018NULL
15115Manhattan MidtownUnited StatesLogan Taylor4838978462021NULL
151212Leeds BriggateUnited KingdomSophie Taylor4242642362019NULL
15133Toulouse CapitoleFranceLucas Bernard4445954742021NULL
151418Frankfurt TaunusanlageGermanyBen Schmidt5497888932021NULL
15156Boston Back BayUnited StatesLiam Miller52716118122019NULL
15162Marseille CanebièreFranceHugo Moreau5122850092021NULL
151819München MarienplatzGermanyLeon Koch5398722792021NULL
151915Roma TerminiItalySofia Greco4973419242021NULL
152015Roma TerminiItalyBeatrice Rossi5502361642021NULL
15216Atlanta MidtownUnited StatesJames Brown51619424112021NULL
152219Hamburg JungfernstiegGermanyElias Müller4582037862021NULL
152426Adelaide Rundle MallAustraliaAmelia Kelly4637184932021NULL
15254Strasbourg KléberFranceHugo Simon5586254572019NULL
15264Paris LouvreFranceLouis Thomas4697256752020NULL
15272Paris La DéfenseFranceChloé Robert5576721372017NULL
15283Toulouse CapitoleFranceLucas Thomas5434391732017Google Pay
152921Belo Horizonte SavassiBrazilAlice Santos54951847122018NULL
153012Leeds BriggateUnited KingdomHarry Davies3724556282021NULL
15312Marseille CanebièreFranceChloé Petit5375312862017NULL
15321Paris OpéraFranceZoé Durand4806962762018NULL
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;