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,826–3,850 of 4,762

card_payment, page 154 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
439711Manchester Market StUnited KingdomHarry Johnson3710303852021NULL
43985Austin DowntownUnited StatesLiam Johnson49937442102021NULL
439918Berlin Unter den LindenGermanyElias Müller4676491262024NULL
440035Montréal Ville-MarieCanadaWilliam Tremblay5186042792020NULL
44014Strasbourg KléberFranceZoé Robert4229389152021NULL
440219Hamburg JungfernstiegGermanyLina Schmidt53786835122023NULL
440328Amsterdam ZuidasNetherlandsNoah Visser4127664552020NULL
44047Denver Union StationUnited StatesOlivia Miller4334821332023NULL
44055Chicago LoopUnited StatesOlivia Miller4814614482023NULL
44065Austin DowntownUnited StatesMia Williams5242587492020Google Pay
440716Madrid Gran VíaSpainSofía Martín4958105962023NULL
44085Manhattan MidtownUnited StatesJames Williams48892468122022NULL
44095Manhattan MidtownUnited StatesJames Williams4345388672020NULL
441014Milano DuomoItalyGinevra Ricci5553422352023Google Pay
44112Paris La DéfenseFranceLéa Laurent41642445102024NULL
441233Bergen BryggenNorwayNoah Larsen4700494462024NULL
44133Toulouse CapitoleFranceLéa Martin45694889102023Apple Pay
44143Bordeaux ChartronsFranceZoé Bernard4989826432024Google Pay
441523Kyoto ShijoJapanYuto Takahashi5367046172022NULL
44177Seattle Pike PlaceUnited StatesEthan Johnson3772453112023NULL
44182Marseille CanebièreFranceInès Laurent4881718162020NULL
44197Denver Union StationUnited StatesHarper Smith5438500132021NULL
44209Guangzhou TianheChinaLei Zhou4922596652024NULL
44215Chicago LoopUnited StatesOlivia Moore5297662382023Google Pay
44224Paris LouvreFranceLéa Dubois4358314842021NULL
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;