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 901–925 of 4,762

card_payment, page 37 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
109123Kyoto ShijoJapanAoi Watanabe4482117152019NULL
10938Shanghai PudongChinaJun Wang6206086072020NULL
109425Incheon SongdoSouth KoreaSeo-yeon Cho40272015112017NULL
10951Lyon BellecourFranceInès Robert5318903782018NULL
10967Denver Union StationUnited StatesMason Wilson5335049992017NULL
109716Sevilla TrianaSpainSofía López4485710712020NULL
109812Birmingham New StUnited KingdomFreddie Brown4472521722018NULL
10992Paris La DéfenseFranceLucas Martin5528831912020NULL
11007Denver Union StationUnited StatesAva Garcia4721206162018NULL
110232Stockholm Sergels TorgSwedenAstrid Johansson4314842972020NULL
11036San Francisco Market StUnited StatesLiam Taylor4392187962019NULL
11042Lille Grand PlaceFranceManon Bernard4754687932018NULL
110527Sydney Martin PlaceAustraliaJack Jones5187644722021NULL
110626Melbourne Collins StAustraliaJack Jones4816326122018NULL
11075Chicago LoopUnited StatesLiam Taylor3754853652018NULL
11085Chicago LoopUnited StatesAva Davis51380882102020NULL
11094Paris LouvreFranceZoé Moreau4636136522019NULL
11102Lille Grand PlaceFranceGabriel Lefebvre42189569112021Google Pay
111128Rotterdam CoolsingelNetherlandsEmma Visser4636730512018NULL
111230Moscow TverskayaRussiaDmitry Popov5588753422017NULL
11132Marseille CanebièreFranceLéa Martin49709204102020NULL
11149Shenzhen FutianChinaTao Liu6227394172021NULL
111514Torino CentroItalyAurora Greco5543408212019NULL
11164Strasbourg KléberFranceLucas Laurent5519906192019NULL
11173Bordeaux ChartronsFranceHugo Lefebvre40673599102018NULL
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;