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,276–3,300 of 4,762

card_payment, page 132 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
38045Chicago LoopUnited StatesJames Williams4260830522021NULL
38066Boston Back BayUnited StatesLiam Garcia5432276612023NULL
38078Shanghai PudongChinaHao Huang62378242112019NULL
380829Utrecht CentrumNetherlandsNoah de Jong48094003122019Google Pay
38097Seattle Pike PlaceUnited StatesMason Johnson48533118112022NULL
381020Rio CentroBrazilValentina Rodrigues54686353112022NULL
381114Milano DuomoItalyAurora Russo5327112022019Apple Pay
381214Torino CentroItalyGiulia Ricci4057450682020NULL
381321Brasília Asa SulBrazilHeitor Oliveira47494354112020NULL
38149Guangzhou TianheChinaFang Huang4633442322019NULL
38153Bordeaux ChartronsFranceCamille Simon5367203152023NULL
381621Belo Horizonte SavassiBrazilAlice Alves5197479842019Apple Pay
38172Paris La DéfenseFranceHugo Simon5193730172021NULL
38185Chicago LoopUnited StatesHarper Wilson5376855532019Apple Pay
381914Torino CentroItalyAlessandro Esposito5590294622023NULL
382032Stockholm Sergels TorgSwedenAlice Andersson41905647102019NULL
382132Stockholm Sergels TorgSwedenHugo Johansson53519173102020NULL
38229Shenzhen FutianChinaHao Huang6298863372021NULL
38233Bordeaux ChartronsFranceChloé Lefebvre4709158222020NULL
38247Seattle Pike PlaceUnited StatesMason Garcia3762979082023Apple Pay
38251Lyon BellecourFranceZoé Martin5417413392023Apple Pay
382623Kyoto ShijoJapanRen Tanaka35006352112023NULL
38272Paris La DéfenseFranceHugo Leroy55361987102021Apple Pay
38281Lyon BellecourFranceInès Petit4429042882023Google Pay
382915Firenze Santa Maria NovellaItalyBeatrice Marino4416369992023NULL
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;