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 4,076–4,100 of 4,762

card_payment, page 164 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
46638Shanghai PudongChinaWei Zhang5121162142021Google Pay
466417Barcelona EixampleSpainHugo López4389137892023NULL
466516Sevilla TrianaSpainValeria Sánchez4535802382021NULL
46662Marseille CanebièreFranceCamille Bernard4057891622022NULL
466712Birmingham New StUnited KingdomJack Johnson5142105072023NULL
466819Hamburg JungfernstiegGermanyEmma Müller4430654722023NULL
46705Chicago LoopUnited StatesMason Garcia47793666122021NULL
467126Adelaide Rundle MallAustraliaIsla Jones4896384172023NULL
46721Lyon BellecourFranceCamille Robert45181213112021NULL
467321Belo Horizonte SavassiBrazilAlice Rodrigues5352314412023NULL
467416Madrid Gran VíaSpainSofía Martín4569982292022NULL
46757Seattle Pike PlaceUnited StatesHarper Anderson4786745822020NULL
467612Leeds BriggateUnited KingdomAmelia Taylor4093091782022Google Pay
46771Nantes CommerceFranceLucas Simon62950945112023NULL
467811Manchester Market StUnited KingdomGeorge Brown4027761372024NULL
46795Chicago LoopUnited StatesHarper Miller55855980122020Google Pay
46804Paris LouvreFranceLucas Leroy49090704122021NULL
46813Toulouse CapitoleFranceLéa Thomas4889764122024NULL
468217Barcelona EixampleSpainLucía González4289494772020NULL
46833Toulouse CapitoleFranceCamille Durand5343740132024NULL
46846San Francisco Market StUnited StatesElla Miller4607625762020NULL
46857Denver Union StationUnited StatesHarper Miller4717328672020NULL
468630Moscow TverskayaRussiaIvan Smirnov42528787102022NULL
468718Berlin Unter den LindenGermanyPaul Wagner4772253012020Google Pay
46885Manhattan MidtownUnited StatesJames Smith46475161122022NULL
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;