Table

card_payment

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

Replaces in 2020: EFTPOS

Rows 26–50 of 4,762

card_payment, page 2 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
31	19	München Marienplatz	Germany	Lina Koch	4018	8726	6	2016	NULL
32	17	Barcelona Eixample	Spain	Mateo Fernández	4843	2359	9	2018	NULL
33	7	Denver Union Station	United States	Mason Garcia	5413	7546	8	2016	NULL
35	26	Melbourne Collins St	Australia	Amelia Taylor	4777	3783	3	2016	NULL
36	8	Beijing Xidan	China	Jun Huang	4470	6773	9	2018	NULL
37	1	Paris Opéra	France	Louis Dubois	4726	7036	9	2020	NULL
38	3	Rennes République	France	Jules Laurent	4363	7886	12	2017	NULL
39	7	Denver Union Station	United States	Mia Davis	4083	6604	10	2019	NULL
40	5	Chicago Loop	United States	Mia Davis	5577	4346	6	2020	NULL
41	7	Denver Union Station	United States	Mason Williams	4434	6799	12	2018	NULL
42	2	Paris La Défense	France	Jules Thomas	4889	1456	2	2018	Apple Pay
43	12	Leeds Briggate	United Kingdom	George Wright	4354	6032	7	2017	NULL
44	19	München Marienplatz	Germany	Lina Weber	4921	0025	9	2018	NULL
45	16	Madrid Gran Vía	Spain	Martina López	5421	4473	12	2016	NULL
46	2	Paris La Défense	France	Jules Martin	4914	8131	1	2016	NULL
47	33	Bergen Bryggen	Norway	Emil Hansen	5473	9616	7	2018	Google Pay
48	27	Brisbane Queen St	Australia	Amelia Jones	3764	2128	5	2018	NULL
49	3	Toulouse Capitole	France	Jules Robert	4885	7950	9	2018	NULL
50	7	Seattle Pike Place	United States	Emma Miller	4470	4073	12	2020	NULL
51	6	Boston Back Bay	United States	Mason Johnson	5443	4039	3	2019	NULL
52	15	Firenze Santa Maria Novella	Italy	Lorenzo Russo	4328	7086	10	2017	NULL
54	17	Bilbao Abando	Spain	Hugo López	4937	8329	3	2016	NULL
55	5	Chicago Loop	United States	Liam Johnson	5160	7249	1	2016	NULL
56	31	Warszawa Śródmieście	Poland	Antoni Kamiński	5230	0726	12	2018	NULL
57	3	Rennes République	France	Camille Thomas	4295	5456	8	2016	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;