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,351–3,375 of 4,762

card_payment, page 135 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
38876Boston Back BayUnited StatesMason Jones4162689272019NULL
38885Chicago LoopUnited StatesMason Davis4069029312020NULL
38894Paris LouvreFranceHugo Thomas5203765032022NULL
38901Nantes CommerceFranceLucas Dubois5372113992023NULL
38911Lyon BellecourFranceArthur Petit4304238842022NULL
38923Bordeaux ChartronsFranceLouis Petit4275036352019Apple Pay
389315Roma TerminiItalyGiulia Rossi4956892512023NULL
38941Nantes CommerceFranceLucas Bernard5125686772019NULL
38953Bordeaux ChartronsFranceZoé Durand55687394112023NULL
38961Paris OpéraFranceInès Bernard4053377722019NULL
38973Toulouse CapitoleFranceCamille Moreau4121549122021NULL
38983Rennes RépubliqueFranceCamille Moreau5294922512019NULL
38991Paris OpéraFranceHugo Robert4041480032021NULL
39007Seattle Pike PlaceUnited StatesOlivia Moore4046171542019NULL
39026San Francisco Market StUnited StatesHarper Wilson5204157262020Apple Pay
390324Seoul YeouidoSouth KoreaHa-eun Park5261410512023NULL
39044Strasbourg KléberFranceArthur Durand62712341102023NULL
390518Frankfurt TaunusanlageGermanyLeon Hoffmann4779762492019NULL
39064Strasbourg KléberFranceArthur Bernard5436246772020NULL
39071Paris OpéraFranceLouis Robert4786257492020NULL
39105Chicago LoopUnited StatesMia Taylor5285791062023NULL
39117Denver Union StationUnited StatesAva Smith4742440352020Apple Pay
391220São Paulo PaulistaBrazilMiguel Oliveira5420683882022NULL
391316Sevilla TrianaSpainMateo García4965768072022NULL
391419Hamburg JungfernstiegGermanyLeon Schneider5566250242020NULL
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;