Table

card_payment

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

Replaces in 2020: EFTPOS

Rows 751–775 of 4,762

card_payment, page 31 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
915	3	Toulouse Capitole	France	Zoé Leroy	4891	0966	1	2020	NULL
916	4	Paris Louvre	France	Gabriel Simon	5515	7804	5	2018	NULL
917	8	Beijing Xidan	China	Yang Huang	4096	2184	11	2016	NULL
919	7	Denver Union Station	United States	Noah Moore	4142	1238	12	2016	Apple Pay
921	21	Brasília Asa Sul	Brazil	Helena Alves	4373	4673	3	2018	NULL
922	30	Moscow Tverskaya	Russia	Anna Vasiliev	5353	4010	10	2017	NULL
923	1	Lyon Bellecour	France	Hugo Durand	4668	1490	3	2019	NULL
924	3	Toulouse Capitole	France	Chloé Moreau	4508	1495	5	2019	NULL
925	18	Berlin Unter den Linden	Germany	Leon Weber	4301	2025	4	2019	NULL
926	16	Madrid Gran Vía	Spain	Lucía Rodríguez	4453	8494	2	2018	NULL
927	2	Paris La Défense	France	Chloé Dubois	5388	3777	1	2017	NULL
928	15	Roma Termini	Italy	Ginevra Russo	5164	5794	1	2017	NULL
929	14	Torino Centro	Italy	Ginevra Russo	5283	8624	6	2018	NULL
930	13	Bristol Corn St	United Kingdom	Amelia Johnson	4072	8514	2	2017	NULL
931	30	Moscow Tverskaya	Russia	Alexander Kuznetsov	5361	9009	9	2017	NULL
932	12	Leeds Briggate	United Kingdom	Jack Wright	4539	4293	9	2018	NULL
933	1	Nantes Commerce	France	Jules Lefebvre	4454	8287	10	2019	NULL
934	20	Rio Centro	Brazil	Miguel Rodrigues	4177	7689	3	2020	NULL
935	16	Sevilla Triana	Spain	Sofía González	4782	1690	1	2019	NULL
936	6	Atlanta Midtown	United States	Ava Moore	4132	7909	12	2017	NULL
937	2	Marseille Canebière	France	Louis Thomas	5255	1526	5	2018	NULL
938	18	Berlin Unter den Linden	Germany	Ben Becker	5423	4071	12	2017	NULL
939	17	Barcelona Eixample	Spain	Sofía Sánchez	4151	3520	10	2020	NULL
940	17	Bilbao Abando	Spain	Sofía Sánchez	4613	8725	5	2021	NULL
942	3	Rennes République	France	Louis Durand	4384	3353	7	2019	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;