Контрольная работа: Інформаційна система будівельної організації

create table tblChaBuild ( ChaBuild_id int not null, Order_id int null, Floor int not null, MaterialType varchar(255) not null, NApartament int not null, constraint PK_TBLCHABUILD primary key nonclustered (ChaBuild_id)

)

go create table tblChaRoad ( ChaRoad_id int not null, Order_id int null, Structuretype varchar(255) not null, Width int not null, Bands int not null, constraint PK_TBLCHAROAD primary key nonclustered (ChaRoad_id)

)

go

create table tblGrafics ( Grafics_id int not null, Order_id int null, Brigade_id int null, JobType varchar(255) not null, TermPerformance datetime not null, Kyshty money not null, constraint PK_TBLGRAFICS primary key nonclustered (Grafics_id)

)

go

create table tblMachines ( Machines_id int not null, Bulldozers varchar(255) null, Cranes varchar(255) null, Excavator varchar(255) null, constraint PK_TBLMACHINES primary key nonclustered (Machines_id)

)

go

create table tblMaterials ( Materials_id int not null, Grafics_id int null, Materials varchar(255) not null, constraint PK_TBLMATERIALS primary key nonclustered (Materials_id)

)

go

create table tblNPlot ( NPlot_id int not null, Order_id int null, Head varchar(255) not null, constraint PK_TBLNPLOT primary key nonclustered (NPlot_id)

)

go

create table tblOrder ( Order_id int not null, NPlot_id int null, ChaRoad_id int null, ChaBuild_id int null, Object varchar(255) not null, Organisetion varchar(255) not null, BuildManagement varchar(255) not null, constraint PK_TBLORDER primary key nonclustered (Order_id)

)

go

create table tblReport ( Report_id int not null, Order_id int null, JobType varchar(255) not null, Completion datetime null, Used money null, constraint PK_TBLREPORT primary key nonclustered (Report_id)

)

go

create table tblTech ( Tech_id int not null, Engeneers varchar(255) null, Technology varchar(255) null, Technics varchar(255) null, constraint PK_TBLTECH primary key nonclustered (Tech_id)

)

go

create table tblWorkers ( Workers_id int not null, Brigade_id int null, Bricklayer varchar(255) null, Concrete varchar(255) null, Handler varchar(255) null, Welders varchar(255) null, Electricity varchar(255) null, Driver varchar(255) null, Locksmiths varchar(255) null, constraint PK_TBLWORKERS primary key nonclustered (Workers_id)

)

go