写一个有5个实体集的办公室日常信息管理系统,有建表代码
时间: 2024-02-25 12:57:58 浏览: 14
好的,以下是一个包含5个实体集的办公室日常信息管理系统的建表代码:
1. 员工信息表
```
CREATE TABLE employee (
id INT PRIMARY KEY,
name VARCHAR(50) NOT NULL,
department VARCHAR(50) NOT NULL,
position VARCHAR(50) NOT NULL,
salary DECIMAL(10, 2) NOT NULL,
hire_date DATE NOT NULL
);
```
2. 考勤记录表
```
CREATE TABLE attendance (
id INT PRIMARY KEY,
employee_id INT NOT NULL,
attendance_date DATE NOT NULL,
start_time TIME NOT NULL,
end_time TIME NOT NULL,
status VARCHAR(20) NOT NULL,
FOREIGN KEY (employee_id) REFERENCES employee(id)
);
```
3. 请假记录表
```
CREATE TABLE leave (
id INT PRIMARY KEY,
employee_id INT NOT NULL,
leave_date DATE NOT NULL,
leave_type VARCHAR(50) NOT NULL,
leave_reason TEXT,
status VARCHAR(20) NOT NULL,
FOREIGN KEY (employee_id) REFERENCES employee(id)
);
```
4. 培训记录表
```
CREATE TABLE training (
id INT PRIMARY KEY,
employee_id INT NOT NULL,
training_date DATE NOT NULL,
training_type VARCHAR(50) NOT NULL,
training_content TEXT,
status VARCHAR(20) NOT NULL,
FOREIGN KEY (employee_id) REFERENCES employee(id)
);
```
5. 离职记录表
```
CREATE TABLE resignation (
id INT PRIMARY KEY,
employee_id INT NOT NULL,
resignation_date DATE NOT NULL,
resignation_reason TEXT,
status VARCHAR(20) NOT NULL,
FOREIGN KEY (employee_id) REFERENCES employee(id)
);
```
以上是一个包含5个实体集的办公室日常信息管理系统的建表代码示例,您可以根据实际需求进行调整和修改。