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,401–1,425 of 4,762

card_payment, page 57 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
16737Denver Union StationUnited StatesNoah Moore3764710952018NULL
16748Shanghai PudongChinaYang Liu6292247872020NULL
167532Göteborg AvenynSwedenMaja Nilsson55144015102019Apple Pay
16766Boston Back BayUnited StatesMia Taylor5446782152019NULL
16779Guangzhou TianheChinaTao Chen4805419632019NULL
167812Leeds BriggateUnited KingdomAmelia Davies4918322762017NULL
167916Madrid Gran VíaSpainSofía García43880469112017NULL
168019München MarienplatzGermanyLea Schneider4847824212020Apple Pay
168119Hamburg JungfernstiegGermanyLina Hoffmann4057090752020NULL
168217Barcelona EixampleSpainPablo Martínez47921343122018NULL
168334Tampere HämeenkatuFinlandHelmi Korhonen46536806102021NULL
168415Firenze Santa Maria NovellaItalyLorenzo Greco4746305532021NULL
16852Lille Grand PlaceFranceJules Durand41785299122019NULL
16863Bordeaux ChartronsFranceZoé Lefebvre41906322112019NULL
16879Shenzhen FutianChinaYang Zhou62600369102017NULL
16883Bordeaux ChartronsFranceGabriel Simon4159912442021Google Pay
168911London Canary WharfUnited KingdomIsla Wilson5328980432018NULL
16903Toulouse CapitoleFranceLéa Robert55776482122020NULL
169118Frankfurt TaunusanlageGermanyPaul Koch5531026912021NULL
16923Rennes RépubliqueFranceLouis Petit4816128132019NULL
16932Lille Grand PlaceFranceArthur Thomas5509697172020NULL
16946San Francisco Market StUnited StatesMason Davis4178870652019NULL
169531Warszawa ŚródmieściePolandJan Nowak4634251382017NULL
169624Seoul YeouidoSouth KoreaDo-yun Yoon5499992422017NULL
169724Seoul YeouidoSouth KoreaJi-woo Kang44489922102018NULL
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;