Table annual_result {
  year int [not null]
	result decimal (19, 2)
	id_coop bigint [not null]
	primary key (id_coop, year)
}

Table category {
  id_category bigint [pk, not null]
	name varchar(255)
}

Table cooperative {
  id_coop bigint [pk]
	cod_coop varchar(255)
	name varchar(255)
}

Table cooperative_product {
  value decimal(19,2)
	weight double
	id_coop bigint [not null]
	id_prod bigint [not null]
	primary key (id_coop, id_prod)
}

Table product {
  id_prod bigint [pk, not null]
	name varchar(255)
	id_category bigint
}

Table user {
  id_user bigint [pk, not null]
	document varchar(255)
	name varchar(255)
	password varchar(255)
	role varchar(255)
	cod_coop bigint [not null]
}

Ref: "annual_result"."id_coop" > "cooperative"."id_coop"
Ref: "cooperative"."id_coop" < "cooperative_product"."id_coop"
Ref: "product"."id_prod" < "cooperative_product"."id_prod"
Ref: "category"."id_category" < "product"."id_category"
Ref: "cooperative"."cod_coop" < "user"."cod_coop"