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,351–1,375 of 4,762

card_payment, page 55 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
16184Paris LouvreFranceJules Bernard4041830362019NULL
161913Edinburgh Princes StUnited KingdomSophie Wilson55472057102019NULL
16203Bordeaux ChartronsFranceJules Lefebvre4984285612018NULL
16229Shenzhen FutianChinaJing Liu6269530852019NULL
162313Bristol Corn StUnited KingdomFreddie Smith4819659592020Apple Pay
162418Frankfurt TaunusanlageGermanyPaul Wagner5262704642019NULL
162517Bilbao AbandoSpainPaula Pérez4219700592021NULL
16261Lyon BellecourFranceGabriel Laurent41707504122018NULL
162719München MarienplatzGermanyEmma Schneider49722233112020NULL
162833Oslo BjørvikaNorwayFilip Kristiansen43646898122020NULL
16291Paris OpéraFranceZoé Lefebvre5461985622019NULL
16309Guangzhou TianheChinaHao Sun6295960452018Google Pay
163119Hamburg JungfernstiegGermanyLea Hoffmann51646108112020NULL
16325Chicago LoopUnited StatesLiam Brown4760417782017NULL
163315Firenze Santa Maria NovellaItalyMatteo Ferrari4314129832017NULL
16346San Francisco Market StUnited StatesLiam Brown47087644122020NULL
16359Shenzhen FutianChinaJun Wu4868048382017NULL
16374Strasbourg KléberFranceInès Dubois4083753652019NULL
163826Melbourne Collins StAustraliaOliver Nguyen3796923312018NULL
163910Hangzhou XihuChinaWei Huang6277571872019NULL
16409Guangzhou TianheChinaLin Wang62250210102020NULL
164135Toronto Bay StCanadaEmma Wilson4445696722020NULL
16423Toulouse CapitoleFranceInès Petit4723925342021NULL
164332Göteborg AvenynSwedenLucas Johansson5509751022020NULL
164432Göteborg AvenynSwedenLucas Johansson5172744242017NULL
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;