Table

card_payment

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

Replaces in 2020: EFTPOS

Rows 726–750 of 4,762

card_payment, page 30 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
884	33	Oslo Bjørvika	Norway	Emil Larsen	4836	1309	6	2019	NULL
885	13	Edinburgh Princes St	United Kingdom	Isla Wilson	3755	5006	3	2019	NULL
886	30	Saint Petersburg Nevsky	Russia	Maria Vasiliev	5563	0667	2	2020	NULL
890	17	Barcelona Eixample	Spain	Hugo Martín	4099	8696	3	2016	NULL
891	9	Shenzhen Futian	China	Lei Wu	5158	3116	9	2017	Apple Pay
892	9	Guangzhou Tianhe	China	Fang Chen	4105	7911	12	2019	NULL
893	19	München Marienplatz	Germany	Hannah Schmidt	4307	5171	4	2018	NULL
894	35	Toronto Bay St	Canada	Emma Gagnon	5554	4263	1	2017	NULL
895	22	Osaka Umeda	Japan	Yuto Nakamura	3541	6913	11	2016	NULL
897	14	Milano Duomo	Italy	Ginevra Bianchi	5224	4106	5	2018	NULL
898	21	Belo Horizonte Savassi	Brazil	Valentina Alves	5166	9492	7	2018	NULL
900	6	San Francisco Market St	United States	Ella Anderson	4419	1770	2	2019	NULL
901	9	Shenzhen Futian	China	Lei Li	5116	3205	7	2020	NULL
902	10	Hangzhou Xihu	China	Hao Zhao	5390	8839	2	2016	NULL
903	1	Nantes Commerce	France	Manon Thomas	5426	3475	12	2017	NULL
905	35	Toronto Bay St	Canada	Emma Brown	4812	1961	3	2018	NULL
906	3	Bordeaux Chartrons	France	Manon Martin	4184	1466	8	2018	NULL
907	2	Lille Grand Place	France	Camille Robert	4104	4492	5	2018	NULL
908	9	Shenzhen Futian	China	Jing Liu	5503	4592	5	2017	NULL
909	24	Busan Seomyeon	South Korea	Seo-yeon Cho	4255	8124	9	2017	NULL
910	35	Montréal Ville-Marie	Canada	Charlotte Martin	5327	4830	8	2019	NULL
911	20	São Paulo Paulista	Brazil	Arthur Rodrigues	5533	1955	1	2017	Apple Pay
912	16	Madrid Gran Vía	Spain	Daniel Gómez	5105	3723	6	2017	NULL
913	6	Boston Back Bay	United States	Olivia Williams	3710	0702	8	2017	NULL
914	4	Paris Louvre	France	Gabriel Simon	5353	2970	7	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;