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 3,876–3,900 of 4,762

card_payment, page 156 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
444810Chengdu JinjiangChinaJun Wang62178687112020NULL
44493Rennes RépubliqueFranceGabriel Bernard5320497042022NULL
44504Strasbourg KléberFranceJules Simon5570113522022NULL
44515Chicago LoopUnited StatesOlivia Williams5517981522021NULL
44525Manhattan MidtownUnited StatesEmma Davis4328276382022NULL
44535Austin DowntownUnited StatesLogan Miller4719490642020NULL
445410Hangzhou XihuChinaLin Liu5125713412020Apple Pay
445528Rotterdam CoolsingelNetherlandsDaan Smit4019420222024Apple Pay
44569Guangzhou TianheChinaJun Wang4885275112020Google Pay
44574Paris LouvreFranceManon Martin53459210122020Google Pay
44585Chicago LoopUnited StatesLogan Johnson5209496412023NULL
44594Paris LouvreFranceCamille Robert4026149122022NULL
44606Atlanta MidtownUnited StatesElla Anderson4569497182022NULL
44617Seattle Pike PlaceUnited StatesLiam Taylor4178059072024Apple Pay
446235Montréal Ville-MarieCanadaLiam Lee4349275572023NULL
446415Firenze Santa Maria NovellaItalyMatteo Marino5387035272024NULL
446531Kraków RynekPolandJakub Kowalczyk5422409492020Google Pay
44664Strasbourg KléberFranceInès Lefebvre4441148482023Apple Pay
44677Denver Union StationUnited StatesNoah Johnson5421022652022NULL
44684Paris LouvreFranceManon Simon4533981592023NULL
44693Bordeaux ChartronsFranceArthur Moreau5208598462020NULL
447013Bristol Corn StUnited KingdomAmelia Evans4359071822022Apple Pay
44713Toulouse CapitoleFranceJules Simon40735027102023NULL
44723Bordeaux ChartronsFranceLouis Moreau4629662192024NULL
44734Paris LouvreFranceLouis Thomas5342135752021Apple 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;