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

5.8.1.7.13.4 List of all dependencies of the table key Identifier_1

Name	Code	Class Name
Zakaz_PK	Zakaz_PK	Index
Загружаемый заказ в точке маршрута	Zakaz_in_Marshrut_In	Reference
Выгружаемый заказ в точке маршрута	Zakaz_in_Marshrut_Out	Reference

5.8.1.7.14 List of indexes of the table Заказ

Name	Code	Unique	Cluster	Primary	Foreign Key	Alternate Key
Zakaz_PK	Zakaz_PK	X		X
Tovar_in_Zakaz_FK	Tovar_in_Zakaz_FK				X
Manager_in_Zakaz_FK	Manager_in_Zakaz_FK				X

5.8.1.7.15 Index Zakaz_PK of the table Заказ

5.8.1.7.15.1 Card of the index Zakaz_PK of the table Заказ

Name	Zakaz_PK
Code	Zakaz_PK
Unique	Yes
Cluster	No
Primary	Yes
Foreign Key	No
Alternate Key	No
Table	Заказ

5.8.1.7.15.2 Code preview of the index Zakaz_PK of the table Заказ

 The preview is empty because of the setting.

 Check the generation option.

5.8.1.7.15.3 List of index columns of the index Zakaz_PK

Name	Code	Sort
ID Заказа	IDZakaz	Ascending

5.8.1.7.16 Index Tovar_in_Zakaz_FK of the table Заказ

5.8.1.7.16.1 Card of the index Tovar_in_Zakaz_FK of the table Заказ

Name	Tovar_in_Zakaz_FK
Code	Tovar_in_Zakaz_FK
Unique	No
Cluster	No
Primary	No
Foreign Key	Yes
Alternate Key	No
Table	Заказ

5.8.1.7.16.2 Code preview of the index Tovar_in_Zakaz_FK of the table Заказ

 The preview is empty because of the setting.

 Check the generation option.

5.8.1.7.16.3 List of index columns of the index Tovar_in_Zakaz_FK

Name	Code	Sort
Код товара	KodTovar	Ascending

5.8.1.7.17 Index Manager_in_Zakaz_FK of the table Заказ

5.8.1.7.17.1 Card of the index Manager_in_Zakaz_FK of the table Заказ

Name	Manager_in_Zakaz_FK
Code	Manager_in_Zakaz_FK
Unique	No
Cluster	No
Primary	No
Foreign Key	Yes
Alternate Key	No
Table	Заказ

5.8.1.7.17.2 Code preview of the index Manager_in_Zakaz_FK of the table Заказ

 The preview is empty because of the setting.

 Check the generation option.

5.8.1.7.17.3 List of index columns of the index Manager_in_Zakaz_FK

Name	Code	Sort
Код менеджера	KodMenedger	Ascending

5.8.1.8 Table Клиент

5.8.1.8.1 Card of table Клиент

Name	Клиент
Code	Client
DBMS	Microsoft SQL Server 2000

5.8.1.8.2 Check constraint name of table Клиент

CKT_CLIENT

5.8.1.8.3 Server validation rule of table Клиент

%RULES%

5.8.1.8.4 Code preview of table Клиент

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

/* Table: Client                                                */

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

create table Client (

   KodKlienta           numeric              identity,

   NaimenKlienta        char(30)             not null,

   AddressKlienta       varchar(100)         not null,

   constraint PK_CLIENT primary key  (KodKlienta)

)

go

5.8.1.8.5 List of diagrams containing the table Клиент

Name	Code
Diagram_1	Diagram_1

5.8.1.8.6 List of extended attributes of the table Клиент