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,901–1,925 of 4,762

card_payment, page 77 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
22595Chicago LoopUnited StatesHarper Taylor5538149812018NULL
226013Bristol Corn StUnited KingdomSophie Walker52513275122021NULL
22611Lyon BellecourFranceManon Dubois4739496672022NULL
22625Chicago LoopUnited StatesEthan Taylor4095190562022NULL
226313Edinburgh Princes StUnited KingdomOliver Wilson4523009632019NULL
22641Paris OpéraFranceLouis Bernard5494222162021NULL
22652Paris La DéfenseFranceZoé Bernard4124369412021NULL
22663Rennes RépubliqueFranceLéa Durand4485821832018Apple Pay
226710Hangzhou XihuChinaHao Zhou4367217212020NULL
22685Chicago LoopUnited StatesLogan Brown44910319112018NULL
22702Marseille CanebièreFranceZoé Bernard5182276262020NULL
22712Marseille CanebièreFranceJules Lefebvre52750889122019NULL
227227Sydney Martin PlaceAustraliaNoah Jones4069517932021NULL
227327Sydney Martin PlaceAustraliaNoah Jones55756838122020NULL
227427Sydney Martin PlaceAustraliaOliver Kelly4849961372019NULL
227527Sydney Martin PlaceAustraliaNoah Brown5315249752019NULL
227626WoolloomoolooAustraliaIsla Ryan4415234472021Google Pay
22771Nantes CommerceFranceChloé Bernard4946443962022NULL
22786Atlanta MidtownUnited StatesLiam Miller46456798102021Apple Pay
22797Seattle Pike PlaceUnited StatesLiam Miller5213608312018NULL
22804Paris LouvreFranceJules Durand41219867112018NULL
22811Paris OpéraFranceArthur Dubois5200594332019NULL
22824Strasbourg KléberFranceLucas Dubois4376794072018NULL
228327Sydney Martin PlaceAustraliaJack Brown5395200152020NULL
22842Marseille CanebièreFranceLouis Bernard52696279112019NULL
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;