CREATE TABLE [dbo].[ujo_ha_process]
(
[pid] [int] NOT NULL,
[time_stamp] [int] NOT NULL,
[hostname] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ha_designator_id] [int] NOT NULL,
[ha_status_id] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ujo_ha_process] ADD CONSTRAINT [fk_ha_process_ha_designator] FOREIGN KEY ([ha_designator_id]) REFERENCES [dbo].[ujo_ha_designator] ([id])
GO
ALTER TABLE [dbo].[ujo_ha_process] ADD CONSTRAINT [fk_ha_process_ha_status] FOREIGN KEY ([ha_status_id]) REFERENCES [dbo].[ujo_ha_status] ([id])
GO
GRANT SELECT ON [dbo].[ujo_ha_process] TO [ujoadmin]
GRANT INSERT ON [dbo].[ujo_ha_process] TO [ujoadmin]
GRANT DELETE ON [dbo].[ujo_ha_process] TO [ujoadmin]
GRANT UPDATE ON [dbo].[ujo_ha_process] TO [ujoadmin]
GO
[dbo].[ujo_ha_process]
![Foreign Keys fk_ha_process_ha_designator: [dbo].[ujo_ha_designator].ha_designator_id](../../Images/fk.gif)