if not exists (select * from sys.tables where object_id = object_id(N'dbo.Department'))
    create table dbo.Department
    (
        ID uniqueidentifier not null constraint PK_Department primary key 
        ,Name nvarchar(256) not null
        ,Description nvarchar(256) null
        ,CreationDate datetime not null constraint DF_Department_CreationDate DEFAULT getdate()
        ,ModifiedDate datetime not null constraint DF_Department_ModifiedDate DEFAULT getdate()
        ,ModifiedUserName nvarchar(256) null
        ,ModifiedLoggedUserName nvarchar(256) null
    )