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 4,176–4,200 of 4,762

card_payment, page 168 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
47741Nantes CommerceFranceHugo Durand4381548272021NULL
47755Manhattan MidtownUnited StatesMia Moore5256918532021NULL
47761Lyon BellecourFranceManon Martin46756779102022NULL
477713Bristol Corn StUnited KingdomFreddie Taylor4746995652024Google Pay
477822Osaka UmedaJapanSakura Takahashi3579959252020NULL
47802Lille Grand PlaceFranceChloé Petit4867387542022NULL
47813Bordeaux ChartronsFranceHugo Martin5383010122022Apple Pay
47825Manhattan MidtownUnited StatesMia Moore45027205122022NULL
478318Frankfurt TaunusanlageGermanyElias Hoffmann4208637712021NULL
478435Montréal Ville-MarieCanadaChloé Lee4921265272020Apple Pay
47853Rennes RépubliqueFranceManon Bernard4206577332020NULL
47873Rennes RépubliqueFranceLucas Laurent4670137452023NULL
47886Boston Back BayUnited StatesLiam Garcia4161359652020NULL
47894Strasbourg KléberFranceCamille Simon4318445472024NULL
479019München MarienplatzGermanyElias Fischer4957355672024NULL
479113Edinburgh Princes StUnited KingdomOliver Taylor5216452922021NULL
479235Montréal Ville-MarieCanadaChloé Roy5436722122023NULL
47935Manhattan MidtownUnited StatesEmma Davis49028106102024Google Pay
47944Paris LouvreFranceCamille Dubois4412234522020NULL
479522Osaka UmedaJapanHina Watanabe4253373822022NULL
47966San Francisco Market StUnited StatesLiam Williams5237975592022NULL
47972Lille Grand PlaceFranceGabriel Moreau5399090082020Apple Pay
479926Adelaide Rundle MallAustraliaRuby Brown4766677262023Google Pay
48002Paris La DéfenseFranceCamille Martin5502294162022NULL
480125Incheon SongdoSouth KoreaDo-yun Jung4805717912022NULL
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;