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,476–1,500 of 4,762

card_payment, page 60 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
176010Hangzhou XihuChinaFang Wang6267204022020NULL
17614Paris LouvreFranceZoé Martin47564978102020NULL
176226Melbourne Collins StAustraliaNoah Ryan5432648812021NULL
17639Shenzhen FutianChinaJun Sun6254962292021NULL
17646Atlanta MidtownUnited StatesEmma Anderson37203942122019NULL
176635Toronto Bay StCanadaWilliam Lee5127651672017NULL
176735Montréal Ville-MarieCanadaChloé Brown53496678112017NULL
17687Seattle Pike PlaceUnited StatesLiam Garcia52886004102021NULL
17691Lyon BellecourFranceArthur Martin4894521232017NULL
177010Chengdu JinjiangChinaTao Li52924437102020NULL
17712Paris La DéfenseFranceArthur Martin5451098712019NULL
17724Paris LouvreFranceHugo Laurent53050608122020NULL
17732Marseille CanebièreFranceLouis Simon4672209432017NULL
17741Paris OpéraFranceCamille Thomas4304542762020NULL
17751Nantes CommerceFranceLouis Simon4022306562018NULL
17771Nantes CommerceFranceGabriel Petit4919758262021NULL
178033Bergen BryggenNorwayJakob Pedersen55878304122020NULL
17814Strasbourg KléberFranceJules Moreau5481222292017Apple Pay
17833Toulouse CapitoleFranceZoé Bernard4708358192019Apple Pay
178418Frankfurt TaunusanlageGermanyHannah Koch4608795282021NULL
17857Denver Union StationUnited StatesHarper Johnson5517236072019NULL
17876Atlanta MidtownUnited StatesNoah Williams3793371432020NULL
178835Montréal Ville-MarieCanadaBenjamin Smith4132278412021NULL
178927Brisbane Queen StAustraliaMia Brown5194931152017NULL
179016Madrid Gran VíaSpainMartina Gómez5353032212021NULL
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;