Análisis y Desarrollo de una aplicación web para la gestión de protocolos de pruebas para transformadores serie 15k implementando el modelo se servicio SAAS de la plataforma de computación en la nube

(1)

Documento Modelo de Datos

Versión:

1.0 Creado:

20/10/2014

Último cambio:

20/10/2014

Fecha impresión:

14/02/3015

Entregado por:

William Cuadros

(2)

Tabla de Contenidos

Detalle del Modelo de Datos ... 3

Diagrama de datos ... 3

Vista ... 3

vw_cli_usuario ... 4

vw_transformador_cliente ... 4

vw_transformador_fabricante ... 4

General ... 4

gen_parametrica ... 4

Cliente ... 5

cli_cliente ... 5

cli_pedido ... 6

cli_peddetalle ... 8

Protocolo ... 9

plantilla_prueba ... 10

pro_proceso_has_prueba ... 11

pro_proceso ... 12

pro_ntc3396 ... 13

pro_ntc1465 ... 15

pro_ntc375 ... 16

pro_ntc471 ... 18

pro_ntc471_has_relacion ... 19

pro_ntc837 ... 20

pro_ntc1031 ... 21

pro_ntc1005 ... 22

Transformador ... 24

vw_transformador_pedido ... 25

tfr_caracteristicas ... 25

tfr_transformador ... 27

tfr_bodega ... 30

tfr_ordentrabajo ... 31

tfr_transf_has_cliente ... 32

(3)

Detalle del Modelo de Datos

Este documento provee una perspectiva general del modelo de datos. Para un reporte mas

simple y enfocado, simplemente copie esta plantilla inicial y de seleccione las secciones no

requeridas.

Diagrama de datos

Tipo:

Paquete

Paquete:

Vista de Diseño

Detalle:

Creado el 21/02/2015

.

Última modificación el 22/02/2015.

Notas:

Diagrama de datos

Creado por:

elChino el 23/08/2014

Última modificación:

10/05/2015,

Versión:

1.0 El diagrama define las tablas y relaciones necesarias para el almacenamiento y gestión de los datos de la aplicación,

inicialmente se trata de cumplir con las necesidades de información del dominio. En algunos casos se debe

considerar la restricciones del motor de base de datos que se plantea a utilizar.

Para la aplicación este modelo está considerado para el uso del motor de base de datos

SQL Server 2008

.

dm Diagrama de datos

EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version

General

+ gen_parametrica

Cliente

+ cli_cliente

+ cli_pedido

+ cli_peddetalle

Protocolo

+ plantilla_prueba

+ pro_proceso_has_prueba

+ pro_proceso

+ pro_ntc3396

+ pro_ntc1465

+ pro_ntc375

+ pro_ntc471

+ pro_ntc471_has_relacion

+ pro_ntc837

+ pro_ntc1031

+ pro_ntc1005

Transformador

+ tfr_caracteristicas

+ vw_transformador_pedido

+ tfr_transformador

+ tfr_bodega

+ tfr_ordentrabajo

+ tfr_transf_has_cliente

Vista

+ vw_cli_usuario

+ vw_transformador_cliente

+ vw_transformador_fabricante

«use»

Imagen: 1

Vista

Tipo:

Paquete

Paquete:

Diagrama de datos

Detalle:

Creado el 25/04/2015

.

Última modificación el 25/04/2015.

(4)

vw_cli_usuario

Base de datos:

SQL Server 2008,

Estereotipo:

«view»,

Paquete:

Vista

Detalle:

Creado el

26/04/2015.

Última modificación el

26/04/2015.

Notes:

vw_transformador_cliente

Base de datos:

SQL Server 2008,

Estereotipo:

«view»,

Paquete:

Vista

Detalle:

Creado el

26/04/2015.

Última modificación el

26/04/2015.

Notes:

vw_transformador_fabricante

Base de datos:

SQL Server 2008,

Estereotipo:

«view»,

Paquete:

Vista

Detalle:

Creado el

26/04/2015.

Última modificación el

26/04/2015.

Notes:

General

Tipo:

Paquete

Paquete:

Diagrama de datos

Detalle:

Creado el 23/08/2014

.

Última modificación el 21/02/2015.

Notas:

gen_parametrica

Base de datos:

SQL Server 2008,

Estereotipo:

«table»,

Paquete:

General

Detalle:

Creado el

23/08/2014.

Última modificación el

31/03/2015.

Notes:

Tabla que almacena toda las paramétricas requeridas por la aplicación.

Columnas

PK

Nombre

Tipo

No Nulo

Unico Longitud Precisión Escala Inicial Notas

True tipo

varchar

True

False 50

Tipo de

paramétrica,

por este

campo se

filtran los

valores de la

tabla.

True consecutivo tinyint

True

False

Consecutivo

