-- Создание базы данных
USE master
CREATE DATABASE Prognoze CHS
GO

-- Создание таблиц
USE Prognoze CHS
CREATE TABLE LichniySostav (
								IDSotrudnika int PRIMARY KEY,
								Surname nvarchar(20),
								BirthDate date,
								Dolzhnost nvarchar(20),
								SemeynoePolozheniye nvarchar(20),
								JobData date, Obrazovaniye nvarchar(20),
								MestoZhitelstva nvarchar(20),
								LichniyTransport nvarchar(20)
							)
CREATE TABLE Obgects		(
								IDObject int PRIMARY KEY,
								NameObject nvarchar(20),
								PrednaznachenieObject nvarchar(20),
								TipKarkas nvarchar(20),
								NumberFloor int,
								DatePostroyki date,
								HPC int,
								CostPloshad int,
								NalichiyeOborudovaniya nvarchar(20)
							)
CREATE TABLE Likvidacia		(
								IDSotrudnika int references LichniySostav(IDSotrudnika),
								IDObject int references Obgects(IDObject),
								Obyazannost nvarchar(20),
								BHLikvidatsia date,
								BOLikvidatsia date
							)
CREATE TABLE Vzriv			(
								IDVzriv int PRIMARY KEY,
								MoshnostVzriv int,
								RadiusZonPorazh int,
								IzbitochnoyeDavleniye int,
								IDObject int
							)
CREATE TABLE GorushVesh		(
								NameGV nvarchar(20) PRIMARY KEY,
								ClassGv int,
								AgregatSostGV nvarchar(20),
								StehKonsentrGV int,
								MolekMassaGV int,
								UdelTeplSgorGV int
							)
CREATE TABLE Hraneniye		(
								IDObject int references Obgects(IDObject),
								NameGV nvarchar(20) references GorushVesh(NameGV),
								AgregatSostGV nvarchar(20),
								StehKonsentrGV int
								MolekMassaGV int
								UdelTeplSgorGV int
							)
GO