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,126–2,150 of 4,762

card_payment, page 86 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
25204Paris LouvreFranceChloé Martin4092355482019NULL
252113Edinburgh Princes StUnited KingdomAmelia Wright3767904252019NULL
252235Toronto Bay StCanadaWilliam Roy53322750122022NULL
25232Lille Grand PlaceFranceHugo Simon5363060892018NULL
25248Shanghai PudongChinaYan Zhang6239901782021NULL
252533Bergen BryggenNorwayEmil Larsen55027100112021NULL
252628Rotterdam CoolsingelNetherlandsJulia Bakker5292986292018NULL
25272Paris La DéfenseFranceLéa Leroy44325690102022NULL
25284Strasbourg KléberFranceHugo Moreau5338294362021NULL
25295Chicago LoopUnited StatesMia Anderson4329393442022NULL
253035Montréal Ville-MarieCanadaEmma Lee4361312712020NULL
253113Edinburgh Princes StUnited KingdomIsla Wright5329015982018NULL
25326Boston Back BayUnited StatesOlivia Brown37043227102020NULL
25346Boston Back BayUnited StatesMia Anderson41842381112021NULL
25351Paris OpéraFranceCamille Laurent48885059102022NULL
25363Toulouse CapitoleFranceGabriel Leroy52646118112020NULL
25377Denver Union StationUnited StatesMia Miller4321317612019Apple Pay
25398Shanghai PudongChinaJing Li5113491562018NULL
25407Denver Union StationUnited StatesMia Williams4809305422018NULL
25416Atlanta MidtownUnited StatesOlivia Moore3797457212021NULL
25427Seattle Pike PlaceUnited StatesJames Moore4019196752019NULL
254320São Paulo PaulistaBrazilMiguel Souza4777704142022NULL
254420Rio CentroBrazilMiguel Souza4974480582019NULL
254519Hamburg JungfernstiegGermanyElias Wagner4873652122021NULL
254617Barcelona EixampleSpainValeria García5211009622022NULL
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;