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 1,701–1,725 of 4,762

card_payment, page 69 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
202327Sydney Martin PlaceAustraliaCharlotte Kelly4001636172021NULL
202416Madrid Gran VíaSpainÁlvaro Martín55724430102021NULL
202532Göteborg AvenynSwedenAstrid Larsson5443394432022NULL
202616Madrid Gran VíaSpainÁlvaro Sánchez47290329102021NULL
202714Torino CentroItalyMatteo Colombo5204024482022NULL
202826WoolloomoolooAustraliaWilliam Kelly3723730282020NULL
20295Austin DowntownUnited StatesOlivia Davis5443819732019NULL
203126WoolloomoolooAustraliaWilliam Kelly4178493772022NULL
20323Toulouse CapitoleFranceArthur Lefebvre5428872762020NULL
20338Beijing XidanChinaHao Xu5324756842018NULL
203419Hamburg JungfernstiegGermanyLea Weber43498045122022NULL
20359Shenzhen FutianChinaYang Zhang4533993862019NULL
203617Bilbao AbandoSpainValeria Rodríguez53424892122018NULL
203718Frankfurt TaunusanlageGermanyFinn Koch4035177992019NULL
20385Chicago LoopUnited StatesMason Jones4509360212022NULL
203926WoolloomoolooAustraliaIsla Smith4115687782018NULL
204016Madrid Gran VíaSpainHugo Sánchez45714230122020Apple Pay
204127Brisbane Queen StAustraliaOliver Brown4152439552022NULL
20422Marseille CanebièreFranceGabriel Robert4062201472020NULL
204314Milano DuomoItalySofia Ricci4953053272019NULL
204428Rotterdam CoolsingelNetherlandsJulia de Vries4149796392022Google Pay
204530Moscow TverskayaRussiaMaria Kuznetsov41087787112019NULL
204615Roma TerminiItalyAurora Colombo55530655112018NULL
204711London Canary WharfUnited KingdomJack Smith42907507112019NULL
204830Saint Petersburg NevskyRussiaAnna Kuznetsov4310842372019NULL
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;