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 576–600 of 4,762

card_payment, page 24 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
7057Denver Union StationUnited StatesAva Taylor4185552862017NULL
7062Lille Grand PlaceFranceHugo Thomas4141997672017NULL
7073Bordeaux ChartronsFranceLéa Moreau4634328712017NULL
7087Denver Union StationUnited StatesLiam Jones41409634112017NULL
7091Lyon BellecourFranceZoé Durand42684257122017NULL
71035Toronto Bay StCanadaChloé Martin41435590102020NULL
71135Montréal Ville-MarieCanadaChloé Martin4183300972016NULL
71218Berlin Unter den LindenGermanyLina Meyer4955072232017NULL
7132Marseille CanebièreFranceCamille Simon5195362272019NULL
71535Montréal Ville-MarieCanadaWilliam Roy4636605652019NULL
71619München MarienplatzGermanyLeon Weber4106687422020NULL
71718Frankfurt TaunusanlageGermanyHannah Becker4288895292016NULL
7183Rennes RépubliqueFranceHugo Laurent5218527512016NULL
7207Denver Union StationUnited StatesNoah Moore4075819172020NULL
72132Göteborg AvenynSwedenMaja Karlsson5438551232018NULL
72211Manchester Market StUnited KingdomAmelia Wilson4669497892018NULL
7237Denver Union StationUnited StatesEthan Moore5568722572018NULL
7245Manhattan MidtownUnited StatesEthan Moore4742249512017Google Pay
7255Austin DowntownUnited StatesAva Smith5318475452017NULL
7267Denver Union StationUnited StatesNoah Moore5590459662017NULL
7276San Francisco Market StUnited StatesHarper Miller4286821142020NULL
7286Atlanta MidtownUnited StatesElla Brown4007386492016NULL
7292Lille Grand PlaceFranceInès Robert4855330712020NULL
7313Bordeaux ChartronsFranceZoé Thomas5300723842020Google Pay
73217Barcelona EixampleSpainMateo García4022061312018NULL
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;