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 2,326–2,350 of 4,762

card_payment, page 94 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
27494Paris LouvreFranceInès Petit54382031112021NULL
27507Seattle Pike PlaceUnited StatesJames Garcia5507911282020NULL
27516San Francisco Market StUnited StatesJames Smith41850846122020NULL
27535Manhattan MidtownUnited StatesMia Garcia5447139242020NULL
27543Bordeaux ChartronsFranceHugo Petit48610418122021NULL
275521Brasília Asa SulBrazilHelena Oliveira51891889122019NULL
27567Denver Union StationUnited StatesOlivia Smith5571026752021Apple Pay
27583Toulouse CapitoleFranceZoé Thomas52998275112020Apple Pay
275917Barcelona EixampleSpainSofía Gómez5144049322021NULL
276010Chengdu JinjiangChinaFang Sun4862146672020NULL
27618Shanghai PudongChinaYang Wang4369269362020NULL
276216Madrid Gran VíaSpainPaula González5294045462022NULL
276316Sevilla TrianaSpainPaula González45338217102020Google Pay
27647Denver Union StationUnited StatesAva Garcia42193802122021NULL
27654Paris LouvreFranceJules Simon4936965892019NULL
27665Chicago LoopUnited StatesJames Taylor5247401912020NULL
276730Moscow TverskayaRussiaDaria Sokolov4825326772021Google Pay
27688Beijing XidanChinaYan Li6224106442018NULL
27691Lyon BellecourFranceLéa Martin4068946252020NULL
27721Nantes CommerceFranceGabriel Lefebvre4248010982020NULL
27734Strasbourg KléberFranceManon Bernard5437512232022NULL
27743Toulouse CapitoleFranceLouis Martin4117015682019NULL
27754Strasbourg KléberFranceLucas Dubois4524876992021NULL
27765Manhattan MidtownUnited StatesHarper Brown49588286122021NULL
277721Belo Horizonte SavassiBrazilDavi Souza42902901122021NULL
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;