tbl_Service [Service]

Terrasoft CRM 3.0 SDK > Basic Configuration > Tables > System > tbl_Service [Service]

Contents

Index

tbl_Service [Service]

Property	Value
Name	tbl_Service
Caption	Service
Module	System
USI	System\Services\tbl_Service
Table Group	No
Is administrated by field	No
Is administrated by record	No
Record change is logged	No

#	Name	Type	Name
1.	ID	Identifier	Service
2.	Path	Unicode string [250]	Path
3.	Code	Unicode string [250]	Code
4.	ServiceTypeCode	Unicode string [250]	Service Type Code
5.	Caption	Unicode string [250]	Caption
6.	Description	Unicode string [250]	Description
7.	Version	Integer	Version
8.	LockedByUserID	Unique identifier GUID	Locked By
9.	CreatedOn	Date/Time	Created On
10.	CreatedByID	Unique identifier GUID	Created By
11.	ModifiedOn	Date/Time	Modification Date
12.	ModifiedByID	Unique identifier GUID	Modified By
13.	XMLData	Large binary object	XML Data
14.	DatabaseID	Unique identifier GUID	Database

#	Relation name	Field	Table	Cascade relation
1.	FService_LockedByUserID	LockedByUserID	tbl_AdminUnit	No

#	Name	Unique	Structure
1.	UIX_tbl_Service_Code	Yes	Code
2.	IService1	No	ModifiedByID
3.	IService2	No	LockedByUserID
4.	IService	No	DatabaseID

Copyright (с) Terrasoft 2002-2007.