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,876–2,900 of 4,762

card_payment, page 116 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
33492Paris La DéfenseFranceCamille Robert42137699112020Apple Pay
335025Seoul GangnamSouth KoreaHa-eun Cho5178819512022NULL
33512Marseille CanebièreFranceJules Bernard46077430102020NULL
335228Rotterdam CoolsingelNetherlandsJulia de Jong5366123282019Apple Pay
33537Seattle Pike PlaceUnited StatesJames Williams41829231102019NULL
335410Hangzhou XihuChinaHao Wu49777773102019NULL
33556San Francisco Market StUnited StatesAva Moore4198533792023NULL
33566San Francisco Market StUnited StatesLogan Smith4007060872019Apple Pay
335710Chengdu JinjiangChinaLei Zhou62141799112020Apple Pay
33586Atlanta MidtownUnited StatesMason Miller5404282022020Apple Pay
335913Bristol Corn StUnited KingdomJack Smith4855685552019NULL
336012Leeds BriggateUnited KingdomJack Smith5210973212020NULL
336117Barcelona EixampleSpainLucía Sánchez5141790652019NULL
336216Sevilla TrianaSpainSofía Sánchez46661402122021NULL
336333Oslo BjørvikaNorwayFilip Pedersen54142364112022NULL
336427Sydney Martin PlaceAustraliaJack Ryan43178136122022NULL
33658Shanghai PudongChinaYan Wu4329933812021NULL
33668Beijing XidanChinaWei Zhang41765240112022NULL
336715Firenze Santa Maria NovellaItalyLorenzo Bianchi53727499122019NULL
336818Berlin Unter den LindenGermanyElias Wagner48003518122019NULL
33691Paris OpéraFranceZoé Martin5430376652020NULL
337035Montréal Ville-MarieCanadaNoah Roy4347948192019NULL
337120Rio CentroBrazilArthur Rodrigues4662016792020NULL
33721Paris OpéraFranceGabriel Bernard4741441232020NULL
33741Nantes CommerceFranceJules Leroy4786635362022NULL
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;