Table

card_payment

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

Replaces in 2020: EFTPOS

Rows 1,551–1,575 of 4,762

card_payment, page 63 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
1851	2	Marseille Canebière	France	Camille Petit	4764	2965	2	2018	NULL
1852	27	Brisbane Queen St	Australia	William Taylor	4312	7234	12	2020	NULL
1853	26	Adelaide Rundle Mall	Australia	William Taylor	4396	4337	7	2021	NULL
1854	1	Lyon Bellecour	France	Gabriel Moreau	4991	0708	9	2018	NULL
1855	28	Amsterdam Zuidas	Netherlands	Sem Smit	4454	4200	10	2019	NULL
1856	33	Oslo Bjørvika	Norway	Ella Nilsen	4271	2118	11	2019	NULL
1857	33	Bergen Bryggen	Norway	Noah Olsen	4610	6362	2	2021	NULL
1858	19	Hamburg Jungfernstieg	Germany	Lea Wagner	4363	8295	11	2021	NULL
1859	19	Hamburg Jungfernstieg	Germany	Leon Müller	5548	6400	4	2018	NULL
1860	5	Austin Downtown	United States	Ava Miller	5557	2997	7	2018	NULL
1861	20	São Paulo Paulista	Brazil	Laura Alves	4723	1203	10	2020	NULL
1863	1	Nantes Commerce	France	Gabriel Petit	4628	3699	10	2021	NULL
1864	8	Beijing Xidan	China	Wei Huang	4250	3667	12	2019	NULL
1866	5	Chicago Loop	United States	Ava Moore	5410	9189	4	2019	NULL
1867	6	Boston Back Bay	United States	James Moore	4682	6371	11	2022	Google Pay
1868	10	Chengdu Jinjiang	China	Jun Chen	6277	9241	5	2022	NULL
1869	19	Hamburg Jungfernstieg	Germany	Lina Wagner	4512	2136	9	2018	NULL
1870	30	Moscow Tverskaya	Russia	Alexander Vasiliev	4704	1145	2	2020	NULL
1871	21	Belo Horizonte Savassi	Brazil	Helena Souza	4276	6625	9	2022	NULL
1872	20	Rio Centro	Brazil	Helena Souza	5433	7318	9	2020	NULL
1873	21	Brasília Asa Sul	Brazil	Laura Alves	5227	3016	11	2019	NULL
1874	29	Eindhoven Stratumseind	Netherlands	Julia van den Berg	4711	1087	10	2022	NULL
1875	10	Hangzhou Xihu	China	Jing Wu	4180	9153	12	2019	NULL
1876	25	Seoul Gangnam	South Korea	Ha-eun Lee	5594	1699	10	2019	Google Pay
1877	24	Busan Seomyeon	South Korea	Ha-eun Cho	4475	3782	5	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;