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 2,976–3,000 of 4,762

card_payment, page 120 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
346627Brisbane Queen StAustraliaAmelia Ryan4650093312020NULL
34672Paris La DéfenseFranceManon Lefebvre4481666162022NULL
34685Austin DowntownUnited StatesJames Brown4005533492021NULL
34698Shanghai PudongChinaLei Huang6296788382022NULL
347010Chengdu JinjiangChinaTao Huang6238426062023NULL
347116Madrid Gran VíaSpainPablo Martínez5261694442021NULL
347215Roma TerminiItalySofia Rossi4480015362019NULL
347316Sevilla TrianaSpainMateo Martín41780608122022NULL
34749Shenzhen FutianChinaXin Yang4576550762019Apple Pay
34768Shanghai PudongChinaLei Huang4376689182020NULL
34772Marseille CanebièreFranceZoé Petit4219775392023NULL
347815Firenze Santa Maria NovellaItalyGiulia Ricci5263932812019NULL
347920Rio CentroBrazilMiguel Pereira5566331342022NULL
34801Paris OpéraFranceInès Durand4310218712023Google Pay
348217Bilbao AbandoSpainHugo García4185511652022NULL
348315Roma TerminiItalyAlessandro Colombo4183257392020Google Pay
34842Marseille CanebièreFranceManon Durand5173226712021NULL
34851Lyon BellecourFranceChloé Durand4114697252021NULL
34862Paris La DéfenseFranceChloé Durand5245963592019NULL
34878Shanghai PudongChinaXin Li6222967952020NULL
348827Brisbane Queen StAustraliaAmelia Smith5260747722020Apple Pay
348919Hamburg JungfernstiegGermanyLea Meyer5122591182019NULL
349021Brasília Asa SulBrazilLaura Silva44037796112020NULL
34917Seattle Pike PlaceUnited StatesMason Wilson42538731122022Google Pay
34931Nantes CommerceFranceZoé Durand5207737262022NULL
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;