Model / Espacio_Protegido / Tables / cntr_site

Project:
cntr_site : Public <<table>> Table
Created: 03/06/2024 17:39:07
Modified: 03/06/2024 17:39:07
Project:
Advanced:
Tabla del submodelo CNTRYES<br/>
  • Attributes
  • Operations
  • Associations To
  • Associations From
  • Tagged Values
  • Advanced
Attribute Scope Type
site_code Public varchar(12)
 
site_type Public varchar(1)
 
site_name Public text
 
site_spa_date Public date
 
site_spa_legal_ref Public text
 
site_sci_prop_date Public date
 
site_sci_conf_date Public date
 
site_sac_date Public date
 
site_sac_legal_ref Public text
 
site_explanations Public text
 
site_longitude Public numeric(10,2)
 
site_latitude Public numeric(10,2)
 
site_area Public numeric(20,2)
 
site_marine_area Public numeric(20,2)
 
site_length Public numeric(20,2)
 
site_characteristics Public text
 
site_quality Public text
 
site_designation Public text
 
doc_id Public numeric(20)
 
resp_id Public integer
 
mgmt_id Public numeric(20)
 
map_id Public numeric(10)
 
date_creation Public date
 
date_deletion Public date
 
date_update Public date
 
site_asci_prop_date Public date
 
site_asci_conf_cand_date Public date
 
site_asci_conf_date Public date
 
site_asci_desig_date Public date
 
site_asci_legal_ref Public text
 
anio Public integer
 
site_comp_date Public date
 
site_update_date Public date
 
id_reporte Public integer
 
Operation
Public
cntr_site_pk (site_code: varchar, id_reporte: integer, ) :
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
Public
fk_cntr_site_cntr_mgmt (mgmt_id: numeric, id_reporte: integer, ) :
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
Public
fk_resp_id (resp_id: integer, id_reporte: integer, ) :
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
Element Source Role Target Role
«table» cntr_resp
Table «FK» 		Name: fk_resp_id
  		Name: cntr_resp_pk
 
Details:
 
«table» cntr_mgmt
Table «FK» 		Name: fk_cntr_site_cntr_mgmt
  		Name: cntr_mgmt_pk
 
Details:
 
Element Source Role Target Role
«table» cntr_site_biogeo
Table «FK» 		Name: cntr_site_biogeo_cntr_site_fk
  		Name: cntr_site_pk
 
Details:
 
«table» cntr_region
Table «FK» 		Name: cntr_region_cntr_site_fk
  		Name: cntr_site_pk
 
Details:
 
«table» cntr_national_dtype
Table «FK» 		Name: cntr_national_dtype_cntr_site_fk
  		Name: cntr_site_pk
 
Details:
 
«table» cntr_other_species
Table «FK» 		Name: cntr_other_species_cntr_site_fk
  		Name: cntr_site_pk
 
Details:
 
«table» cntr_habitat_class
Table «FK» 		Name: cntr_habitat_class_cntr_site_fk
  		Name: cntr_site_pk
 
Details:
 
«table» cntr_site_ownership
Table «FK» 		Name: cntr_site_ownership_cntr_site_fk
  		Name: cntr_site_pk
 
Details:
 
«table» cntr_species
Table «FK» 		Name: cntr_species_cntr_site_fk
  		Name: cntr_site_pk
 
Details:
 
«table» cntr_site_relation
Table «FK» 		Name: cntr_site_relation_cntr_site_fk
  		Name: cntr_site_pk
 
Details:
 
«table» cntr_impact
Table «FK» 		Name: cntr_impact_cntr_site_fk
  		Name: cntr_site_pk
 
Details:
 
«table» cntr_habitat
Table «FK» 		Name: cntr_habitat_cntr_site_fk
  		Name: cntr_site_pk
 
Details:
 
Tag Value
Owner espacio_protegido
Details:  
Property Value
isFinalSpecialization: 0