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,051–3,075 of 4,762

card_payment, page 123 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
35517Seattle Pike PlaceUnited StatesAva Johnson4627142632019Apple Pay
355215Firenze Santa Maria NovellaItalyAlessandro Greco4334774972020NULL
355313Bristol Corn StUnited KingdomGeorge Wilson41939733122019NULL
35542Paris La DéfenseFranceCamille Durand4772885392023NULL
35564Strasbourg KléberFranceLouis Martin4809258762021NULL
35574Strasbourg KléberFranceManon Leroy5296078162019Google Pay
35581Paris OpéraFranceCamille Dubois5233110962021NULL
35599Shenzhen FutianChinaJun Wang6211312232021NULL
356031Warszawa ŚródmieściePolandJakub Wiśniewski4999138782023NULL
356134Helsinki AleksanterinkatuFinlandOliver Mäkelä5364861732020NULL
356234Tampere HämeenkatuFinlandVäinö Heikkinen4709745852022Google Pay
35639Shenzhen FutianChinaWei Wu5528846272021NULL
35644Paris LouvreFranceChloé Simon47498544102023Google Pay
35652Marseille CanebièreFranceCamille Martin4137164152022NULL
35663Bordeaux ChartronsFranceManon Laurent48238909102019Apple Pay
35672Lille Grand PlaceFranceCamille Petit4181281682023NULL
356814Milano DuomoItalyAlessandro Greco51786624122023NULL
356935Toronto Bay StCanadaOlivia Roy43053466122022NULL
357024Seoul YeouidoSouth KoreaHa-eun Yoon5164770972021NULL
357110Chengdu JinjiangChinaXin Wu6270432042021NULL
357214Torino CentroItalyAlessandro Romano52943869112021Apple Pay
357310Hangzhou XihuChinaXin Wu4049133912020NULL
35742Lille Grand PlaceFranceArthur Dubois51254433102023NULL
357527Brisbane Queen StAustraliaCharlotte Ryan51126726112023NULL
357627Sydney Martin PlaceAustraliaOliver Nguyen47111640112022Apple 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;