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 551–575 of 4,762

card_payment, page 23 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
6757Denver Union StationUnited StatesElla Garcia4666527682019NULL
6765Austin DowntownUnited StatesElla Garcia3746205492017NULL
67724Seoul YeouidoSouth KoreaJi-woo Park4781868642020NULL
6781Lyon BellecourFranceInès Martin4332392082016NULL
67917Barcelona EixampleSpainÁlvaro García5396697152018NULL
6806Atlanta MidtownUnited StatesOlivia Garcia4725863212018NULL
68117Bilbao AbandoSpainDaniel Pérez46633772112016NULL
68216Madrid Gran VíaSpainPaula González44913047112019NULL
68417Barcelona EixampleSpainMateo Martínez5254016922016NULL
6851Nantes CommerceFranceCamille Lefebvre5135354472020NULL
6861Lyon BellecourFranceArthur Leroy4830007972017NULL
68712Leeds BriggateUnited KingdomIsla Smith42229708122019NULL
6895Chicago LoopUnited StatesEthan Moore4463548282016NULL
69027Brisbane Queen StAustraliaJack Jones4265264292019NULL
69110Chengdu JinjiangChinaYang Yang4044095812017NULL
6945Austin DowntownUnited StatesOlivia Garcia5553470052020NULL
6956San Francisco Market StUnited StatesNoah Davis5535006712017NULL
6968Shanghai PudongChinaLin Sun6295397772017NULL
6978Beijing XidanChinaYang Wu6277191772017NULL
69915Firenze Santa Maria NovellaItalyBeatrice Rossi49958289122019NULL
7001Lyon BellecourFranceLéa Leroy5236859992019NULL
70128Rotterdam CoolsingelNetherlandsDaan de Jong4199393832018NULL
7022Marseille CanebièreFranceZoé Moreau5122781572020Google Pay
7034Strasbourg KléberFranceArthur Bernard43072478112019NULL
70411Manchester Market StUnited KingdomIsla Wright44489368122016NULL
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;