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 1,851–1,875 of 4,762

card_payment, page 75 of 191
payment_id→ payment.payment_idinstitution_id→ financial_institution.institution_idissuing_branchTEXTissued_countryTEXTaccount_nameTEXTcard_first4TEXTcard_last4TEXTexpiry_monthINTEGERexpiry_yearINTEGERwalletTEXT
21898Shanghai PudongChinaMin Zhou62198459112018NULL
219010Hangzhou XihuChinaYang Chen48036340122021NULL
219213Bristol Corn StUnited KingdomIsla Jones4347577012022NULL
219313Bristol Corn StUnited KingdomAva Wilson5234012282020NULL
219411London Canary WharfUnited KingdomGrace Wilson4620579132018NULL
21967Seattle Pike PlaceUnited StatesAva Garcia5469541342022NULL
219720São Paulo PaulistaBrazilLaura Silva4971403652021NULL
21983Bordeaux ChartronsFranceChloé Dubois4820615842021NULL
21992Paris La DéfenseFranceCamille Simon4160672472019NULL
22005Manhattan MidtownUnited StatesMia Williams4342943822018NULL
22015Manhattan MidtownUnited StatesEthan Moore3764330952019NULL
220214Milano DuomoItalyBeatrice Russo4610033252022NULL
220322Tokyo MarunouchiJapanYui Nakamura47376525122019NULL
220425Incheon SongdoSouth KoreaSeo-jun Jung5163718582021Apple Pay
22056Atlanta MidtownUnited StatesElla Williams4241872392019NULL
22063Rennes RépubliqueFranceInès Martin5364437492022Google Pay
220726Melbourne Collins StAustraliaIsla Nguyen4543104472022NULL
220916Madrid Gran VíaSpainÁlvaro García4043822122019NULL
22101Paris OpéraFranceHugo Laurent4787466172018NULL
22115Austin DowntownUnited StatesAva Moore4459865632019NULL
22142Lille Grand PlaceFranceLouis Lefebvre5435280762018NULL
22152Lille Grand PlaceFranceArthur Moreau4766705672022NULL
22165Manhattan MidtownUnited StatesNoah Wilson4500012152022NULL
22177Denver Union StationUnited StatesNoah Wilson4776311722021Apple Pay
22183Toulouse CapitoleFranceJules Moreau43311301112019Apple 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;