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 4,501–4,525 of 4,762

card_payment, page 181 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
51256San Francisco Market StUnited StatesJames Johnson4852577932021NULL
512624Busan SeomyeonSouth KoreaSeo-jun Kang53130699112021Apple Pay
512725Incheon SongdoSouth KoreaYe-jun Lee4796189062023NULL
51288Beijing XidanChinaJun Wang6271104032023Google Pay
512914Torino CentroItalyGiulia Esposito4095808642023NULL
513030Saint Petersburg NevskyRussiaAnna Smirnov5469749662021NULL
51312Marseille CanebièreFranceLéa Durand5346176752020NULL
513232Stockholm Sergels TorgSwedenHugo Eriksson4349796172024NULL
51335Chicago LoopUnited StatesOlivia Johnson3711183142023NULL
513410Hangzhou XihuChinaJun Wang5390958532020NULL
513510Chengdu JinjiangChinaTao Huang6205955272020NULL
51368Shanghai PudongChinaJun Wang5155983852024NULL
513716Madrid Gran VíaSpainValeria López54263960122023Google Pay
513826Adelaide Rundle MallAustraliaIsla Smith4150887822020NULL
513919München MarienplatzGermanyHannah Weber4272498522024NULL
51402Marseille CanebièreFranceHugo Laurent4445701582020NULL
514134Tampere HämeenkatuFinlandLeo Korhonen4489462772021NULL
514218Frankfurt TaunusanlageGermanyLea Becker5517223772022NULL
514311Manchester Market StUnited KingdomGrace Patel4298573482024NULL
514414Milano DuomoItalyGiulia Russo4680784222024NULL
51465Austin DowntownUnited StatesMia Brown3741979732023NULL
514827Sydney Martin PlaceAustraliaJack Kelly43702444122022NULL
51497Denver Union StationUnited StatesAva Garcia4829616142024NULL
51501Lyon BellecourFranceHugo Laurent52327053122024NULL
51517Denver Union StationUnited StatesAva Miller3782207442024Apple Pay
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;