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,676–3,700 of 4,762

card_payment, page 148 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
42407Seattle Pike PlaceUnited StatesElla Garcia5311326752023NULL
424121Brasília Asa SulBrazilArthur Alves5387976052021NULL
42423Toulouse CapitoleFranceLéa Petit4404099142024NULL
424314Milano DuomoItalyMatteo Romano4574766932022NULL
424418Berlin Unter den LindenGermanyLea Schmidt54001923112021NULL
42452Paris La DéfenseFranceHugo Leroy4424934122021NULL
42461Paris OpéraFranceChloé Lefebvre5157610332020NULL
42474Paris LouvreFranceJules Martin54219140102024NULL
424832Stockholm Sergels TorgSwedenMaja Larsson5466877422023Google Pay
42494Strasbourg KléberFranceLucas Dubois53823306122022NULL
425020Rio CentroBrazilMiguel Alves4793004842024NULL
425122Osaka UmedaJapanHina Ito41236472112021NULL
42522Paris La DéfenseFranceLucas Dubois4727820452024NULL
425321Belo Horizonte SavassiBrazilHelena Oliveira4050779522020NULL
425414Torino CentroItalyMatteo Rossi4877315332024NULL
42556Atlanta MidtownUnited StatesOlivia Anderson5139094282021NULL
42578Beijing XidanChinaTao Zhou5131985962022Apple Pay
42586Atlanta MidtownUnited StatesLogan Anderson4103412912024NULL
42591Nantes CommerceFranceLucas Dubois54278008122021NULL
42614Paris LouvreFranceLucas Robert4404166552023NULL
42622Marseille CanebièreFranceCamille Simon4717615032023NULL
42633Bordeaux ChartronsFranceArthur Thomas5157402432024NULL
42649Guangzhou TianheChinaFang Zhang6208031832022NULL
42654Strasbourg KléberFranceLéa Lefebvre5124941942024Apple Pay
42669Shenzhen FutianChinaFang Zhang5134321762023NULL
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;