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 601–625 of 4,762

card_payment, page 25 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
7334Paris LouvreFranceInès Leroy5362944322020NULL
7343Bordeaux ChartronsFranceCamille Simon5596356132017NULL
73517Barcelona EixampleSpainPablo Gómez4853445582017NULL
73619Hamburg JungfernstiegGermanyFinn Fischer5312492452019Apple Pay
7371Nantes CommerceFranceLouis Leroy5519608212020NULL
7382Paris La DéfenseFranceLéa Thomas4807435932020NULL
7407Denver Union StationUnited StatesNoah Davis4360538172016NULL
74115Firenze Santa Maria NovellaItalyAurora Colombo4720369332018NULL
74217Bilbao AbandoSpainHugo González4492449992018NULL
74311Manchester Market StUnited KingdomLily Davies5149867212019NULL
74420Rio CentroBrazilHeitor Santos5230295072017NULL
74517Barcelona EixampleSpainÁlvaro García4538034372017NULL
7463Bordeaux ChartronsFranceHugo Simon5407288312016NULL
7474Paris LouvreFranceGabriel Robert48500609102020NULL
7485Chicago LoopUnited StatesNoah Garcia5527326922019NULL
7492Lille Grand PlaceFranceLucas Moreau42473443112018NULL
7504Paris LouvreFranceZoé Durand5561529692019NULL
75117Barcelona EixampleSpainPaula Sánchez4411386822016NULL
75214Milano DuomoItalySofia Ricci5106154422020NULL
75324Busan SeomyeonSouth KoreaHa-eun Choi5440720342018NULL
75410Hangzhou XihuChinaMin Yang6298557472017NULL
75515Firenze Santa Maria NovellaItalyGinevra Ferrari4853590122020NULL
75616Madrid Gran VíaSpainPaula Sánchez5361376712016NULL
7571Lyon BellecourFranceInès Petit54914609122020NULL
7627Denver Union StationUnited StatesLiam Jones4083593462017NULL
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;