Table

card_payment

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

Replaces in 2020: EFTPOS

Rows 101–125 of 4,762

card_payment, page 5 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
115	16	Sevilla Triana	Spain	Lucía García	5555	2267	2	2020	NULL
117	16	Madrid Gran Vía	Spain	Lucía García	4197	2115	1	2018	NULL
118	7	Seattle Pike Place	United States	Noah Brown	4976	5474	8	2017	NULL
119	1	Nantes Commerce	France	Jules Moreau	5374	9241	7	2019	NULL
121	6	Boston Back Bay	United States	Noah Moore	4560	3487	4	2017	NULL
122	7	Denver Union Station	United States	Noah Moore	4157	4203	11	2018	NULL
123	35	Toronto Bay St	Canada	Charlotte Roy	5599	4187	11	2019	NULL
124	7	Denver Union Station	United States	Ethan Smith	4271	7292	10	2020	NULL
125	2	Lille Grand Place	France	Léa Thomas	4522	5696	6	2017	NULL
126	1	Lyon Bellecour	France	Arthur Moreau	4052	1948	3	2016	NULL
128	14	Milano Duomo	Italy	Ginevra Romano	5175	1872	10	2016	NULL
129	2	Marseille Canebière	France	Lucas Laurent	5169	0304	11	2019	NULL
130	17	Barcelona Eixample	Spain	Valeria Gómez	5470	8820	6	2016	NULL
131	3	Rennes République	France	Camille Petit	5436	6993	7	2017	NULL
132	4	Strasbourg Kléber	France	Camille Simon	4194	7427	2	2017	NULL
133	7	Seattle Pike Place	United States	Noah Brown	4423	0685	8	2018	NULL
134	19	Hamburg Jungfernstieg	Germany	Finn Schneider	4634	6398	8	2017	NULL
135	9	Guangzhou Tianhe	China	Wei Liu	5332	5696	5	2016	NULL
138	27	Brisbane Queen St	Australia	William Nguyen	4907	4384	3	2020	NULL
139	5	Manhattan Midtown	United States	Liam Jones	4577	6922	10	2018	Google Pay
140	27	Brisbane Queen St	Australia	William Kelly	4673	3298	6	2020	NULL
141	3	Toulouse Capitole	France	Gabriel Petit	4732	4709	6	2019	NULL
142	34	Helsinki Aleksanterinkatu	Finland	Helmi Korhonen	4801	4655	8	2018	NULL
143	27	Brisbane Queen St	Australia	Mia Williams	5273	4163	12	2017	NULL
144	5	Chicago Loop	United States	Ethan Johnson	4841	7562	4	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;