aud_organismo_aplicacion : Public <<table>> Table
| Created: |
03/06/2024 11:27:35 |
| Modified: |
03/06/2024 11:27:35 |
|
| Project: |
|
| Author: |
mmontalv |
| Version: |
1.0 |
| Phase: |
1.0 |
| Status: |
Proposed |
| Complexity: |
Easy |
| Difficulty: |
|
| Priority: |
|
| Multiplicity: |
|
| Advanced: |
|
| UUID: |
{52B1F8A7-346D-4ad0-A5C1-3A67CA4A1F03} |
| Appears In: |
ERD_Comun |
Tabla de auditoría de organismo_aplicacion<br/>
- Attributes
- Operations
- Associations To
- Tagged Values
- Advanced
| Attribute |
Scope |
Type |
|
id_organismo
|
Public
|
integer
|
|
|
|
rev
|
Public
|
bigint
|
|
Notes:
|
Identificador de la revisión<br/>
|
|
|
revtype
|
Public
|
integer
|
|
Notes:
|
Identificador del tipo de revisión<br/>
|
|
|
nombre
|
Public
|
varchar(2000)
|
|
Notes:
|
Nombre del organismo<br/>
|
|
|
telefono
|
Public
|
numeric(20)
|
|
Notes:
|
Telefono del organismo<br/>
|
|
|
persona_contacto
|
Public
|
varchar(1000)
|
|
Notes:
|
Persona de contacto<br/>
|
|
|
direccion
|
Public
|
varchar(2000)
|
|
Notes:
|
Direccion del organismo<br/>
|
|
|
email
|
Public
|
varchar(1000)
|
|
Notes:
|
Email del organismo<br/>
|
|
|
nombre_corto
|
Public
|
varchar(0)
|
|
Notes:
|
Abreviatura organismo<br/>
|
|
|
ccaa
|
Public
|
smallint
|
|
Notes:
|
CCAA donde se encuentra<br/>
|
|
|
id_aplicacion
|
Public
|
smallint
|
|
Notes:
|
Id de la aplicacion<br/>
|
|
|
id_org_app
|
Public
|
numeric(6)
|
|
Notes:
|
Es el identificador de la tabla<br/>
|
|
|
direcc_tipo_via
|
Public
|
varchar(500)
|
|
Notes:
|
Es el campo de spire thoroughfare<br/>
|
|
|
direcc_cod_postal
|
Public
|
integer
|
|
Notes:
|
Codigo postal de la provincia del organismo<br/>
|
|
|
direcc_nombre_localizador
|
Public
|
varchar(500)
|
|
Notes:
|
En inspire locatorname<br/>
|
|
|
direcc_inspire
|
Public
|
varchar(1000)
|
|
Notes:
|
campo inspare para la dirección (locatordesignator)<br/>
|
|
|
direcc_area
|
Public
|
varchar(500)
|
|
Notes:
|
campo de dirección inspire (addressarea)<br/>
|
|
|
id_provincia
|
Public
|
integer
|
|
Notes:
|
Identificador de la provincia<br/>
|
|
|
id_municipio
|
Public
|
integer
|
|
Notes:
|
Identificador del municipio del organismo<br/>
|
|
| Operation |
Public
pk_aud_organismo_aplicacion (rev: bigint,
id_org_app: numeric,
) :
|
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
|
Public
fk_aud_organismo_aplicacion_revision_info (rev: bigint,
) :
|
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
|
Public
fk_aud_organismo_aplicacion_revtype (revtype: integer,
) :
|
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
|
| Element |
Source Role |
Target Role |
«table» revision_info
Table «FK»
|
Name: fk_aud_organismo_aplicacion_revision_info
|
Name: revision_info_pk
|
Details:
|
«table» revtype
Table «FK»
|
Name: fk_aud_organismo_aplicacion_revtype
|
Name: revtype_pk
|
Details:
|
| Tag |
Value |
| Owner |
comun |
|
Details:
|
| Property |
Value |
| isFinalSpecialization: |
0 |