Model
/
Especie
/
Tables
/
taxon
Project:
Tables
taxon : Public <<table>> Table
Created:
03/06/2024 18:05:29
Modified:
03/06/2024 18:05:29
Project:
Author:
mmontalv
Version:
1.0
Phase:
1.0
Status:
Proposed
Complexity:
Easy
Difficulty:
Priority:
Multiplicity:
Advanced:
UUID:
{74E8E709-6A39-467c-AC3D-DA3CCF490283}
Appears In:
ERD_Especie
https://dwc.tdwg.org/terms/#taxon<br/>
Attributes
Operations
Associations To
Associations From
Tagged Values
Advanced
Attribute
Scope
Type
idtaxon
Public
numeric(40)
idgrupotax
Public
integer
idestadotaxon
Public
integer
id
Public
numeric(40)
idorigen
Public
integer
fecha_alta
Public
date
Notes:
Fecha de alta del taxon en la BDD.<br/>
fecha_baja
Public
date
Notes:
Fecha de baja del taxon (por pasar a considerarse sinónimo...)<br/>
cod_ambito
Public
varchar(2)
id_img_fototeca
Public
bigint
idorigen_canarias
Public
integer
Notes:
Fecha de alta del registro.<br/>
Operation
Public
TAXON_PK
(idtaxon: numeric, ) :
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
Public
taxon_estadotaxonfk
(idestadotaxon: integer, ) :
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
Public
taxon_idGrupoTax
(idgrupotax: integer, ) :
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
Public
taxon_origenfk
(idorigen: integer, ) :
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
Public
FK_ESPECIE_TAXON_T_AMBITO
(cod_ambito: varchar, ) :
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
Public
fk_taxon_t_origen_taxon
(idorigen_canarias: integer, ) :
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
Element
Source Role
Target Role
«table» t_estadotaxon
Table «FK»
Name:
taxon_estadotaxonfk
Name:
estadotaxon_pk
Details:
«table» t_origentaxon
Table «FK»
Name:
taxon_origenfk
Name:
ORIGENTAXON_pkey
Details:
«table» t_origentaxon
Table «FK»
Name:
fk_taxon_t_origen_taxon
Name:
ORIGENTAXON_pkey
Details:
Element
Source Role
Target Role
«table» taxondistribucion
Table «FK»
Name:
distribucion_taxonfk
Name:
TAXON_PK
Details:
«table» pliniancore-extension
Table «FK»
Name:
pliniancore_extension_taxonfk
Name:
TAXON_PK
Details:
«table» usos
Table «FK»
Name:
usos_taxonfk
Name:
TAXON_PK
Details:
«table» taxonplanesgestion
Table «FK»
Name:
taxonplanesgestion_taxonfk
Name:
TAXON_PK
Details:
«table» taxonhabitat
Table «FK»
Name:
fk_taxonhabitat_taxon
Name:
TAXON_PK
Details:
«table» taxon_medicion
Table «FK»
Name:
medidas_taxonk
Name:
TAXON_PK
Details:
«table» relacion_taxonomica
Table «FK»
Name:
relacion_taxonomica_relacionadofk
Name:
TAXON_PK
Details:
«table» taxonnombre
Table «FK»
Name:
taxonnombre_taxonfk
Name:
TAXON_PK
Details:
«table» endemismo
Table «FK»
Name:
endemismo_taxonfk
Name:
TAXON_PK
Details:
«table» taxonubicacion
Table «FK»
Name:
taxonubicacion_taxon_fk
Name:
TAXON_PK
Details:
«table» taxonfactoresamenaza
Table «FK»
Name:
taxonfactoresamenaza_taxonfk
Name:
TAXON_PK
Details:
«table» taxonviaintroduccion
Table «FK»
Name:
taxonviaintroduccion_taxonfk
Name:
TAXON_PK
Details:
«table» gis_geometria_especie
Table «FK»
Name:
gis_geometria_idtaxon_fk
Name:
TAXON_PK
Details:
«table» taxonestadolegal
Table «FK»
Name:
taxonestadolegal_taxonfk
Name:
TAXON_PK
Details:
«table» taxondataset
Table «FK»
Name:
taxondataset_taxonfk
Name:
TAXON_PK
Details:
«table» taxonreferencia
Table «FK»
Name:
taxonreferencia_taxonfk
Name:
TAXON_PK
Details:
«table» taxonmedidaconservacion
Table «FK»
Name:
taxonmedidaconservacion_taxonfk
Name:
TAXON_PK
Details:
«table» relacion_taxonomica
Table «FK»
Name:
relacion_taxonomica_taxonfk
Name:
TAXON_PK
Details:
«table» taxonestadoconservacion
Table «FK»
Name:
taxonestadoconservacion_taxonfk
Name:
TAXON_PK
Details:
«table» taxon_imagen
Table «FK»
Name:
FK_TAXON_IMAGEN_TAXON
Name:
TAXON_PK
Details:
Tag
Value
Owner
especie
Details:
Property
Value
isFinalSpecialization:
0