Table

card_payment

Card and wallet details: first and last four digits, expiry month and year, issuing branch.

Replaces in 2020: EFTPOS

Rows 301–325 of 4,762

card_payment, page 13 of 191
payment_id→ payment.payment_id	institution_id→ financial_institution.institution_id	issuing_branchTEXT	issued_countryTEXT	account_nameTEXT	card_first4TEXT	card_last4TEXT	expiry_monthINTEGER	expiry_yearINTEGER	walletTEXT
353	19	München Marienplatz	Germany	Hannah Wagner	4182	6741	12	2020	NULL
354	18	Berlin Unter den Linden	Germany	Hannah Wagner	5466	9361	12	2018	NULL
356	21	Belo Horizonte Savassi	Brazil	Alice Ferreira	5350	9068	12	2016	NULL
359	9	Guangzhou Tianhe	China	Tao Wang	6243	5281	4	2016	NULL
360	5	Chicago Loop	United States	James Johnson	5577	2817	4	2019	NULL
361	27	Brisbane Queen St	Australia	Noah Smith	5518	8174	7	2018	NULL
362	25	Incheon Songdo	South Korea	Seo-jun Kim	5400	9164	12	2016	NULL
363	20	Rio Centro	Brazil	Laura Oliveira	5556	5332	11	2019	NULL
365	2	Paris La Défense	France	Lucas Simon	5362	4253	7	2018	NULL
366	18	Frankfurt Taunusanlage	Germany	Elias Schmidt	4307	8067	6	2017	NULL
367	2	Paris La Défense	France	Arthur Simon	4064	9557	5	2017	NULL
369	5	Chicago Loop	United States	James Davis	5502	4815	9	2017	NULL
370	3	Rennes République	France	Chloé Dubois	4077	2757	1	2018	NULL
371	2	Paris La Défense	France	Manon Dubois	5490	1736	6	2016	NULL
372	10	Hangzhou Xihu	China	Xin Zhao	6238	2134	11	2018	NULL
375	6	Atlanta Midtown	United States	Ethan Moore	4486	1370	1	2018	NULL
377	17	Barcelona Eixample	Spain	Valeria López	5563	5090	5	2019	NULL
378	6	Atlanta Midtown	United States	Ava Davis	5282	3072	6	2020	NULL
379	2	Lille Grand Place	France	Inès Moreau	5347	6455	9	2019	NULL
380	20	São Paulo Paulista	Brazil	Davi Silva	5491	4148	1	2017	NULL
382	5	Chicago Loop	United States	Mason Smith	3736	6642	8	2020	NULL
383	5	Austin Downtown	United States	Ava Brown	5580	7992	10	2020	NULL
385	30	Saint Petersburg Nevsky	Russia	Maria Sokolov	4363	6465	3	2019	NULL
386	3	Rennes République	France	Arthur Moreau	5476	8895	6	2019	NULL
388	13	Bristol Corn St	United Kingdom	Amelia Smith	4091	6968	9	2018	NULL

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;