Table

card_payment

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

Replaces in 2020: EFTPOS

Rows 1,576–1,600 of 4,762

card_payment, page 64 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
1878	14	Milano Duomo	Italy	Francesco Greco	4629	1171	5	2021	NULL
1879	19	München Marienplatz	Germany	Leon Meyer	4373	0859	2	2021	NULL
1880	8	Beijing Xidan	China	Hao Wu	4881	9982	6	2022	Google Pay
1881	4	Paris Louvre	France	Inès Thomas	5197	7407	11	2018	NULL
1882	5	Austin Downtown	United States	Ava Johnson	5479	7266	4	2021	NULL
1883	5	Manhattan Midtown	United States	Noah Williams	5239	5712	2	2020	NULL
1885	18	Berlin Unter den Linden	Germany	Paul Fischer	4721	1099	3	2021	NULL
1886	19	Hamburg Jungfernstieg	Germany	Lina Wagner	4150	1916	7	2021	NULL
1887	14	Torino Centro	Italy	Ginevra Esposito	4508	1550	2	2018	NULL
1888	30	Saint Petersburg Nevsky	Russia	Anna Smirnov	4596	9754	9	2020	NULL
1889	30	Saint Petersburg Nevsky	Russia	Anna Smirnov	5582	1708	1	2020	NULL
1890	30	Moscow Tverskaya	Russia	Mikhail Vasiliev	4287	3963	9	2020	NULL
1891	26	Melbourne Collins St	Australia	William Jones	4413	1170	5	2018	NULL
1892	27	Brisbane Queen St	Australia	William Jones	4780	1289	9	2019	NULL
1894	9	Guangzhou Tianhe	China	Wei Chen	4246	5027	9	2021	NULL
1895	17	Bilbao Abando	Spain	Paula Martín	4347	7037	2	2019	NULL
1896	16	Sevilla Triana	Spain	Álvaro Pérez	5470	5291	9	2018	NULL
1897	1	Nantes Commerce	France	Camille Leroy	5233	9826	7	2020	NULL
1898	1	Paris Opéra	France	Chloé Dubois	5217	4359	4	2021	NULL
1899	23	Kyoto Shijo	Japan	Sota Ito	4410	3950	9	2020	NULL
1900	1	Nantes Commerce	France	Inès Laurent	4821	5295	8	2019	NULL
1901	3	Toulouse Capitole	France	Jules Dubois	5152	3558	5	2022	Apple Pay
1903	15	Roma Termini	Italy	Lorenzo Colombo	5419	3194	7	2022	NULL
1904	1	Nantes Commerce	France	Inès Lefebvre	5394	6348	7	2018	NULL
1905	6	Atlanta Midtown	United States	Mason Williams	5115	8785	8	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;