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,126–4,150 of 4,762

card_payment, page 166 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
471613Edinburgh Princes StUnited KingdomOliver Taylor5362754232023NULL
47173Toulouse CapitoleFranceJules Martin5172077662024Apple Pay
471833Bergen BryggenNorwayEmil Nilsen5462832212021Apple Pay
471935Toronto Bay StCanadaEmma Tremblay4581947752021NULL
472010Chengdu JinjiangChinaMin Zhang62299709102024NULL
472110Hangzhou XihuChinaYan Xu4850616582024NULL
472224Seoul YeouidoSouth KoreaMin-jun Kang5582146242024Google Pay
47232Lille Grand PlaceFranceCamille Thomas4471456282022NULL
472433Oslo BjørvikaNorwayNora Nilsen4268907732021NULL
472621Belo Horizonte SavassiBrazilMiguel Oliveira4487905262022Google Pay
47274Strasbourg KléberFranceArthur Bernard4518580052022NULL
47281Lyon BellecourFranceZoé Leroy4089264072023NULL
472925Seoul GangnamSouth KoreaJi-woo Choi5352033432021Google Pay
473132Stockholm Sergels TorgSwedenAlice Larsson5522553392023NULL
47325Manhattan MidtownUnited StatesEmma Davis42887934112024NULL
47339Shenzhen FutianChinaHao Wu6200206182021NULL
473526Melbourne Collins StAustraliaAmelia Kelly3710494742021NULL
473714Milano DuomoItalySofia Ricci4410701032021NULL
473820Rio CentroBrazilMiguel Oliveira4980499322020Google Pay
47395Chicago LoopUnited StatesElla Miller4230155682021NULL
474017Barcelona EixampleSpainPablo González5534002462024NULL
47417Seattle Pike PlaceUnited StatesNoah Smith40803493102023NULL
474218Berlin Unter den LindenGermanyLina Schneider4274093362022Apple Pay
47452Marseille CanebièreFranceLucas Leroy40609913122021NULL
47462Paris La DéfenseFranceLéa Thomas4427742222022NULL
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;