Table

card_payment

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

Replaces in 2020: EFTPOS

Rows 676–700 of 4,762

card_payment, page 28 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
823	12	Birmingham New St	United Kingdom	Grace Taylor	5393	2880	8	2020	NULL
824	18	Berlin Unter den Linden	Germany	Lina Müller	4372	0196	3	2019	NULL
825	22	Tokyo Marunouchi	Japan	Sakura Nakamura	4155	9655	10	2018	NULL
826	7	Denver Union Station	United States	Olivia Davis	4586	4950	3	2020	NULL
827	10	Chengdu Jinjiang	China	Lin Zhang	4598	9844	11	2020	NULL
828	6	Boston Back Bay	United States	Olivia Davis	5359	3678	7	2016	NULL
829	13	Edinburgh Princes St	United Kingdom	George Walker	4069	7391	8	2017	NULL
830	20	Rio Centro	Brazil	Alice Alves	4122	8357	4	2017	NULL
831	2	Marseille Canebière	France	Camille Laurent	4960	6756	12	2016	NULL
832	20	São Paulo Paulista	Brazil	Alice Alves	5373	8376	10	2018	NULL
833	7	Denver Union Station	United States	Emma Miller	4138	1837	10	2019	NULL
836	20	São Paulo Paulista	Brazil	Davi Souza	4907	3912	10	2017	NULL
837	4	Paris Louvre	France	Léa Durand	5385	6977	11	2019	NULL
838	20	São Paulo Paulista	Brazil	Heitor Oliveira	4010	3919	6	2018	NULL
839	17	Barcelona Eixample	Spain	Mateo González	4321	3736	7	2020	NULL
842	30	Saint Petersburg Nevsky	Russia	Maria Vasiliev	5165	1994	7	2019	NULL
843	5	Manhattan Midtown	United States	Ella Jones	4147	1582	4	2020	NULL
844	7	Denver Union Station	United States	Ella Jones	4642	4293	2	2018	NULL
846	8	Shanghai Pudong	China	Hao Zhou	5478	1717	3	2017	Apple Pay
847	6	Atlanta Midtown	United States	Ella Garcia	4371	4862	7	2020	NULL
848	7	Denver Union Station	United States	Ethan Miller	4997	6879	6	2020	NULL
850	32	Göteborg Avenyn	Sweden	Lucas Olsson	4876	5725	10	2019	NULL
852	5	Manhattan Midtown	United States	Ethan Wilson	5459	7064	10	2019	NULL
853	1	Nantes Commerce	France	Léa Petit	4389	9055	8	2017	NULL
854	24	Seoul Yeouido	South Korea	Ji-woo Kim	4498	1932	2	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;