Table

card_payment

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

Replaces in 2020: EFTPOS

Rows 1,051–1,075 of 4,762

card_payment, page 43 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
1266	24	Seoul Yeouido	South Korea	Min-jun Lee	4499	6494	5	2017	NULL
1267	31	Kraków Rynek	Poland	Jan Nowak	5468	5506	3	2021	NULL
1268	14	Milano Duomo	Italy	Francesco Greco	4807	8377	11	2019	NULL
1269	5	Austin Downtown	United States	Ella Jones	4569	6160	8	2019	NULL
1270	5	Manhattan Midtown	United States	Liam Smith	5575	0669	1	2020	NULL
1272	22	Osaka Umeda	Japan	Yuto Tanaka	5167	5456	1	2017	NULL
1273	12	Birmingham New St	United Kingdom	Freddie Walker	5391	7590	5	2018	NULL
1274	11	Manchester Market St	United Kingdom	Freddie Walker	4250	4628	5	2018	NULL
1276	3	Toulouse Capitole	France	Arthur Petit	4262	3068	7	2020	NULL
1277	18	Frankfurt Taunusanlage	Germany	Ben Wagner	4303	4845	4	2021	NULL
1278	21	Belo Horizonte Savassi	Brazil	Laura Oliveira	5391	2136	1	2018	NULL
1279	1	Paris Opéra	France	Chloé Petit	4226	0157	4	2017	NULL
1280	29	Eindhoven Stratumseind	Netherlands	Tess Meijer	4654	6172	3	2019	NULL
1281	5	Chicago Loop	United States	Noah Brown	4768	1534	4	2020	NULL
1282	23	Kyoto Shijo	Japan	Ren Ito	3516	0261	10	2017	NULL
1283	17	Bilbao Abando	Spain	Mateo Rodríguez	4475	8324	7	2020	NULL
1284	16	Madrid Gran Vía	Spain	Mateo Rodríguez	5334	1846	1	2019	NULL
1285	26	Adelaide Rundle Mall	Australia	Charlotte Taylor	5225	9185	3	2019	NULL
1286	4	Paris Louvre	France	Inès Bernard	5206	0683	11	2017	NULL
1287	30	Saint Petersburg Nevsky	Russia	Mikhail Kuznetsov	4431	1963	5	2021	NULL
1288	24	Busan Seomyeon	South Korea	Seo-jun Kang	4548	8029	9	2017	NULL
1289	2	Lille Grand Place	France	Hugo Simon	5237	3967	12	2017	NULL
1290	2	Lille Grand Place	France	Hugo Simon	4560	0925	7	2021	NULL
1291	35	Toronto Bay St	Canada	Emma Wilson	4618	5500	11	2021	NULL
1292	5	Manhattan Midtown	United States	Olivia Jones	5101	6510	6	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;