Материал: Автоматизация учета рабочего времени сотрудников компании ОАО "РЖД"

Скачать

Заказать новую работу

Внимание! Если размещение файла нарушает Ваши авторские права, то обязательно сообщите нам
78
'user', @CurrentUser, 'table', 'Employer', 'column', 'id_Emp'
go
/*==============================================================*/
/* Index: Relationship_1_FK */
/*==============================================================*/
create nonclustered index Relationship_1_FK on Employer (id_Post ASC)
go
/*==============================================================*/
/* Table: "Order" */
/*==============================================================*/
create table "Order" (
id_Order int not null,
id_Emp int null,
or_Year int not null,
or_Month smallint not null,
or_Money money null,
or_Duration decimal(1,1) null,
constraint PK_ORDER primary key (id_Order)
)
go
if exists(select 1 from sys.extended_properties p where
p.major_id = object_id('"Order"')
and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and
c.name = 'id_Emp')
)
begin
declare @CurrentUser sysname
select @CurrentUser = user_name()
79
execute sp_dropextendedproperty 'MS_Description',
'user', @CurrentUser, 'table', 'Order', 'column', 'id_Emp'
end
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'Идентификатор сотрудника',
'user', @CurrentUser, 'table', 'Order', 'column', 'id_Emp'
go
/*==============================================================*/
/* Index: "Employer-Order_FK" */
/*==============================================================*/
create nonclustered index "Employer-Order_FK" on "Order" (id_Emp ASC)
go
/*==============================================================*/
/* Table: Penalty */
/*==============================================================*/
create table Penalty (
id_Penalty int not null,
id_Emp int null,
pen_Year int not null,
pen_Month smallint not null,
pen_Money money not null,
constraint PK_PENALTY primary key (id_Penalty)
)
go
80
if exists(select 1 from sys.extended_properties p where
p.major_id = object_id('Penalty')
and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and
c.name = 'id_Emp')
)
begin
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
'user', @CurrentUser, 'table', 'Penalty', 'column', 'id_Emp'
end
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'Идентификатор сотрудника',
'user', @CurrentUser, 'table', 'Penalty', 'column', 'id_Emp'
go
/*==============================================================*/
/* Index: "Employer-Penalty_FK" */
/*==============================================================*/
create nonclustered index "Employer-Penalty_FK" on Penalty (id_Emp ASC)
go
/*==============================================================*/
/* Table: Post */
/*==============================================================*/
create table Post (
id_Post int not null,
81
p_Name varchar(100) not null,
p_Salary money not null,
constraint PK_POST primary key (id_Post)
)
go
/*==============================================================*/
/* Table: TimeSheet */
/*==============================================================*/
create table TimeSheet (
id_TimeSheet int not null,
id_Emp int null,
ts_Data datetime not null,
ts_StartTime datetime not null,
ts_StopTime datetime not null,
ts_Duration decimal(1,1) null,
constraint PK_TIMESHEET primary key (id_TimeSheet)
)
go
if exists(select 1 from sys.extended_properties p where
p.major_id = object_id('TimeSheet')
and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and
c.name = 'id_Emp')
)
begin
declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_dropextendedproperty 'MS_Description',
'user', @CurrentUser, 'table', 'TimeSheet', 'column', 'id_Emp'
end
select @CurrentUser = user_name()
82
execute sp_addextendedproperty 'MS_Description',
'Идентификатор сотрудника',
'user', @CurrentUser, 'table', 'TimeSheet', 'column', 'id_Emp'
go
/*==============================================================*/
/* Index: "Employer-TimeSheet_FK" */
/*==============================================================*/
create nonclustered index "Employer-TimeSheet_FK" on TimeSheet (id_Emp ASC)
go
alter table Employer
add constraint "FK_EMPLOYER_EMPLOYER-_POST" foreign key (id_Post)
references Post (id_Post)
go
alter table "Order"
add constraint "FK_ORDER_EMPLOYER-_EMPLOYER" foreign key (id_Emp)
references Employer (id_Emp)
go
alter table Penalty
add constraint "FK_PENALTY_EMPLOYER-_EMPLOYER" foreign key (id_Emp)
references Employer (id_Emp)
go
alter table TimeSheet
add constraint "FK_TIMESHEE_EMPLOYER-_EMPLOYER" foreign key (id_Emp)
references Employer (id_Emp)
go
Источник: https://baza.diplomsite.ru/previewfile/2429

Смотрите также:

17. Введение 18. Линейные программы 19. Ветвления 20. Программирование циклических алгоритмов
Анализ эффективности инвестиций предприятия на примере ООО «СпецПримСтрой»
Сборные железобетонные ребристые плиты перекрытия
_-___-~1
_3 тема - Диффузия
_Роджерс Карл, Брак и его альтернативы
_Штерн Вильям, Дифференциальная психология и ее методические основы
- Описание типа СЭТ7009