del valor de la

paramétrica.

False descripcion varchar

False

False 200

Descripción

de la

paramétrica.

False valor

varchar

True

False 30

Valor de la

paramétrica.

False valor2

varchar

False

False 30

Propiedad

adiciona del

parámetro

Restricciones

(5)

Nombre

Tipo

Columnas

Código Inicial

Notas

PK_gen_parametrica

Public

tipo

consecutivo

Cliente

Tipo:

Paquete

Paquete:

Diagrama de datos

Detalle:

Creado el 23/08/2014

.

Última modificación el 21/02/2015.

Notas:

Cliente

Creado por:

elChino el 24/08/2014

Última modificación:

24/08/2014,

Versión:

1.0 dm Cliente

EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version

cli_cliente

«column»

*PK id :int

*

nombre :varchar(80)

*

tipdoc :tinyint

*

numdocumento :varchar(30)

direccion :varchar(80)

telefono :varchar(20)

tiptercero :int

«PK»

+

PK_cli_cliente(int)

cli_pedido

«column»

*PK id :int

*

consecutivo :int = 101

FK cliente_id :int

*

fechasolicitud :datetime

*

tipsolicitud :tinyint

cantidad :int

tiptransformador :tinyint

capacidad :tinyint

volentrada :tinyint

volsalida :tinyint

FK transformador_id :int

aprobado :bit

estado :tinyint

«FK»

+

FK_cli_pedido_cli_cliente(int)

+

FK_cli_pedido_tfr_transformador(int)

«PK»

+

PK_cli_pedido(int)

+FK_cli_pedido_cli_cliente

(cliente_id = id)

«FK»

+PK_cli_cliente

Imagen: 2

cli_cliente

Base de datos:

SQL Server 2008,

Estereotipo:

«table»,

Paquete:

Cliente

Detalle:

Creado el

09/09/2012.

Última modificación el

31/03/2015.

Notes:

Tabla donde almacena la información general del cliente.

Columnas

PK

Nombre

Tipo

No Nulo

Unico Longitud Precisión Escala Inicial Notas

True id

int

True

False

Identificador

del cliente.

False nombre

varchar

True

False 80

Campo para

(6)

servicio.

False tipdoc

tinyint

True

False

Tipo de

documento de

cliente

(paramétrica).

False numdocume

nto

varchar

True

False 30

Número de

documento

del cliente

False direccion

varchar

False

False 80

False telefono

varchar

False

False 20

False tiptercero

int

False

Tipo de

tercero a

almacenar:

1. Cliente

2. Proveedo

r

3. Ambos

Restricciones

Nombre

Tipo

Columnas

Código Inicial

Notas

PK_cli_cliente

Public

id

Relaciones

Columnas

Asociación

Notas

(cliente_id = id)

0..*

tfr_transf_has_cliente.FK_tfr_transf_has_cliente_cli_

cliente

1 cli_cliente.PK_cli_cliente

(cliente_id = id)

*

cli_pedido.FK_cli_pedido_cli_cliente

1 cli_cliente.PK_cli_cliente

cli_pedido

Base de datos:

SQL Server 2008,

Estereotipo:

«table»,

Paquete:

Cliente

Detalle:

Creado el

09/09/2012.

Última modificación el

31/03/2015.

Notes:

Tabla donde almacena la información general del pedido de suministro o servicio.

Columnas

PK

Nombre

Tipo

No Nulo

Unico Longitud Precisión Escala Inicial Notas

True id

int

True

False

Identificador

del pedido.

False consecutivo int

True

False

101 Número de

solicitud

entregado al

cliente.

False cliente_id

int

False

False 0

0

0 False fechasolicitu

d

datetime

True

False

Se almacena

la fecha de

creación del

pedido.

False tipsolicitud tinyint

True

False

Tipo de

(7)

(paramétrica).

- 1 tipo

"Servicio".

- 2 tipo

"Suministro".

- 3 tipo

"Reparación",

cuando se

selecciono

"Servicio".

- 4 tipo

"Mantenimie

nto", cuando

se selecciono

"Servicio".

False cantidad

int

False

Suministro:

Número de

transformador

es a fabricar.

False tiptransform

ador

tinyint

False

Tipo de

transformador

(paramétrica).

False capacidad

tinyint

False

Suministro:

Capacidad de

transformador

(paramétrica).

False volentrada

tinyint

False

Suministro:

Voltaje de

entrada del

transformador

(paramétrica).

False volsalida

tinyint

False

Suministro:

Voltaje de

salida del

transformador

(paramétrica).

False transformad

or_id

int

False

False 0

0

0 Servicio:

Identificador

de

transformador

.

False aprobado

bit

False

Tiene el valor

de 1 cuando

la solicitud

está

aprobada.

- Si es tipo

"Suministro"

