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 2,401–2,425 of 4,762

card_payment, page 97 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
28315Manhattan MidtownUnited StatesEmma Moore4014787712022NULL
28323Rennes RépubliqueFranceCamille Simon46565708112019NULL
283330Saint Petersburg NevskyRussiaDaria Kuznetsov49837711112023Google Pay
283434Helsinki AleksanterinkatuFinlandEino Korhonen5576798542020Apple Pay
283534Helsinki AleksanterinkatuFinlandHelmi Mäkinen5554745752021NULL
28368Beijing XidanChinaYang Zhou48575162112019NULL
283718Berlin Unter den LindenGermanyEmma Schneider41808332112023NULL
283814Milano DuomoItalyLorenzo Russo40508031122022NULL
28392Marseille CanebièreFranceLouis Durand55876243112020NULL
28403Bordeaux ChartronsFranceCamille Durand4535914222021NULL
28425Chicago LoopUnited StatesHarper Wilson5145426832021NULL
284319München MarienplatzGermanyFinn Fischer52562174122019NULL
28446Boston Back BayUnited StatesElla Johnson49563589112022NULL
28457Seattle Pike PlaceUnited StatesEmma Johnson5318470052022NULL
28461Paris OpéraFranceManon Robert4152014022020NULL
284731Kraków RynekPolandAntoni Lewandowski5206378472022NULL
28485Austin DowntownUnited StatesElla Anderson4388831032023NULL
28505Chicago LoopUnited StatesEmma Brown4181191982021NULL
285117Barcelona EixampleSpainPablo Pérez5386291322021NULL
28525Austin DowntownUnited StatesLogan Miller55969574112022NULL
285330Moscow TverskayaRussiaAlexander Petrov44430455112021NULL
28549Shenzhen FutianChinaHao Li5346247052021NULL
28566San Francisco Market StUnited StatesLiam Jones43782189102023NULL
285730Saint Petersburg NevskyRussiaIvan Vasiliev5576714672022NULL
285822Tokyo MarunouchiJapanSota Ito3546918272021NULL
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;