0mhAn0jb

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    First_Name varchar(50) null,
28    Second_Name varchar(50) null,
29    Last_Name varchar(50) null,
30    EGN varchar(50) null,
31    Duty_id int not null,
32    Town_Id int not null,
33    TelephoneNumber varchar(50),
34    ScannerCardNumber varchar(50),
35	FOREIGN KEY (Duty_id) REFERENCES Duties(Id),
36    FOREIGN KEY (Town_Id) 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    Employee_id  int not null,
50    CameWork varchar(50) null,
51    LeaveWork varchar(50) null,
52    FOREIGN KEY (Employee_id) REFERENCES Employees(Id),
53    CONSTRAINT PRIMARY KEY (Id)
54    );
55    
56CREATE TABLE Employeegraphmounght (
57	Id int auto_increment ,
58    CurrentDate varchar(50) null,
59    Employee_id  int not null,
60    CameWork varchar(50) null,
61    LeaveWork varchar(50) null,
62    HoursWorked varchar(50) null,
63    FOREIGN KEY (Employee_id) REFERENCES Employees(Id),
64    CONSTRAINT PRIMARY KEY (Id)
65    );