bank - Table definition

General information

Table: bank

Description: bank

Type: Master

Rows: 3,365

columns: 29

Data: 24,494

columns

field	description	Type	associated date	foreign table
id	Unique identifier	Integer
name	name	Text
id_regulatory_entity	Regulatory entity	foreign key		entity
operating_income	operating income	Money	Si
image	image	Text
ISIN	ISIN	Text
net_profit	net profit	Money	Si
assets	assets	Money	Si
equity	equity	Money	Si
id_chief_executive_officer	chief executive officer	foreign key		person
net_profit_year	net profit year	Date
assets_year	assets year	Date
operating_income_year	operating income year	Date
equity_year	equity year	Date
id_type	type	foreign key		type of bank
date_founded	date founded	Date
Employees	Employees	Integer	Si
id_Central_bank_of	Central bank of	foreign key		country
Employees_year	Employees year	Date
id_city_Headquarters	city Headquarters	foreign key		city
id_division_1_Headquarters	administrative division Headquarters	foreign key		administrative division
id_country_Headquarters	country Headquarters	foreign key		country
id_continent_Headquarters	continent Headquarters	foreign key		continent
id_Currency	Currency	foreign key		currency
own_capital	own capital	Text
Website	Website	Text
date_dissolved	date dissolved	Date
Revenue	Revenue	Money
Revenue_year	Revenue year	Date

Relations

description	related table	relationship table
bank/person	person	Bank_person

Table in which FK is located