Table

card_payment

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

Replaces in 2020: EFTPOS

Rows 801–825 of 4,762

card_payment, page 33 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
974	22	Osaka Umeda	Japan	Ren Suzuki	4417	4421	3	2019	NULL
975	27	Sydney Martin Place	Australia	Mia Taylor	4689	1451	9	2021	NULL
976	30	Moscow Tverskaya	Russia	Alexander Vasiliev	4923	5415	6	2018	NULL
977	31	Kraków Rynek	Poland	Antoni Kowalczyk	5202	9159	7	2020	NULL
978	25	Seoul Gangnam	South Korea	Min-jun Kim	4549	9456	3	2018	NULL
980	28	Amsterdam Zuidas	Netherlands	Noah Bakker	4307	0895	12	2018	Google Pay
981	15	Firenze Santa Maria Novella	Italy	Aurora Marino	4244	1336	12	2019	NULL
983	5	Manhattan Midtown	United States	Logan Jones	4836	7640	12	2019	NULL
984	21	Belo Horizonte Savassi	Brazil	Heitor Alves	4128	8880	5	2020	NULL
986	3	Rennes République	France	Inès Lefebvre	5567	6283	8	2021	NULL
987	18	Berlin Unter den Linden	Germany	Finn Hoffmann	5576	7663	5	2021	NULL
989	9	Shenzhen Futian	China	Jun Li	4053	0219	7	2021	NULL
990	7	Seattle Pike Place	United States	Logan Taylor	4706	3032	4	2021	Apple Pay
992	5	Chicago Loop	United States	Logan Taylor	4338	1894	7	2017	NULL
993	34	Helsinki Aleksanterinkatu	Finland	Helmi Hämäläinen	4478	4498	12	2020	NULL
994	29	Eindhoven Stratumseind	Netherlands	Emma Visser	4211	2386	10	2021	NULL
995	1	Paris Opéra	France	Manon Moreau	4701	5436	8	2020	NULL
996	11	London Canary Wharf	United Kingdom	Ava Wright	4442	6201	7	2017	NULL
997	31	Warszawa Śródmieście	Poland	Szymon Kowalski	4661	2826	9	2019	NULL
998	32	Göteborg Avenyn	Sweden	Lucas Larsson	4323	3113	5	2020	NULL
1000	32	Stockholm Sergels Torg	Sweden	Lucas Larsson	4440	1924	12	2021	Apple Pay
1001	21	Brasília Asa Sul	Brazil	Heitor Silva	5565	3512	4	2017	Google Pay
1003	27	Sydney Martin Place	Australia	Jack Jones	5299	5941	10	2021	NULL
1004	4	Strasbourg Kléber	France	Jules Laurent	4614	6891	8	2017	Google Pay
1005	33	Oslo Bjørvika	Norway	Ingrid Kristiansen	4241	4023	10	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;