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 2,226–2,250 of 4,762

card_payment, page 90 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
263516Madrid Gran VíaSpainMateo Gómez5170120042021NULL
26363Toulouse CapitoleFranceJules Laurent49990322102019NULL
26374Strasbourg KléberFranceLucas Moreau5437367772021NULL
263830Saint Petersburg NevskyRussiaDmitry Petrov5476417432020NULL
263918Berlin Unter den LindenGermanyBen Wagner4189065282022NULL
264110Chengdu JinjiangChinaYan Yang6287007592018NULL
26425Chicago LoopUnited StatesHarper Wilson5240492992018NULL
26435Austin DowntownUnited StatesNoah Williams3719841632021NULL
26475Chicago LoopUnited StatesHarper Garcia3784052712021NULL
264819Hamburg JungfernstiegGermanyLea Weber4619752262018NULL
26497Denver Union StationUnited StatesAva Johnson47585239122019NULL
26506San Francisco Market StUnited StatesMia Williams4721641092018NULL
265117Bilbao AbandoSpainMateo González5265358962022NULL
26533Toulouse CapitoleFranceHugo Laurent4720234422022Google Pay
26541Lyon BellecourFranceLucas Bernard4573726612020NULL
26555Manhattan MidtownUnited StatesNoah Johnson5548789042019NULL
26567Denver Union StationUnited StatesMason Johnson4619976272019Google Pay
265723Kyoto ShijoJapanSota Nakamura40380398102019NULL
265822Tokyo MarunouchiJapanSota Nakamura5388597672018NULL
265935Toronto Bay StCanadaOlivia Gagnon5506539462021Apple Pay
26605Manhattan MidtownUnited StatesJames Johnson4717818032022NULL
266112Leeds BriggateUnited KingdomAlfie Wright42792450112018NULL
26626San Francisco Market StUnited StatesEmma Garcia4284960562018NULL
266324Busan SeomyeonSouth KoreaSeo-jun Kim4129517132022NULL
266519München MarienplatzGermanyLina Wagner4826354262019NULL
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;