beneficiary_business_addresses

Data license: Open Government Licence – Toronto · Data source: Toronto Open Data · About: Built by Ram Vasuthevan with ❤️ on the shoulders of giants

9,551 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE beneficiary_business_addresses (
	id INTEGER NOT NULL, 
	beneficiary_id INTEGER, 
	address_line1 VARCHAR(100), 
	address_line2 VARCHAR(100), 
	city VARCHAR(50), 
	province VARCHAR(50), 
	country VARCHAR(50), 
	postal_code VARCHAR(20), 
	PRIMARY KEY (id), 
	UNIQUE (beneficiary_id), 
	FOREIGN KEY(beneficiary_id) REFERENCES beneficiaries (id)
);