CREATE DATABASE employee_db;
USE employee_db;

CREATE TABLE employees(
id INT AUTO_INCREMENT PRIMARY KEY,
employee_id VARCHAR(50),
employee_name VARCHAR(100),
category VARCHAR(50),
designation VARCHAR(50),
department VARCHAR(50),
sex VARCHAR(10),
dob DATE,
marital_status VARCHAR(20),
religion VARCHAR(30),
blood_group VARCHAR(5),
father_name VARCHAR(100),
mother_name VARCHAR(100),
nid VARCHAR(50),
joining_date DATE,
cl INT,
sl INT,
email VARCHAR(100),
mobile VARCHAR(20),
basic_salary DECIMAL(10,2),
pre_village VARCHAR(100),
pre_post VARCHAR(100),
pre_thana VARCHAR(100),
pre_district VARCHAR(100),
per_village VARCHAR(100),
per_post VARCHAR(100),
per_thana VARCHAR(100),
per_district VARCHAR(100),
education TEXT,
experience TEXT,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
