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 926–950 of 4,762

card_payment, page 38 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
11188Beijing XidanChinaJun Zhao5273654282017NULL
11204Paris LouvreFranceChloé Simon4760955642019Google Pay
11214Strasbourg KléberFranceZoé Petit54875029122017NULL
11221Paris OpéraFranceCamille Thomas4394349732018NULL
11233Bordeaux ChartronsFranceCamille Thomas5168999122018NULL
11265Austin DowntownUnited StatesMia Anderson49964512112019NULL
11278Beijing XidanChinaLei Chen5364415912018NULL
112813Bristol Corn StUnited KingdomAlfie Jones5549096752021NULL
11297Seattle Pike PlaceUnited StatesElla Brown51715767122018NULL
11305Manhattan MidtownUnited StatesOlivia Williams49656831102020NULL
113123Yokohama MinatomiraiJapanHina Sato3581233782020NULL
11324Paris LouvreFranceCamille Petit5138208452018NULL
113335Toronto Bay StCanadaEmma Brown4685133082021NULL
11347Seattle Pike PlaceUnited StatesEmma Miller3773870752019NULL
113512Birmingham New StUnited KingdomJack Davies41652722122020NULL
11369Shenzhen FutianChinaYang Wu6235528352019NULL
11379Guangzhou TianheChinaMin Sun54774286102021NULL
113918Frankfurt TaunusanlageGermanyPaul Meyer5402491692017Apple Pay
11402Marseille CanebièreFranceCamille Bernard53301105122018NULL
114113Bristol Corn StUnited KingdomGeorge Jones4040041642019NULL
114211London Canary WharfUnited KingdomGeorge Jones4661594922018NULL
114412Birmingham New StUnited KingdomSophie Johnson5459250282019NULL
11451Lyon BellecourFranceHugo Lefebvre4028224342017NULL
114633Bergen BryggenNorwayFilip Johansen4148245672018NULL
114811London Canary WharfUnited KingdomLily Jones4537655552017NULL
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;