IMPORTSOURCE (4.0SP20)

ID

uniqueidentifier

SITEID

uniqueidentifier

true

ADDEDBYID

uniqueidentifier

false

CHANGEDBYID

uniqueidentifier

false

NAME

nvarchar(100)

false

URLORPATH

nvarchar(255)

false

PORT

int

false

IMPERSONATE

bit

false

USERNAME

nvarchar(255)

false

PASSWORD

nvarchar(4000)

false

IMPORTSOURCETYPECODE

tinyint

false

IMPORTSOURCETYPE

nvarchar(17) (Computed)

true

DATEADDED

datetime

false

DATECHANGED

datetime

false

TS

timestamp

false

TSLONG

bigint (Computed)

true

IX_IMPORTSOURCE_DATEADDED

False

False

True

IX_IMPORTSOURCE_DATECHANGED

False

False

False

PK_IMPORTSOURCE

True

True

False

UC_IMPORTSOURCE_NAME

True

False

False

TR_IMPORTSOURCE_AUDIT_UPDATE

TR_IMPORTSOURCE_AUDIT_DELETE

IMPORTPROCESS

IMPORTSOURCEID