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,101–3,125 of 4,762

card_payment, page 125 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
360314Torino CentroItalyBeatrice Romano54513787112023NULL
360434Helsinki AleksanterinkatuFinlandVäinö Nieminen53951086112023NULL
360515Firenze Santa Maria NovellaItalyLorenzo Colombo4576553152019NULL
360614Milano DuomoItalyMatteo Rossi4130533412021NULL
360715Firenze Santa Maria NovellaItalyLorenzo Colombo5468965892023NULL
36083Bordeaux ChartronsFranceZoé Moreau4313468972022NULL
36095Chicago LoopUnited StatesLiam Smith4738936722019NULL
36106Atlanta MidtownUnited StatesLiam Davis3733026292020Google Pay
36112Paris La DéfenseFranceManon Leroy4327117352021NULL
36124Paris LouvreFranceHugo Lefebvre4749637172021NULL
361311Manchester Market StUnited KingdomSophie Williams5262326352022Apple Pay
361430Moscow TverskayaRussiaMaria Ivanov46161867112021NULL
36152Marseille CanebièreFranceLéa Martin4720216752021NULL
361635Montréal Ville-MarieCanadaCharlotte Martin41139346122021NULL
36173Bordeaux ChartronsFranceLéa Martin5482031222023NULL
361813Bristol Corn StUnited KingdomJack Smith5517292732023NULL
361922Tokyo MarunouchiJapanSota Suzuki4514671942020NULL
362213Edinburgh Princes StUnited KingdomAva Taylor54660946102021NULL
36231Nantes CommerceFranceLéa Lefebvre4513145362021NULL
36244Strasbourg KléberFranceHugo Dubois4773302292021NULL
36252Lille Grand PlaceFranceChloé Durand5381559282021NULL
362623Kyoto ShijoJapanYui Sato46413200112021NULL
36274Strasbourg KléberFranceHugo Thomas5325549692019NULL
362810Chengdu JinjiangChinaXin Xu44982558102021Apple Pay
36294Strasbourg KléberFranceLéa Moreau5524967732023NULL
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;