se aprueba

automáticame

nte.

(8)

sea de

tipo"Reparaci

ón" o

"Mantenimie

nto".

False estado

tinyint

False

Estado del

pedido, se

manejan:

activo o

terminado

(Paramétrica).

Restricciones

Nombre

Tipo

Columnas

Código Inicial

Notas

FK_cli_pedido_cli_cliente

Public

cliente_id

FK_cli_pedido_tfr_transform

ador

Public

transformador_id

PK_cli_pedido

Public

id

Relaciones

Columnas

Asociación

Notas

(pedido_id = id)

1 pro_proceso.FK_pro_proceso_cli_pedido

1 cli_pedido.PK_cli_pedido

(pedido_id = id)

0..*

tfr_ordentrabajo.FK_tfr_ordentrabajo_cli_pedido

1 cli_pedido.PK_cli_pedido

(transformador_id = id)

1 cli_pedido.FK_cli_pedido_tfr_transformador

1 tfr_transformador.PK_tfr_transformador

(cliente_id = id)

*

cli_pedido.FK_cli_pedido_cli_cliente

1 cli_cliente.PK_cli_cliente

cli_peddetalle

Base de datos:

SQL Server 2008,

Estereotipo:

«table»,

Paquete:

Cliente

Detalle:

Creado el

09/09/2012.

Última modificación el

31/03/2015.

Notes:

Tabla donde almacena el detalle de la respectiva

Columnas

PK

Nombre

Tipo

No Nulo

Unico Longitud Precisión Escala Inicial Notas

True id

int

True

False

Identificador

para el detalle

del pedido de

suministro o

servicio

(reparación o

mantenimient

o).

False pedido_id

bigint

False

False cantidad

bigint

False

Número de

transformador

es

Restricciones

Nombre

Tipo

Columnas

Código Inicial

Notas

(9)

Nombre

Tipo

Columnas

Código Inicial

Notas

Protocolo

Tipo:

Paquete

Paquete:

Diagrama de datos

Detalle:

Creado el 24/08/2014

.

Última modificación el 21/02/2015.

Notas:

Protocolo

Creado por:

elChino el 14/09/2014

(10)

dm Protocolo

EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version EA 10.0 Unregistered Trial Version

pro_ntc3396 FK fabricante_id :int

altura :varchar(6) FK cliente_id :int * fechasolicitud :datetime FK transformador_id :int

aprobado :bit FK transformador_id :int

proceso_id :int FK transformador_id :int

(11)

Base de datos:

SQL Server 2008,

Estereotipo:

«table»,

Paquete:

Protocolo

Detalle:

Creado el

28/09/2014.

Última modificación el

25/04/2015.

Notes:

Este tabla almacena los resultados de la pruebas de Medición

Columnas

PK

Nombre

Tipo

No Nulo

Unico Longitud Precisión Escala Inicial Notas

False id

int

True

False

Identificador

de prueba

False transformad

or_id

int

False

Identificador

de

transformador

False proceso_id

int

False

Identificador

del proceso

de pruebas a

la que se ha

asignado la

prueba.

False fecha

datetime

False

Fecha de

realización de

prueba.

False resultado

tinyint

False

Se verifica si

la prueba fue

exitosa o no

exitosa

(Paramétrica).

False terminado

tinyint

False

Especifica si

la prueba ha

sido

terminada o

no: 1 Abierta,

2 Cerrada.

pro_proceso_has_prueba

Base de datos:

SQL Server 2008,

Estereotipo:

«table»,

Paquete:

Protocolo

Detalle:

Creado el

27/09/2014.

Última modificación el

25/04/2015.

Notes:

Esta tabla permite relacionar las pruebas definidas para un proceso de pruebas preliminares como

de protocolo.

Columnas

PK

Nombre

Tipo

No Nulo

Unico Longitud Precisión Escala Inicial Notas

True proceso_id

int

True

False

Identificador

del proceso

de pruebas.

True pro_prueba_

id

int

True

False

Registro de la

prueba

False fecha

datetime

False

Fecha de

realización de

prueba.

False resultado

tinyint

False

Se verifica si

la prueba fue

exitosa o no

exitosa

(Paramétrica).

(12)

Nombre

Tipo

Columnas

Código Inicial

Notas

FK_pro_proceso_has_prueba

_pro_proceso

Public

proceso_id

PK_pro_proceso_has_prueba

Public

proceso_id

pro_prueba_id

Relaciones

Columnas

Asociación

Notas

pro_proceso_has_prueba.

pro_ntc1031.

pro_proceso_has_prueba.

pro_ntc3396.

pro_proceso_has_prueba.

pro_ntc1465.

(proceso_id = id)

0..*

pro_proceso_has_prueba.FK_pro_proceso_has_prueb

a_pro_proceso

