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,176–2,200 of 4,762

card_payment, page 88 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
25766San Francisco Market StUnited StatesMason Wilson53089084102019NULL
25781Lyon BellecourFranceArthur Petit49456210112018NULL
25794Paris LouvreFranceManon Petit4691113632022NULL
258012Birmingham New StUnited KingdomLily Patel47616791112019NULL
258111London Canary WharfUnited KingdomAva Johnson4962730592021NULL
258316Sevilla TrianaSpainMartina Martínez4147233542022NULL
25845Manhattan MidtownUnited StatesMason Smith52751906112022NULL
258515Roma TerminiItalyAlessandro Rossi4326579562022NULL
25863Rennes RépubliqueFranceArthur Lefebvre49885451112020NULL
25872Marseille CanebièreFranceZoé Thomas5305426492020NULL
25886Boston Back BayUnited StatesAva Williams4028617272021NULL
258916Sevilla TrianaSpainMartina Rodríguez52005633122021NULL
25909Shenzhen FutianChinaYang Zhang5369455452019NULL
25918Shanghai PudongChinaJing Huang62543423112020Apple Pay
25929Guangzhou TianheChinaJing Huang5407920272018Apple Pay
259331Kraków RynekPolandZuzanna Wójcik5464935532019NULL
259514Milano DuomoItalyGiulia Romano4995006342020NULL
25964Paris LouvreFranceCamille Durand40415460112021NULL
25975Austin DowntownUnited StatesMason Wilson41858938112019NULL
259915Firenze Santa Maria NovellaItalyGinevra Bianchi47373172122020NULL
260016Madrid Gran VíaSpainPablo García4807549522019NULL
26015Chicago LoopUnited StatesMason Jones55852093122018NULL
260224Busan SeomyeonSouth KoreaMin-jun Kang5480680442022NULL
260317Barcelona EixampleSpainMateo Martín4087592192022NULL
26044Strasbourg KléberFranceLouis Dubois4164797632020NULL
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;