[dbo].[ujo_sys_ha

Property	Value
Row Count	1
Created	2:45:19 PM Saturday, July 19, 2008
Last Modified	2:45:20 PM Saturday, July 19, 2008

Property

Value

Row Count

Created

2:45:19 PM Saturday, July 19, 2008

Last Modified

2:45:20 PM Saturday, July 19, 2008

	Name	Data Type	Max Length (Bytes)	Allow Nulls
	id	int	4
	ha_state_id	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

Cluster Primary Key PK__ujo_sys_ha_state__76720F5D: id

int

ha_state_id

int

	Name	Columns	Unique
	PK__ujo_sys_ha_state__76720F5D	id

Name

Columns

Unique

PK__ujo_sys_ha_state__76720F5D

Name	Columns
fk_a_process_sys_ha_state	ha_state_id->[dbo].[ujo_ha_state].[id]

Name

Columns

fk_a_process_sys_ha_state

ha_state_id->[dbo].[ujo_ha_state].[id]

Type	Action	Owning Principal
Grant	Delete	ujoadmin
Grant	Insert	ujoadmin
Grant	Select	ujoadmin
Grant	Update	ujoadmin

Type

Action

Owning Principal

Grant

Delete

ujoadmin

Grant

Insert

ujoadmin

Grant

Select

ujoadmin

Grant

Update

ujoadmin

SQL Script

CREATE TABLE [dbo].[ujo_sys_ha_state]
(
[id] [int] NOT NULL,
[ha_state_id] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ujo_sys_ha_state] ADD CONSTRAINT [PK__ujo_sys_ha_state__76720F5D] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ujo_sys_ha_state] ADD CONSTRAINT [fk_a_process_sys_ha_state] FOREIGN KEY ([ha_state_id]) REFERENCES [dbo].[ujo_ha_state] ([id])
GO
GRANT SELECT ON  [dbo].[ujo_sys_ha_state] TO [ujoadmin]
GRANT INSERT ON  [dbo].[ujo_sys_ha_state] TO [ujoadmin]
GRANT DELETE ON  [dbo].[ujo_sys_ha_state] TO [ujoadmin]
GRANT UPDATE ON  [dbo].[ujo_sys_ha_state] TO [ujoadmin]
GO