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,126–1,150 of 4,762

card_payment, page 46 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
13582Paris La DéfenseFranceChloé Simon51802567112018NULL
13591Nantes CommerceFranceGabriel Leroy4709388882021NULL
13602Marseille CanebièreFranceArthur Dubois4129458022019Google Pay
13612Paris La DéfenseFranceZoé Laurent44391601102017NULL
13625Austin DowntownUnited StatesJames Anderson3733125122020NULL
13635Manhattan MidtownUnited StatesAva Brown51259429122017NULL
136422Tokyo MarunouchiJapanSota Tanaka5469935492019Apple Pay
13652Paris La DéfenseFranceInès Durand4238474952019NULL
136616Madrid Gran VíaSpainHugo Fernández5302861412018NULL
136723Yokohama MinatomiraiJapanYuto Takahashi35609060102017NULL
136823Yokohama MinatomiraiJapanHina Yamamoto5448655732020NULL
136934Tampere HämeenkatuFinlandEino Laine48953764102021Apple Pay
137034Tampere HämeenkatuFinlandHelmi Mäkelä51606121112020NULL
137115Roma TerminiItalyGinevra Russo4574365492019NULL
13722Lille Grand PlaceFranceInès Bernard5410889132018NULL
13732Lille Grand PlaceFranceInès Dubois4882912532020NULL
13741Paris OpéraFranceLucas Bernard41908143122019NULL
137517Barcelona EixampleSpainMartina Fernández4276106112019NULL
13766San Francisco Market StUnited StatesJames Williams54492672122018NULL
13774Strasbourg KléberFranceLouis Petit5227827162020NULL
137830Saint Petersburg NevskyRussiaDaria Vasiliev4710286192018Apple Pay
13794Strasbourg KléberFranceArthur Simon4268289682018NULL
138010Hangzhou XihuChinaXin Sun4873005752020NULL
13817Denver Union StationUnited StatesElla Wilson4846869922020Apple Pay
13835Manhattan MidtownUnited StatesElla Wilson4760522672020NULL
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;