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

5.8.1.10.15 List of keys of the table Маршрут

Name

Code

Primary

Identifier_1

Identifier_1

X

5.8.1.10.16 Key Identifier_1 of the table Маршрут

5.8.1.10.16.1 Card of the key Identifier_1 of the table Маршрут

Name

Identifier_1

Code

Identifier_1

Table

Маршрут

5.8.1.10.16.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.10.16.3 List of columns of the table key Identifier_1

Name

Code

Номер точки маршрута

NomerMarshrut

5.8.1.10.16.4 List of all dependencies of the table key Identifier_1

Name

Code

Class Name

Marshrut_PK

Marshrut_PK

Index

Связанна с другой точкой маршрута

Marshrut_in_Marshrut

Reference

Маршрут рейса

Marshrut_in_Reys

Reference

5.8.1.10.17 List of indexes of the table Маршрут

Name

Code

Unique

Cluster

Primary

Foreign Key

Alternate Key

Marshrut_PK

Marshrut_PK

X

X

Client_in_Marshrut_FK

Client_in_Marshrut_FK

X

Zakaz_in_Marshrut_In_FK

Zakaz_in_Marshrut_In_FK

X

Marshrut_in_Marshrut_FK

Marshrut_in_Marshrut_FK

X

Zakaz_in_Marshrut_Out_FK

Zakaz_in_Marshrut_Out_FK

X

5.8.1.10.18 Index Marshrut_PK of the table Маршрут

5.8.1.10.18.1 Card of the index Marshrut_PK of the table Маршрут

Name

Marshrut_PK

Code

Marshrut_PK

Unique

Yes

Cluster

No

Primary

Yes

Foreign Key

No

Alternate Key

No

Table

Маршрут

5.8.1.10.18.2 Code preview of the index Marshrut_PK of the table Маршрут

 The preview is empty because of the setting.

 Check the generation option.

5.8.1.10.18.3 List of index columns of the index Marshrut_PK

Name

Code

Sort

Номер точки маршрута

NomerMarshrut

Ascending

5.8.1.10.19 Index Client_in_Marshrut_FK of the table Маршрут

5.8.1.10.19.1 Card of the index Client_in_Marshrut_FK of the table Маршрут

Name

Client_in_Marshrut_FK

Code

Client_in_Marshrut_FK

Unique

No

Cluster

No

Primary

No

Foreign Key

Yes

Alternate Key

No

Table

Маршрут

5.8.1.10.19.2 Code preview of the index Client_in_Marshrut_FK of the table Маршрут

 The preview is empty because of the setting.

 Check the generation option.

5.8.1.10.19.3 List of index columns of the index Client_in_Marshrut_FK

Name

Code

Sort

Код клиента

KodKlienta

Ascending

5.8.1.10.20 Index Zakaz_in_Marshrut_In_FK of the table Маршрут

5.8.1.10.20.1 Card of the index Zakaz_in_Marshrut_In_FK of the table Маршрут

Name

Zakaz_in_Marshrut_In_FK

Code

Zakaz_in_Marshrut_In_FK

Unique

No

Cluster

No

Primary

No

Foreign Key

Yes

Alternate Key

No

Table

Маршрут

5.8.1.10.20.2 Code preview of the index Zakaz_in_Marshrut_In_FK of the table Маршрут

 The preview is empty because of the setting.

 Check the generation option.

5.8.1.10.20.3 List of index columns of the index Zakaz_in_Marshrut_In_FK