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,101–1,125 of 4,762

card_payment, page 45 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
132719München MarienplatzGermanyMia Koch4154383992020NULL
13291Paris OpéraFranceChloé Simon4782234592020NULL
13306San Francisco Market StUnited StatesAva Garcia4350434032018NULL
133112Leeds BriggateUnited KingdomOliver Williams5524896852019NULL
133224Busan SeomyeonSouth KoreaHa-eun Park4492523992018NULL
133329Utrecht CentrumNetherlandsDaan de Jong4297795492018NULL
133429Eindhoven StratumseindNetherlandsDaan de Jong4529598842021NULL
133511London Canary WharfUnited KingdomOliver Williams3782805752018NULL
13365Manhattan MidtownUnited StatesElla Brown53617664122018NULL
133711London Canary WharfUnited KingdomJack Wilson46179026122021NULL
13382Paris La DéfenseFranceZoé Leroy4016335312020NULL
133915Roma TerminiItalyMatteo Greco53200679122020NULL
134032Stockholm Sergels TorgSwedenMaja Johansson4961593022017NULL
134318Berlin Unter den LindenGermanyEmma Koch5238700442019NULL
134429Utrecht CentrumNetherlandsLucas Jansen4973836392019NULL
134527Brisbane Queen StAustraliaWilliam Kelly45283710122020NULL
134630Moscow TverskayaRussiaAnastasia Vasiliev4053581662020NULL
13476Boston Back BayUnited StatesAva Miller3732750932019NULL
13485Austin DowntownUnited StatesMason Garcia4215464882020NULL
134917Bilbao AbandoSpainSofía González5381842492019NULL
13505Manhattan MidtownUnited StatesLogan Smith4811082722020NULL
13519Shenzhen FutianChinaXin Yang6296892822020NULL
13528Shanghai PudongChinaTao Liu6252865562017NULL
13543Bordeaux ChartronsFranceInès Petit4533913032019Apple Pay
135526Melbourne Collins StAustraliaWilliam Jones4159870012017NULL
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;