Table

card_payment

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

Replaces in 2020: EFTPOS

Rows 1,451–1,475 of 4,762

card_payment, page 59 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
1731	5	Austin Downtown	United States	James Miller	5227	9849	4	2020	NULL
1733	31	Warszawa Śródmieście	Poland	Antoni Wójcik	4087	7245	5	2020	NULL
1734	32	Göteborg Avenyn	Sweden	William Olsson	5515	0675	6	2019	NULL
1736	16	Madrid Gran Vía	Spain	Daniel Pérez	4565	0960	7	2017	NULL
1737	8	Beijing Xidan	China	Xin Liu	6251	2295	10	2019	NULL
1738	34	Helsinki Aleksanterinkatu	Finland	Aino Mäkelä	4546	0050	11	2018	Apple Pay
1739	1	Nantes Commerce	France	Chloé Leroy	4810	3775	5	2018	NULL
1740	12	Leeds Briggate	United Kingdom	Grace Johnson	3705	5771	4	2017	NULL
1741	13	Bristol Corn St	United Kingdom	Grace Johnson	4024	3570	6	2021	NULL
1742	10	Hangzhou Xihu	China	Xin Liu	6204	7695	7	2020	NULL
1743	9	Guangzhou Tianhe	China	Xin Liu	5351	0897	4	2019	NULL
1744	32	Stockholm Sergels Torg	Sweden	Oscar Persson	4256	6613	10	2018	NULL
1745	32	Stockholm Sergels Torg	Sweden	Oscar Larsson	5177	7108	7	2020	NULL
1746	5	Chicago Loop	United States	Harper Taylor	4875	8853	7	2019	NULL
1747	2	Paris La Défense	France	Manon Martin	5281	0162	1	2020	Apple Pay
1748	2	Paris La Défense	France	Manon Moreau	5320	1265	4	2020	NULL
1749	2	Marseille Canebière	France	Camille Thomas	4195	0161	12	2020	NULL
1751	8	Shanghai Pudong	China	Jing Zhang	6287	5799	5	2017	NULL
1752	29	Utrecht Centrum	Netherlands	Julia Meijer	4444	0848	12	2020	NULL
1753	6	San Francisco Market St	United States	Emma Williams	5142	5303	11	2021	NULL
1754	24	Seoul Yeouido	South Korea	Do-yun Park	5181	5976	5	2018	NULL
1755	1	Nantes Commerce	France	Chloé Lefebvre	4852	5450	6	2019	NULL
1756	5	Chicago Loop	United States	Ava Anderson	5213	2597	2	2021	NULL
1757	19	Hamburg Jungfernstieg	Germany	Ben Becker	5509	2826	8	2021	NULL
1758	30	Saint Petersburg Nevsky	Russia	Ivan Vasiliev	5117	7059	10	2021	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;