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 4,351–4,375 of 4,762

card_payment, page 175 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
496329Eindhoven StratumseindNetherlandsTess Smit40321587112021NULL
496428Rotterdam CoolsingelNetherlandsJulia de Jong49527828102023NULL
496510Chengdu JinjiangChinaTao Liu5236613142020NULL
49673Toulouse CapitoleFranceManon Dubois4882509792022Apple Pay
496826Adelaide Rundle MallAustraliaAmelia Nguyen4659104222023NULL
496919Hamburg JungfernstiegGermanyElias Weber4124617662020NULL
497113Bristol Corn StUnited KingdomAmelia Jones4801487242021NULL
497221Belo Horizonte SavassiBrazilMiguel Rodrigues4933040962021NULL
49731Lyon BellecourFranceGabriel Robert5442085642021NULL
49742Paris La DéfenseFranceLéa Thomas5415274882022NULL
49755Chicago LoopUnited StatesOlivia Garcia4304284782021NULL
49769Guangzhou TianheChinaJing Chen6298234432022NULL
49779Shenzhen FutianChinaYan Chen6297458122024NULL
49784Strasbourg KléberFranceInès Dubois4568229662023NULL
49799Shenzhen FutianChinaYang Sun5256789392021NULL
498021Belo Horizonte SavassiBrazilLaura Silva52762960112020NULL
498110Chengdu JinjiangChinaYang Sun53813442122021NULL
498235Toronto Bay StCanadaEmma Wilson43474527102022NULL
49831Lyon BellecourFranceChloé Martin4364071652020Google Pay
49842Marseille CanebièreFranceLucas Simon4900757852023NULL
49852Paris La DéfenseFranceChloé Martin4315640382024NULL
498627Brisbane Queen StAustraliaIsla Kelly4141202392023NULL
498810Chengdu JinjiangChinaXin Yang4031441742021NULL
49894Paris LouvreFranceCamille Lefebvre4528616192024NULL
49906San Francisco Market StUnited StatesLiam Anderson4518648232024NULL
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;