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,651–1,675 of 4,762

card_payment, page 67 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
19638Shanghai PudongChinaXin Li62029729102021NULL
19655Austin DowntownUnited StatesNoah Wilson48072141122019NULL
19661Lyon BellecourFranceLéa Bernard40057033112019NULL
196710Chengdu JinjiangChinaFang Xu4957805272022NULL
196830Moscow TverskayaRussiaAnastasia Popov4896077442021NULL
19695Manhattan MidtownUnited StatesLiam Williams52813386122018NULL
197016Madrid Gran VíaSpainHugo Gómez4415793582019NULL
197130Moscow TverskayaRussiaAnastasia Popov5383433542019NULL
19727Seattle Pike PlaceUnited StatesHarper Jones5270924642020NULL
19738Beijing XidanChinaLei Sun4602441612022NULL
19757Denver Union StationUnited StatesOlivia Miller3782820662022NULL
19764Paris LouvreFranceCamille Moreau55808023102018Google Pay
197716Sevilla TrianaSpainHugo Gómez5516857462018NULL
19786Atlanta MidtownUnited StatesLiam Johnson42519250122020NULL
19797Seattle Pike PlaceUnited StatesLiam Jones4227210662019NULL
19808Beijing XidanChinaFang Zhou4704410922020NULL
19816Atlanta MidtownUnited StatesMia Moore5166100122018NULL
198233Bergen BryggenNorwayFilip Kristiansen4013388672018Google Pay
19857Denver Union StationUnited StatesAva Davis5107512812022NULL
198619Hamburg JungfernstiegGermanyLina Wagner54045338112020NULL
198712Birmingham New StUnited KingdomSophie Brown4462355392020NULL
198823Kyoto ShijoJapanYuto Takahashi4462677832020Apple Pay
198935Montréal Ville-MarieCanadaLiam Gagnon52291558102020NULL
199023Yokohama MinatomiraiJapanRen Watanabe5323357752022NULL
199123Kyoto ShijoJapanYuto Takahashi4565762082022NULL
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;