Отчет об информационной системе транспортной компании, страница 17

Name	Адрес
Code	AddressKlienta
Data Type	varchar(100)
Mandatory	Yes

5.8.1.8.10.2 Check constraint name of the column Адрес of the table Клиент

CKC_ADDRESSKLIENTA_CLIENT

5.8.1.8.10.3 Check of the column Адрес of the table Клиент

Minimum value
Maximum value
Default value
Unit
Format
Uppercase	No
Lowercase	No
Cannot modify	No
List of values

5.8.1.8.10.4 Server validation rule of the column Адрес of the table Клиент

%MINMAX% and %LISTVAL% and %RULES%

5.8.1.8.10.5 List of extended attributes of the table column Адрес

Name	Data Type	Value	Target Name
ExtCkcNotForReplication	(Boolean)	false	Microsoft SQL Server 2000
ExtDeftConstName	(String)		Microsoft SQL Server 2000
ExtIdentityIncrement	(Integer)		Microsoft SQL Server 2000
ExtIdentitySeed	(Integer)		Microsoft SQL Server 2000
ExtIdtNotForReplication	(Boolean)	false	Microsoft SQL Server 2000
ExtNullConstName	(String)		Microsoft SQL Server 2000

5.8.1.8.11 List of keys of the table Клиент

Name	Code	Primary
Identifier_1	Identifier_1	X

5.8.1.8.12 Key Identifier_1 of the table Клиент

5.8.1.8.12.1 Card of the key Identifier_1 of the table Клиент

Name	Identifier_1
Code	Identifier_1
Table	Клиент

5.8.1.8.12.2 Code preview of the key Identifier_1 of the table Клиент

 The preview is empty because of the setting.

 Check the generation option.

5.8.1.8.12.3 List of columns of the table key Identifier_1

Name	Code
Код клиента	KodKlienta

5.8.1.8.12.4 List of all dependencies of the table key Identifier_1

Name	Code	Class Name
Client_PK	Client_PK	Index
Приезжаем к клиенту	Client_in_Marshrut	Reference

5.8.1.8.13 List of indexes of the table Клиент

Name	Code	Unique	Cluster	Primary	Foreign Key	Alternate Key
Client_PK	Client_PK	X		X

5.8.1.8.14 Index Client_PK of the table Клиент

5.8.1.8.14.1 Card of the index Client_PK of the table Клиент

Name	Client_PK
Code	Client_PK
Unique	Yes
Cluster	No
Primary	Yes
Foreign Key	No
Alternate Key	No
Table	Клиент

5.8.1.8.14.2 Code preview of the index Client_PK of the table Клиент

 The preview is empty because of the setting.

 Check the generation option.

5.8.1.8.14.3 List of index columns of the index Client_PK

Name	Code	Sort
Код клиента	KodKlienta	Ascending

5.8.1.9 Table Колонна

5.8.1.9.1 Card of table Колонна

Name	Колонна
Code	Kolonna
DBMS	Microsoft SQL Server 2000

5.8.1.9.2 Check constraint name of table Колонна

CKT_KOLONNA

5.8.1.9.3 Server validation rule of table Колонна

%RULES%

5.8.1.9.4 Code preview of table Колонна

/*==============================================================*/

/* Table: Kolonna                                               */

/*==============================================================*/

create table Kolonna (

   KodKolon             numeric              identity,

   KodAvto              numeric              null,

   KodDriver            numeric              null,