1 pro_proceso.PK_pro_proceso

pro_proceso_has_prueba.

pro_ntc471.

pro_ntc837.

pro_proceso_has_prueba.

pro_ntc375.

pro_proceso_has_prueba.

pro_ntc1005.

pro_proceso

Base de datos:

SQL Server 2008,

Estereotipo:

«table»,

Paquete:

Protocolo

Detalle:

Creado el

27/09/2014.

Última modificación el

25/04/2015.

Notes:

Esta tabla almacena la información de los procesos de pruebas preliminares y de protocolo.

Columnas

PK

Nombre

Tipo

No Nulo

Unico Longitud Precisión Escala Inicial Notas

True id

int

True

False

Identificador

del proceso

de pruebas.

False pedido_id

int

False

Identificador

del pedido.

False tipprocesop tinyint

False

Tipo de

proceso de

pruebas

(Paramétrica).

False fecha

datetime

False

Fecha de

creación del

proceso.

False estado

int

False

Estado del

proceso de

pruebas.

False resultado

tinyint

False

Se verifica si

(13)

False tempensayo int

False

Temperatura

en la que se

realiza los

ensayos, en

grados

centígrados.

False posconmuta

dor

tinyint

False

Posición del

conmutador

en la que se

realiza los

ensayos.

Restricciones

Nombre

Tipo

Columnas

Código Inicial

Notas

FK_pro_proceso_cli_pedido

Public

pedido_id

PK_pro_proceso

Public

id

Relaciones

Columnas

Asociación

Notas

(pedido_id = id)

1 pro_proceso.FK_pro_proceso_cli_pedido

1 cli_pedido.PK_cli_pedido

(proceso_id = id)

0..*

pro_proceso_has_prueba.FK_pro_proceso_has_prueb

a_pro_proceso

1 pro_proceso.PK_pro_proceso

pro_ntc3396

Base de datos:

SQL Server 2008,

Estereotipo:

«table»,

Paquete:

Protocolo

Detalle:

Creado el

14/09/2014.

Última modificación el

25/04/2015.

Notes:

En esta tabla se almacena la información de la prueba para transformadores "Pintura de tanques

para transformador" (12).

Columnas

PK

Nombre

Tipo

No Nulo

Unico Longitud Precisión Escala Inicial Notas

True id

int

True

False

Identificador

de la prueba

NTC 3396

False transformad

or_id

int

True

False

Identificador

de

transformador

a realizar

prueba.

False proceso_id

int

False

Identificador

del proceso

de pruebas a

la que se ha

asignado la

prueba.

False fecha

datetime

True

False

Fecha de

realización de

prueba.

False resultado

tinyint

False

Se verifica si

(14)

exitosa o no

exitosa

(Paramétrica).

False estado

bigint

False

Especifica si

la prueba ha

sido

terminada o

no: 1 abierta,

2 terminada.

False color

varchar

False

False 12

Nombre del

color,

predetermina

do se coloca

RAL 70.

False salina1

tinyint

False

Se verifica si

la prueba en

solución

ambiente 1

fue exitosa o

no exitosa

(Paramétrica).

False salina2

tinyint

False

Se verifica si

la prueba en

solución

ambiente 2

fue exitosa o

no exitosa

(Paramétrica).

False impacto

tinyint

False

Se verifica si

la prueba de

impacto a 60

libras/pulgada

. fue exitosa o

no exitosa

(Paramétrica).

False espesorvalor numeric

False

5

0 Espesor de la

pintura

aplicada al

tanque.

False espesor1

tinyint

False

Se verifica si

el espesor es

mayor a 110

micras es

exitosa en el

ambiente 1

(Paramétrica).

False espesor2

tinyint

False

Se verifica si

el espesor es

mayor a 110

micras es

exitosa en el

ambiente 2

(Paramétrica).

False adherencia

decimal

False

5

0 Valor de la

(15)

Restricciones

Nombre

Tipo

Columnas

Código Inicial

Notas

FK_pro_ntc3396_tfr_transfor

mador

Public

transformador_id

PK_pro_ntc3396

Public

id

Relaciones

Columnas

Asociación

Notas

pro_proceso_has_prueba.

pro_ntc3396.

CU_PRO012 - Gestionar prueba norma NTC 3396

Pinturas para tanques de transformadores.

pro_ntc3396.

(transformador_id = id)

1 pro_ntc3396.FK_pro_ntc3396_tfr_transformador

*

tfr_transformador.PK_tfr_transformador

pro_ntc1465

Base de datos:

SQL Server 2008,

Estereotipo:

«table»,

Paquete:

Protocolo

Detalle:

Creado el

28/09/2014.

Última modificación el

25/04/2015.

Notes:

Este tabla almacena los resultados de la pruebas de Medición "Líquido aislante" (1).