DeNh2jTM

1drop schema if exists employeemanagement;
2create database employeemanagement;
3use employeemanagement;
4
5create table Admins(
6	Id int auto_increment ,
7    Username varchar(50) null,
8    Password varchar(50) null,
9    ScannerCardNumber  varchar(50) null,
10    CONSTRAINT PRIMARY KEY (Id)
11    );
12
13create table Towns (
14	Id int auto_increment ,
15    Name varchar(50) null,
16    CONSTRAINT PRIMARY KEY (Id)
17    );
18
19create table Duties (
20	Id int auto_increment ,
21    Duty varchar(50) null,
22    CONSTRAINT PRIMARY KEY (Id)
23    );
24    
25create table Employees (
26	Id int auto_increment ,
27    FirstName varchar(50) null,
28    SecondName varchar(50) null,
29    LastName varchar(50) null,
30    Egn varchar(50) null,
31    DutyId int not null,
32    TownId int not null,
33    TelephoneNumber varchar(50),
34    ScannerCardNumber varchar(50),
35	FOREIGN KEY (DutyId) REFERENCES Duties(Id),
36    FOREIGN KEY (TownId) REFERENCES Towns(Id),
37    CONSTRAINT PRIMARY KEY (Id)
38    );
39
40create table Lastscaned (
41	Id int auto_increment ,
42    ScannerCardNumber varchar(50) null,
43    CONSTRAINT PRIMARY KEY (Id)
44    );
45
46create table Employeegraph (
47	Id int auto_increment ,
48    CurrentDate varchar(50),
49    EmployeeId  int not null,
50    CameWork varchar(50) null,
51    LeaveWork varchar(50) null,
52    FOREIGN KEY (EmployeeId) REFERENCES Employees(Id),
53    CONSTRAINT PRIMARY KEY (Id)
54    );
55    
56CREATE TABLE Employeegraphmounght (
57	Id int auto_increment ,
58    CurrentDate varchar(50) null,
59    EmployeeId  int not null,
60    CameWork varchar(50) null,
61    LeaveWork varchar(50) null,
62    HoursWorked varchar(50) null,
63    FOREIGN KEY (EmployeeId) REFERENCES Employees(Id),
64    CONSTRAINT PRIMARY KEY (Id)
65    );