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

Name	Reys_PK
Code	Reys_PK
Unique	Yes
Cluster	No
Primary	Yes
Foreign Key	No
Alternate Key	No
Table	Рейс

5.8.1.12.18.2 Code preview of the index Reys_PK of the table Рейс

 The preview is empty because of the setting.

 Check the generation option.

5.8.1.12.18.3 List of index columns of the index Reys_PK

Name	Code	Sort
Номер Рейса	ReisNumber	Ascending

5.8.1.12.19 Index Marshrut_in_Reys_FK of the table Рейс

5.8.1.12.19.1 Card of the index Marshrut_in_Reys_FK of the table Рейс

Name	Marshrut_in_Reys_FK
Code	Marshrut_in_Reys_FK
Unique	No
Cluster	No
Primary	No
Foreign Key	Yes
Alternate Key	No
Table	Рейс

5.8.1.12.19.2 Code preview of the index Marshrut_in_Reys_FK of the table Рейс

 The preview is empty because of the setting.

 Check the generation option.

5.8.1.12.19.3 List of index columns of the index Marshrut_in_Reys_FK

Name	Code	Sort
Номер точки маршрута	NomerMarshrut	Ascending

5.8.1.12.20 Index Dispetcher_in_Reys_FK of the table Рейс

5.8.1.12.20.1 Card of the index Dispetcher_in_Reys_FK of the table Рейс

Name	Dispetcher_in_Reys_FK
Code	Dispetcher_in_Reys_FK
Unique	No
Cluster	No
Primary	No
Foreign Key	Yes
Alternate Key	No
Table	Рейс

5.8.1.12.20.2 Code preview of the index Dispetcher_in_Reys_FK of the table Рейс

 The preview is empty because of the setting.

 Check the generation option.

5.8.1.12.20.3 List of index columns of the index Dispetcher_in_Reys_FK

Name	Code	Sort
Код диспетчера	KodDispetcher	Ascending

5.8.1.12.21 Index Kolonna_in_Reys_FK of the table Рейс

5.8.1.12.21.1 Card of the index Kolonna_in_Reys_FK of the table Рейс

Name	Kolonna_in_Reys_FK
Code	Kolonna_in_Reys_FK
Unique	No
Cluster	No
Primary	No
Foreign Key	Yes
Alternate Key	No
Table	Рейс

5.8.1.12.21.2 Code preview of the index Kolonna_in_Reys_FK of the table Рейс

 The preview is empty because of the setting.

 Check the generation option.

5.8.1.12.21.3 List of index columns of the index Kolonna_in_Reys_FK

Name	Code	Sort
Код колонны	KodKolon	Ascending

5.8.1.13 Table Товар

5.8.1.13.1 Card of table Товар

Name	Товар
Code	Tovar
DBMS	Microsoft SQL Server 2000

5.8.1.13.2 Check constraint name of table Товар

CKT_TOVAR

5.8.1.13.3 Server validation rule of table Товар

%RULES%

5.8.1.13.4 Code preview of table Товар

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

/* Table: Tovar                                                 */

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

create table Tovar (

   KodTovar             numeric              identity,

   NaimenTovar          char(60)             not null,

   EdIzmerenTovar       char(6)              not null,

   VesEdiniciTovar      float                not null default 0

      constraint CKC_VESEDINICITOVAR_TOVAR check (VesEdiniciTovar >= 0),

   constraint PK_TOVAR primary key  (KodTovar)

)

go

5.8.1.13.5 List of diagrams containing the table Товар

Name	Code
Diagram_1	Diagram_1

5.8.1.13.6 List of extended attributes of the table Товар