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,201–1,225 of 4,762

card_payment, page 49 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
14444Paris LouvreFranceHugo Leroy4341086472018NULL
144512Birmingham New StUnited KingdomAmelia Walker4307820712020NULL
14466Atlanta MidtownUnited StatesMia Wilson5406499972021NULL
14479Shenzhen FutianChinaXin Wu62783314112018NULL
14481Lyon BellecourFranceZoé Laurent5345127652021Apple Pay
14496Atlanta MidtownUnited StatesMia Jones4631827982019NULL
14507Denver Union StationUnited StatesEthan Johnson3718934382017NULL
14527Denver Union StationUnited StatesLogan Davis4761297732018Google Pay
14535Austin DowntownUnited StatesMason Garcia4279775792017NULL
145521Brasília Asa SulBrazilLaura Alves5149652582019NULL
145615Roma TerminiItalyGinevra Esposito53107967122017NULL
14577Seattle Pike PlaceUnited StatesEmma Miller37038698122021NULL
14584Paris LouvreFranceManon Laurent55549156102020NULL
145918Berlin Unter den LindenGermanyFinn Weber55801736112017NULL
14601Paris OpéraFranceHugo Moreau48196927112020NULL
146127Sydney Martin PlaceAustraliaNoah Smith4134671222017NULL
146216Sevilla TrianaSpainMateo González45946296102017NULL
146316Madrid Gran VíaSpainPablo Sánchez5585510532019NULL
14647Denver Union StationUnited StatesMia Wilson3766304622020NULL
146518Berlin Unter den LindenGermanyBen Fischer54851250102020NULL
146610Hangzhou XihuChinaWei Wu4874102512020NULL
14677Denver Union StationUnited StatesLogan Garcia4300345112021NULL
14688Shanghai PudongChinaWei Zhou43657622112021NULL
14694Paris LouvreFranceJules Martin4960397542020NULL
147021Belo Horizonte SavassiBrazilHeitor Pereira46149647102017NULL
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;