Table

card_payment

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

Replaces in 2020: EFTPOS

Rows 1,676–1,700 of 4,762

card_payment, page 68 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
1992	9	Guangzhou Tianhe	China	Yan Li	4205	7628	11	2020	NULL
1993	23	Yokohama Minatomirai	Japan	Yui Suzuki	3543	8077	2	2018	NULL
1994	7	Seattle Pike Place	United States	Emma Miller	3725	2078	8	2022	NULL
1995	6	Boston Back Bay	United States	Harper Jones	4853	2526	4	2019	NULL
1997	7	Denver Union Station	United States	Ava Moore	5122	2684	4	2019	NULL
1998	7	Seattle Pike Place	United States	Olivia Johnson	5407	3742	10	2021	NULL
1999	34	Helsinki Aleksanterinkatu	Finland	Eino Heikkinen	5170	9555	12	2020	NULL
2000	15	Firenze Santa Maria Novella	Italy	Giulia Esposito	4429	0148	5	2019	NULL
2001	25	Seoul Gangnam	South Korea	Su-ah Yoon	5512	7258	12	2020	NULL
2003	14	Milano Duomo	Italy	Matteo Ferrari	5123	7328	7	2018	NULL
2004	24	Busan Seomyeon	South Korea	Ye-jun Cho	4846	7233	3	2019	NULL
2005	27	Sydney Martin Place	Australia	Mia Smith	4624	6897	10	2021	NULL
2006	23	Kyoto Shijo	Japan	Aoi Nakamura	4177	7843	5	2020	NULL
2007	6	Boston Back Bay	United States	Emma Garcia	5464	4004	4	2018	Apple Pay
2009	1	Nantes Commerce	France	Jules Simon	4568	2435	2	2021	NULL
2010	2	Marseille Canebière	France	Hugo Moreau	4162	1808	2	2018	NULL
2011	25	Seoul Gangnam	South Korea	Ha-eun Kang	4926	5757	6	2019	NULL
2012	35	Toronto Bay St	Canada	Charlotte Lee	5223	3924	8	2018	NULL
2013	10	Hangzhou Xihu	China	Jun Wu	6251	3235	3	2018	NULL
2015	25	Incheon Songdo	South Korea	Ha-eun Cho	4388	5504	4	2020	NULL
2016	4	Strasbourg Kléber	France	Louis Dubois	5184	2714	7	2022	NULL
2019	35	Montréal Ville-Marie	Canada	Liam Gagnon	5397	8284	12	2018	NULL
2020	25	Seoul Gangnam	South Korea	Ye-jun Cho	4171	2535	10	2020	NULL
2021	3	Toulouse Capitole	France	Gabriel Robert	5382	6282	1	2021	Google Pay
2022	4	Strasbourg Kléber	France	Louis Bernard	4210	1910	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;