pliniancore-extension : Public <<table>> Table
| Created: |
03/06/2024 18:05:17 |
| Modified: |
03/06/2024 18:05:17 |
|
| Project: |
|
| Author: |
mmontalv |
| Version: |
1.0 |
| Phase: |
1.0 |
| Status: |
Proposed |
| Complexity: |
Easy |
| Difficulty: |
|
| Priority: |
|
| Multiplicity: |
|
| Advanced: |
|
| UUID: |
{982C1DF0-08D9-4da5-AA2D-4EC0CA928D0C} |
| Appears In: |
ERD_Especie |
Tabla que recoge información no estructurada del taxon<br/>
- Attributes
- Operations
- Associations To
- Tagged Values
- Advanced
| Attribute |
Scope |
Type |
|
idtaxon
|
Public
|
numeric(40)
|
|
Notes:
|
Id. del taxon.<br/>
|
|
|
iddataset
|
Public
|
numeric(40)
|
|
Notes:
|
Id. del conjunto de datos del que proviene la información.<br/>
|
|
|
idatributo
|
Public
|
numeric(40)
|
|
Notes:
|
Id. del atributo<br/>
|
|
|
valor
|
Public
|
varchar(0)
|
|
Notes:
|
Información de un taxon según una colección concreta relativa a un atributo determinado.<br/>
|
|
|
id
|
Public
|
bigint
|
AutoNum=1
Increment=1
property=AutoNum=1;StartNum=1;Increment=1;
SequenceName=sec_id_plinian
StartNum=1
|
|
idfuente
|
Public
|
integer
|
|
Notes:
|
Id. de la fuente bibliográfica de la información.<br/>
|
|
|
prioritario
|
Public
|
boolean
|
|
Notes:
|
Indica la descripción prioritaria o pricipal del taxon.<br/>
|
|
|
fecha_alta
|
Public
|
date
|
|
|
|
fecha_baja
|
Public
|
date
|
|
|
|
idvigente
|
Public
|
integer
|
|
|
|
url
|
Public
|
varchar(255)
|
|
|
|
id_usuario_crea_registro
|
Public
|
integer
|
|
Notes:
|
Id de usuario que ha creado el registro<br/>
|
|
|
id_usuario_modifica_registro
|
Public
|
integer
|
|
Notes:
|
Id de usuario que ha modificado el registro<br/>
|
|
|
fecha_creacion
|
Public
|
timestamp without time zone(0)
|
|
Notes:
|
Fecha de creacion del registro<br/>
|
|
|
fecha_modificacion
|
Public
|
timestamp without time zone(0)
|
|
Notes:
|
Fecha de modificacion del registro<br/>
|
|
| Operation |
Public
pliniancore_extension_pk (idtaxon: numeric,
iddataset: numeric,
idatributo: numeric,
idfuente: integer,
) :
|
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
|
Public
pliniancore_extension_atributofk (idatributo: numeric,
) :
|
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
|
Public
pliniancore_extension_datasetfk (iddataset: numeric,
) :
|
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
|
Public
pliniancore_extension_taxonfk (idtaxon: numeric,
) :
|
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
|
Public
FK_USUARIO_CREA (id_usuario_crea_registro: integer,
) :
|
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
|
Public
FK_USUARIO_MODIFICA (id_usuario_modifica_registro: integer,
) :
|
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
|
Public
pliniancore_extension_fuentefk (idfuente: integer,
) :
|
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
|
| Element |
Source Role |
Target Role |
«table» taxon
Table «FK»
|
Name: pliniancore_extension_taxonfk
|
Name: TAXON_PK
|
Details:
|
«table» t_dataset
Table «FK»
|
Name: pliniancore_extension_datasetfk
|
Name: dataset_pk
|
Details:
|
«table» t_fuente
Table «FK»
|
Name: pliniancore_extension_fuentefk
|
Name: fuente_pk
|
Details:
|
«table» t_atributo
Table «FK»
|
Name: pliniancore_extension_atributofk
|
Name: atributo_pk
|
Details:
|
| Tag |
Value |
| Owner |
especie |
|
Details:
|
| Property |
Value |
| isFinalSpecialization: |
0 |