Table

card_payment

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

Replaces in 2020: EFTPOS

Rows 951–975 of 4,762

card_payment, page 39 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
1149	24	Seoul Yeouido	South Korea	Seo-yeon Park	5289	5888	7	2018	NULL
1150	17	Barcelona Eixample	Spain	Sofía Fernández	4955	3886	4	2018	NULL
1151	14	Milano Duomo	Italy	Ginevra Ricci	4013	2574	12	2017	NULL
1152	33	Oslo Bjørvika	Norway	Filip Johansen	4576	4592	5	2018	NULL
1153	33	Bergen Bryggen	Norway	Filip Johansen	5426	9098	2	2020	NULL
1154	3	Rennes République	France	Arthur Petit	5491	5462	12	2018	NULL
1155	24	Busan Seomyeon	South Korea	Seo-yeon Park	4210	3484	3	2019	NULL
1156	12	Birmingham New St	United Kingdom	Alfie Walker	5283	9839	4	2019	NULL
1157	30	Moscow Tverskaya	Russia	Dmitry Popov	5285	5004	9	2018	NULL
1158	4	Strasbourg Kléber	France	Arthur Moreau	5541	1603	5	2017	NULL
1159	4	Paris Louvre	France	Léa Robert	5488	5516	6	2019	NULL
1160	21	Belo Horizonte Savassi	Brazil	Arthur Rodrigues	4334	8259	1	2017	NULL
1161	3	Rennes République	France	Manon Dubois	4587	4667	12	2020	NULL
1162	6	Atlanta Midtown	United States	Noah Anderson	5334	1443	1	2018	NULL
1163	6	San Francisco Market St	United States	Noah Anderson	5488	8539	2	2019	NULL
1164	15	Roma Termini	Italy	Alessandro Bianchi	5134	9140	9	2017	NULL
1165	23	Yokohama Minatomirai	Japan	Yui Nakamura	3578	2325	10	2020	NULL
1166	17	Bilbao Abando	Spain	Álvaro Gómez	5495	3283	12	2019	NULL
1167	4	Paris Louvre	France	Camille Simon	5320	2888	11	2019	NULL
1169	19	München Marienplatz	Germany	Emma Schneider	4982	7725	2	2018	NULL
1170	35	Toronto Bay St	Canada	Olivia Lee	4128	3671	12	2018	NULL
1171	2	Marseille Canebière	France	Arthur Laurent	5220	3318	4	2018	Apple Pay
1172	4	Paris Louvre	France	Lucas Lefebvre	4045	5500	2	2017	NULL
1173	31	Warszawa Śródmieście	Poland	Zuzanna Kowalski	4155	9742	1	2018	NULL
1175	1	Paris Opéra	France	Inès Laurent	4097	1435	8	2020	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;