BD/Employees.sql

use [Sergeichev]

create table Employees
(
	Code_Employee int primary key identity(1,1) not null,
	Code_Post int foreign key references Posts(Code_Post),
	Name_Employee varchar(50) not null,
	Surname_Employee varchar(50) not null,
	Midname_Employee varchar(50) not null,
	Home_Address varchar(150) not null,
	Data_Passport varchar (11) check (Data_Passport like ('[1-9][0-9][0-9][0-9]-[0-9][0-9][0-9][0-9][0-9][0-9]')) not null,
	Telephone_Employee varchar(12) CHECK(Telephone_Employee like ('+7[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'))
)