Model / Comun / Tables / especimen

Project:
especimen : Public <<table>> Table
Created: 03/06/2024 11:27:45
Modified: 03/06/2024 11:27:45
Project:
Advanced:
  • Attributes
  • Operations
  • Associations To
  • Associations From
  • Tagged Values
  • Advanced
Attribute Scope Type
id_especimen Public bigint
AutoNum=1
Increment=1
property=AutoNum=1;StartNum=18263;Increment=1;
SequenceName=especimen_sec
StartNum=18263
 
id_especimen_especifico Public numeric(20)
 
id_taxon Public bigint
 
id_hibrido Public bigint
 
id_cites Public bigint
 
fecha_alta_nacimiento_puesta Public date
 
fecha_baja Public date
 
cod_marcado Public varchar(100)
 
id_especimen_padre Public bigint
 
id_especimen_madre Public bigint
 
id_motivo_baja Public integer
 
id_motivo_alta Public integer
 
id_sexo Public integer
 
id_tipo_marcado Public integer
 
certificado_cite Public varchar(0)
 
cod_anexo Public varchar(10)
Notes: Los valores posibles son  A o B<br/>
fecha_eclosion Public date
 
estado_fisico Public text
 
id_centro Public bigint
 
tiene_proced_adminis Public integer
Notes: el valor 1  indica sí, 0 no tiene procedimiento judicial<br/>
tiene_proced_judicial Public integer
 
cod_proced_adminis Public varchar(200)
 
cod_proced_judicial Public varchar(200)
 
id_estado_validacion Public integer
 
fecha_creacion Public timestamp without time zone(0)
Notes: Fecha que indica la creacion del registro<br/>
fecha_modificacion Public timestamp without time zone(0)
Notes: Fecha que indica la modificacion del registro<br/>
id_usuario_crea_registro Public integer
Notes: Identificador del usuario que crea el registro<br/>
id_usuario_modifica_registro Public integer
Notes: Identificador del usuario que modifica el registro<br/>
detalle_baja Public varchar(0)
 
centro_cesion Public text
Notes: Campo que edita el usaurio para idicar el centro al que se vende o cede el especimen<br/>
depositador Public text
 
id_aplicacion Public integer
Notes: Id de la aplicación de registra el especiemen<br/>
Operation
Public
ESPECIMEN_pkey (id_especimen: bigint, ) :
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
Public
uq_especimen_codmarcado (cod_marcado: varchar, ) :
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
Public
FK_ESPECIMENO_EST_VALIDACION (id_estado_validacion: integer, ) :
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
Public
FK_ESPECIMEN_CENTRO (id_centro: bigint, ) :
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
Public
FK_ESPECIMEN_ID_HIBRIDO (id_hibrido: bigint, ) :
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
Public
FK_ESPECIMEN_ID_MADRE (id_especimen: bigint, ) :
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
Public
FK_ESPECIMEN_ID_MOTIV_ALTA (id_motivo_alta: integer, ) :
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
Public
FK_ESPECIMEN_ID_MOTIV_BAJA (id_motivo_baja: integer, ) :
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
Public
FK_ESPECIMEN_ID_PADRE (id_especimen: bigint, ) :
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
Public
FK_ESPECIMEN_ID_TAXON (id_taxon: bigint, ) :
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
Public
FK_ESPECIMEN_SEXO (id_sexo: integer, ) :
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
Public
FK_ESPECIMEN_TIPO_MARCAJE (id_tipo_marcado: integer, ) :
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
Public
FK_ESPECIMEN_T_APLICACION (id_aplicacion: integer, ) :
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
Public
especimen_fk (id_cites: bigint, ) :
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
Element Source Role Target Role
«table» t_sexo
Table «FK» 		Name: FK_ESPECIMEN_SEXO
  		Name: t_sexo_pkey
 
Details:
 
«table» t_aplicacion
Table «FK» 		Name: FK_ESPECIMEN_T_APLICACION
  		Name: T_APLICACION_pkey
 
Details:
 
«table» especimen
Table «FK» 		Name: FK_ESPECIMEN_ID_MADRE
  		Name: ESPECIMEN_pkey
 
Details:
 
«table» especimen
Table «FK» 		Name: FK_ESPECIMEN_ID_PADRE
  		Name: ESPECIMEN_pkey
 
Details:
 
Element Source Role Target Role
«table» especimen
Table «FK» 		Name: FK_ESPECIMEN_ID_MADRE
  		Name: ESPECIMEN_pkey
 
Details:
 
«table» especimen
Table «FK» 		Name: FK_ESPECIMEN_ID_PADRE
  		Name: ESPECIMEN_pkey
 
Details:
 
Tag Value
Owner comun
Details:  
Property Value
isFinalSpecialization: 0