[dbo].[usm_mr_ievent

Property	Value
Heap
Row Count	48
Created	11:08:05 AM Wednesday, March 07, 2007
Last Modified	1:17:01 PM Tuesday, March 30, 2010

Property

Value

Heap

Row Count

Created

11:08:05 AM Wednesday, March 07, 2007

Last Modified

1:17:01 PM Tuesday, March 30, 2010

Name	Data Type	Max Length (Bytes)
import_id	int	4
insert_time	int	4
load_status	int	4
load_from	datetime	8
load_to	datetime	8
file_id	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

import_id

int

insert_time

int

load_status

int

load_from

datetime

load_to

datetime

file_id

int

Name	Columns
$usm_m_r00002d8d00000000	file_id->[dbo].[usm_mr_ifile].[id]
$usm_m_r00002d9700000000	import_id->[dbo].[usm_mr_import].[id]

Name

Columns

$usm_m_r00002d8d00000000

file_id->[dbo].[usm_mr_ifile].[id]

$usm_m_r00002d9700000000

import_id->[dbo].[usm_mr_import].[id]

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

Type

Action

Owning Principal

Grant

Delete

usmgroup

Grant

Insert

usmgroup

Grant

Select

usmgroup

Grant

Update

usmgroup

SQL Script

CREATE TABLE [dbo].[usm_mr_ievent_load]
(
[import_id] [int] NULL,
[insert_time] [int] NULL,
[load_status] [int] NULL,
[load_from] [datetime] NULL,
[load_to] [datetime] NULL,
[file_id] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_mr_ievent_load] ADD CONSTRAINT [$usm_m_r00002d8d00000000] FOREIGN KEY ([file_id]) REFERENCES [dbo].[usm_mr_ifile] ([id])
GO
ALTER TABLE [dbo].[usm_mr_ievent_load] ADD CONSTRAINT [$usm_m_r00002d9700000000] FOREIGN KEY ([import_id]) REFERENCES [dbo].[usm_mr_import] ([id])
GO
GRANT SELECT ON  [dbo].[usm_mr_ievent_load] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_mr_ievent_load] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_mr_ievent_load] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_mr_ievent_load] TO [usmgroup]
GO