Roles.sql 405 B

12345678910111213
  1. use [Sergeichev]
  2. create table Roles
  3. (
  4. Code_Role int primary key identity(1,1) not null,
  5. User_Role nvarchar(20) check (User_Role IN ('Ìåíåäæåð ïî ïðîäàæàì', 'Ìåíåäæåð ïî ïåðñîíàëó', 'Êîíñóëüòàíò', 'Áóõãàëòåð')) not null,
  6. Name_User nvarchar(20) not null,
  7. Surname_User nvarchar(20) not null,
  8. Midname_User nvarchar(20) not null,
  9. Login_User nvarchar(20) not null,
  10. Password_User nvarchar(20) not null
  11. )