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,151–1,175 of 4,762

card_payment, page 47 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
13854Strasbourg KléberFranceLéa Laurent44245468122017Apple Pay
138611Manchester Market StUnited KingdomOliver Brown4593769762019NULL
13871Nantes CommerceFranceManon Martin4300802932019NULL
13882Paris La DéfenseFranceHugo Thomas4733005132020NULL
138915Firenze Santa Maria NovellaItalyLorenzo Russo5540512772021NULL
139028Rotterdam CoolsingelNetherlandsEmma Bakker5153248022017NULL
13911Paris OpéraFranceInès Lefebvre5190890162020NULL
139211Manchester Market StUnited KingdomAva Jones3706674772017NULL
13936Atlanta MidtownUnited StatesLiam Brown4590797912018NULL
13944Strasbourg KléberFranceJules Moreau4610670782018NULL
139521Belo Horizonte SavassiBrazilHelena Rodrigues4689530872017NULL
139814Torino CentroItalyGinevra Esposito5238670992021NULL
139926Melbourne Collins StAustraliaAmelia Nguyen47880230102018NULL
14007Denver Union StationUnited StatesEmma Brown3739741262018NULL
14011Nantes CommerceFranceCamille Lefebvre5323011752019Apple Pay
14034Paris LouvreFranceZoé Robert4745276622017NULL
14041Lyon BellecourFranceCamille Lefebvre4361790852019NULL
140510Chengdu JinjiangChinaTao Li47893593122020NULL
140618Berlin Unter den LindenGermanyBen Weber4352343632019NULL
140729Utrecht CentrumNetherlandsEmma Meijer5208188732019NULL
140926WoolloomoolooAustraliaNoah Kelly44514649112021Google Pay
14109Guangzhou TianheChinaLei Zhou6219570782018NULL
141130Saint Petersburg NevskyRussiaDaria Vasiliev4272105232020NULL
14136Boston Back BayUnited StatesLiam Smith4008743652019NULL
14142Paris La DéfenseFranceJules Petit4905835372019NULL
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;