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,726–1,750 of 4,762

card_payment, page 70 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
20492Paris La DéfenseFranceArthur Bernard4557423672020NULL
20502Lille Grand PlaceFranceLéa Dubois4065988972020NULL
20515Austin DowntownUnited StatesEmma Johnson5544310292019NULL
20527Denver Union StationUnited StatesMia Jones5527893682022NULL
205314Milano DuomoItalyFrancesco Ferrari54151433112022Google Pay
20541Lyon BellecourFranceChloé Thomas4628136142018Apple Pay
20562Paris La DéfenseFranceZoé Durand5556632362018NULL
20577Seattle Pike PlaceUnited StatesLiam Garcia48754471112019NULL
205820Rio CentroBrazilAlice Souza5294344122021NULL
20594Strasbourg KléberFranceLucas Robert5350899822022NULL
206016Madrid Gran VíaSpainValeria Martínez4863667322022NULL
20624Paris LouvreFranceZoé Laurent4079854822020NULL
206317Barcelona EixampleSpainDaniel Martín4318845922018NULL
206416Madrid Gran VíaSpainHugo Sánchez5392624332019NULL
20655Austin DowntownUnited StatesAva Davis37425123102021NULL
206611Manchester Market StUnited KingdomJack Brown44748801122019NULL
20672Marseille CanebièreFranceHugo Laurent4223867432022NULL
206821Brasília Asa SulBrazilAlice Souza52048749122020NULL
206911London Canary WharfUnited KingdomGeorge Smith5473401342019NULL
20704Paris LouvreFranceJules Petit5545224822022NULL
20713Bordeaux ChartronsFranceLéa Petit4230939852021NULL
20723Toulouse CapitoleFranceLouis Bernard4131319452022NULL
207319Hamburg JungfernstiegGermanyFinn Koch53601377112020NULL
20744Paris LouvreFranceLouis Dubois4388526872020NULL
207527Brisbane Queen StAustraliaRuby Wilson40468875122021NULL
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;