ASIGNARED Nombre id_asignet id_mac id_red Ip id_sitio Observa
Tipo de Dato integer character varying(20) integer integer integer character varying(100)
Si
¿Clave Primaria? Si
No
No
No No No
No No No
No
No
¿No Nulo?
Defecto
Comentario
Restricciones Nombre asignared_pkey
Tipo Clave primaria
asignared_id_mac_fkey Clave ajena asignared_id_red_fkey Clave ajena asignared_id_sitio_fkey Clave ajena
Definición (id_asignet) (id_mac) REFERENCES macs (id_mac) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION (id_red) REFERENCES redes (id_red) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION (id_sitio) REFERENCES sitios (id_sitio) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION