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 3,126–3,150 of 4,762

card_payment, page 126 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
36306San Francisco Market StUnited StatesAva Moore5377148852019NULL
36317Seattle Pike PlaceUnited StatesAva Wilson4558350712019Google Pay
363211Manchester Market StUnited KingdomHarry Smith4317991062023NULL
36332Marseille CanebièreFranceGabriel Lefebvre51567466102020NULL
36342Paris La DéfenseFranceJules Simon5483531592022NULL
36353Bordeaux ChartronsFranceLucas Robert4834016452022NULL
363610Chengdu JinjiangChinaLin Yang40196124122020NULL
363930Moscow TverskayaRussiaIvan Popov4303041062020NULL
36406Boston Back BayUnited StatesLiam Smith5192621432022NULL
36414Paris LouvreFranceJules Durand4649274652019NULL
364215Roma TerminiItalyGiulia Colombo55574550122019Apple Pay
364315Firenze Santa Maria NovellaItalyLeonardo Ferrari54152509122023NULL
36477Denver Union StationUnited StatesAva Davis51007257112023NULL
365035Toronto Bay StCanadaNoah Smith4309544952019NULL
36518Shanghai PudongChinaJing Wang6270633332022NULL
365212Birmingham New StUnited KingdomAlfie Taylor3703978452021NULL
36531Paris OpéraFranceZoé Simon5191385552019NULL
365415Firenze Santa Maria NovellaItalyFrancesco Ricci4636239132022NULL
36558Shanghai PudongChinaHao Wang4369974672021NULL
36564Paris LouvreFranceCamille Bernard5546332632023NULL
36586Atlanta MidtownUnited StatesNoah Miller41446108102022NULL
36597Denver Union StationUnited StatesNoah Miller4989406222023NULL
36607Seattle Pike PlaceUnited StatesLiam Garcia4855381592020NULL
36615Chicago LoopUnited StatesLogan Taylor4229598942021Google Pay
366234Tampere HämeenkatuFinlandVäinö Mäkinen4887528122019Apple Pay
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;