/*==============================================================*/
/* Table: department                                            */
/*==============================================================*/create or replace table department 
(
   dep_id               char(10)                       not null,
   pro_id               char(10)                       null,
   name                 char(10)                       null,
   manager              char(10)                       null,
   project              char(10)                       null,
   constraint PK_DEPARTMENT primary key clustered (dep_id)
);


/*==============================================================*/
/* Table: employee                                              */
/*==============================================================*/
create or replace table employee 
(
   emp_id               char(10)                       not null,
   name                 char(10)                       null,
   Identi_id            char(10)                       not null,
   role_id              char(10)                       null,
   pro_id               char(10)                       null,
   sala_id              char(10)                       null,
   dep_id               char(10)                       null,
   gender               char(10)                       null,
   age                  char(10)                       null,
   phone                char(10)                       null,
   department           char(10)                       null,
   position             char(10)                       null,
   project              char(10)                       null,
   constraint PK_EMPLOYEE primary key clustered (emp_id, Identi_id)
);

/*==============================================================*/
/* Index: emp_gets_sal_FK                                       */
/*==============================================================*/
create index emp_gets_sal_FK on employee (
sala_id ASC
);

/*==============================================================*/
/* Table: project                                               */
/*==============================================================*/
create or replace table project 
(
   pro_id               char(10)                       not null,
   name                 char(10)                       not null,
   manager              char(10)                       null,
   department           char(10)                       null,
   starttime            char(10)                       null,
   endtime              char(10)                       null,
   constraint PK_PROJECT primary key clustered (pro_id)
);

/*==============================================================*/
/* Table: role                                                  */
/*==============================================================*/
create or replace table role 
(
   role_id              char(10)                       not null,
   dep_id               char(10)                       null,
   name                 char(10)                       not null,
   department           char(10)                       null,
   constraint PK_ROLE primary key clustered (role_id)
);

/*==============================================================*/
/* Table: salary                                                */
/*==============================================================*/
create or replace table salary 
(
   sala_id              char(10)                       not null,
   emp_id               char(10)                       null,
   Identi_id            char(10)                       null,
   emp                  char(10)                       null,
   base                 char(10)                       null,
   bonus                char(10)                       null,
   deduction            char(10)                       null,
   constraint PK_SALARY primary key clustered (sala_id)
);

Please fix this sql code, find the right data type rather than default "char" according to the attribute name and table name  and set right contriains.. This is a employee manager database.