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,476–3,500 of 4,762

card_payment, page 140 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
40281Nantes CommerceFranceChloé Simon4455288922021NULL
402932Göteborg AvenynSwedenAlice Eriksson4244683532024Apple Pay
403010Hangzhou XihuChinaMin Chen4761745772023NULL
403110Hangzhou XihuChinaFang Zhou6236106922021NULL
40321Nantes CommerceFranceZoé Moreau4566237882024NULL
403332Göteborg AvenynSwedenAlice Eriksson4054803462022Google Pay
40343Bordeaux ChartronsFranceCamille Dubois46583342102021NULL
40352Marseille CanebièreFranceManon Dubois4059166122023NULL
403721Belo Horizonte SavassiBrazilValentina Silva4379508682021NULL
40382Paris La DéfenseFranceJules Martin5250991682020NULL
40396San Francisco Market StUnited StatesMason Miller40704269102020NULL
40401Nantes CommerceFranceArthur Leroy45277683122022NULL
404233Bergen BryggenNorwayEmil Andersen55493441102023NULL
40436Boston Back BayUnited StatesLogan Wilson4517044782020NULL
40444Strasbourg KléberFranceLéa Thomas5266680962020NULL
40454Strasbourg KléberFranceLucas Leroy4492456742023NULL
404617Barcelona EixampleSpainPablo Rodríguez4275761322020NULL
40473Bordeaux ChartronsFranceArthur Bernard4111783242021NULL
40486Boston Back BayUnited StatesLiam Smith4009573312022Google Pay
40497Seattle Pike PlaceUnited StatesEmma Moore43734666112021NULL
40507Seattle Pike PlaceUnited StatesHarper Wilson4521340212021Google Pay
405121Belo Horizonte SavassiBrazilHelena Silva40747821102023NULL
405210Chengdu JinjiangChinaLei Wang5156110852020NULL
405318Frankfurt TaunusanlageGermanyMia Schmidt4244781152022NULL
405418Frankfurt TaunusanlageGermanyMia Schmidt5241793592021Google 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;