aud_t_norma : Public <<table>> Table
| Created: |
20/10/2026 13:02:50 |
| Modified: |
20/10/2026 13:02:50 |
|
| Project: |
|
| Author: |
gbenito1 |
| Version: |
1.0 |
| Phase: |
1.0 |
| Status: |
Proposed |
| Complexity: |
Easy |
| Difficulty: |
|
| Priority: |
|
| Multiplicity: |
|
| Advanced: |
|
| UUID: |
{77302A3C-ABD9-4f50-94F2-1BA92F55FAFD} |
| Appears In: |
DER_comun |
Tabla de auditoría de t_norma<br/>
- Attributes
- Operations
- Associations To
- Tagged Values
- Advanced
| Attribute |
Scope |
Type |
|
id_norma
|
Public
|
numeric(20)
|
|
Notes:
|
Identificador de la legislación<br/>
|
|
|
rev
|
Public
|
bigint
|
|
Notes:
|
Identificador de la revisión<br/>
|
|
|
revtype
|
Public
|
integer
|
|
Notes:
|
Identificador del tipo de revisión<br/>
|
|
|
norma
|
Public
|
varchar(1250)
|
|
|
|
id_rango_norma_sup
|
Public
|
integer
|
|
Notes:
|
Tipo de Legislación<br/>
|
|
|
anio
|
Public
|
smallint
|
|
Notes:
|
Año de la Legislación<br/>
|
|
|
para_informe
|
Public
|
varchar(2)
|
|
Notes:
|
Indica si se utlizará en informe o no , valores: SI o NO<br/>
|
|
|
fecha
|
Public
|
timestamp without time zone(0)
|
|
Notes:
|
Fecha de la nomra<br/>
|
|
|
id_organismo
|
Public
|
integer
|
|
Notes:
|
Id del organismo<br/>
|
|
|
id_usuario
|
Public
|
integer
|
|
Notes:
|
Id usuario que da de lata la norma<br/>
|
|
|
id_rango_norma_int
|
Public
|
integer
|
|
Notes:
|
Id. de rango de norma intermedio<br/>
|
|
|
id_rango_norma_inf
|
Public
|
integer
|
|
Notes:
|
Id. de rango de norma de nivel Inferior<br/>
|
|
|
id_aplicacion
|
Public
|
integer
|
|
Notes:
|
Id. de la plación que dio de alta la legislacion<br/>
|
|
|
nombre_corto
|
Public
|
varchar(250)
|
|
Notes:
|
Nombre corto de la legislacion<br/>
|
|
|
url
|
Public
|
varchar(2000)
|
|
Notes:
|
URL de la legislacion<br/>
|
|
|
fecha_creacion
|
Public
|
timestamp without time zone(0)
|
|
|
|
fecha_modificacion
|
Public
|
timestamp without time zone(0)
|
|
|
|
id_usuario_crea_registro
|
Public
|
integer
|
|
|
|
id_usuario_modifica_registro
|
Public
|
integer
|
|
|
|
id_clasif_objetivo_norma
|
Public
|
integer
|
|
|
|
id_ambito_nivel_geografico_politico
|
Public
|
smallint
|
|
|
|
id_visible
|
Public
|
integer
|
|
Notes:
|
Campo para indicar si es visible o no la norma. 1 significa que si, 0 no es visible. Por defecto 1<br/>
|
|
|
codigo_norma_oficial
|
Public
|
varchar(100)
|
|
Notes:
|
Este campo se corresponde con el identificador oficial de la norma en el BOE que se haya publicado.<br/>
|
|
|
id_boletin
|
Public
|
integer
|
|
Notes:
|
Identificador del boletín donde se publica<br/>
|
|
| Operation |
Public
pk_aud_t_norma (rev: bigint,
id_norma: numeric,
) :
|
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
|
Public
fk_aud_t_norma_revision_info (rev: bigint,
) :
|
Details:
[ Is static False. Is abstract False. Is return array False. Is query False. Is synchronized False. ]
|
Public
fk_aud_t_norma_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_t_norma_revision_info
|
Name: revision_info_pk
|
Details:
|
«table» revtype
Table «FK»
|
Name: fk_aud_t_norma_revtype
|
Name: revtype_pk
|
Details:
|
| Tag |
Value |
| Owner |
comun |
|
Details:
|
| Property |
Value |
| isFinalSpecialization: |
0 |
