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,776–1,800 of 4,762

card_payment, page 72 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
210632Stockholm Sergels TorgSwedenAlice Persson5175653352018NULL
210726WoolloomoolooAustraliaOliver Williams4949428252020NULL
21088Shanghai PudongChinaWei Zhang6282197082020NULL
210916Sevilla TrianaSpainÁlvaro Martínez5366503322021NULL
21106San Francisco Market StUnited StatesMia Garcia4200499242019NULL
211110Chengdu JinjiangChinaJing Yang5414244222022NULL
21122Paris La DéfenseFranceCamille Simon4459108692020NULL
21134Paris LouvreFranceLouis Durand54317236122019NULL
21143Toulouse CapitoleFranceZoé Bernard5508119352020NULL
211514Milano DuomoItalyBeatrice Russo4520390222022NULL
211614Torino CentroItalyBeatrice Russo4192656822022NULL
21187Seattle Pike PlaceUnited StatesMason Jones54890901112018Google Pay
211918Berlin Unter den LindenGermanyPaul Wagner5306160182018NULL
212021Belo Horizonte SavassiBrazilHelena Oliveira5251657582020NULL
212120São Paulo PaulistaBrazilHelena Oliveira5567886472020NULL
212213Bristol Corn StUnited KingdomAlfie Johnson44936564122018NULL
21233Rennes RépubliqueFranceChloé Leroy52476831102021NULL
21241Nantes CommerceFranceChloé Petit5496042532018NULL
21253Toulouse CapitoleFranceInès Moreau4815394472019NULL
212613Edinburgh Princes StUnited KingdomGrace Brown4231687332018NULL
212715Firenze Santa Maria NovellaItalyFrancesco Ferrari54568496122021NULL
212916Madrid Gran VíaSpainMateo Sánchez5184897542019NULL
213014Milano DuomoItalyAurora Ferrari5528983262019NULL
21315Manhattan MidtownUnited StatesNoah Wilson4064330342021NULL
21335Austin DowntownUnited StatesLogan Johnson54988806102019NULL
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;