Shares

Id

INT [auto-generated] NOT NULL

ID of the share

ModuleGuid

UNIQUEIDENTIFIER NOT NULL

GUID of the module from where the object belongs to

SurveyId

INT FOREIGN KEY NULLABLE

ID of the survey from where the object belongs to

ObjectType

NVARCHAR(50) NOT NULL

Type of the shared object.

All of the below object types are used by AskiaPortal:

• survey

• email

• userprofile

• server

• application

ObjectId

INT NOT NULL

Id of the shared object

ContactType

INT NOT NULL

Type of the contact

• 0: User

• 1: Group

• 2: Every body

ContactId

INT NULLABLE

Id of the contact

Permission

INT NOT NULL

Permission of the share object

• 0: None

• 1: ReadOnly

• 2: EditOnly

• 4: FullControl (read, edit, delete, restore)

CanReshare

BIT NOT NULL

Indicates if the contact can re-share the object.

CreatedBy

INT FOREIGN KEY NOT NULL

Id of the user who has share the object

CreatedAt

DATETIME NOT NULL

Date of creation

UpdatedBy

INT FOREIGN KEY NOT NULL

Id of the latest user who has updated the share

UpdatedAt

DATETIME NOT NULL

Date of the latest update

IsDeleted

BIT NOT NULL

Indicates if the share is deleted

DeletedBy

INT FOREIGN KEY NULLABLE

Id of the user who has deleted the share

DeletedAt

DATETIME NULLABLE

Date of deletion