CREATE TABLE employees (
employee_id SERIAL PRIMARY KEY,
first_name VARCHAR(50) NOT NULL,
middle_name VARCHAR(50),
last_name VARCHAR(50) NOT NULL CHECK (last_name <> ''),
hire_date DATE CHECK (hire_date > '2000-01-01'),
email VARCHAR(100) UNIQUE,
salary DECIMAL(10, 2) DEFAULT 50000.00
-- department_id INT REFERENCES departments(department_id)
);
INSERT INTO employees (first_name, middle_name, last_name, hire_date, email, salary)
VALUES
('Иван', NULL, 'Иванов', '2023-09-01', 'ivanov@example.com', 65000.00),
('Петр', 'Петрович', 'Петров', '2023-08-15', 'petrov@example.com', 75000.00),
('Анна', 'Сидоровна', 'Иванова', '2023-07-22', 'sidorova@example.com', 85000.00);
SELECT * FROM employees;
Telegram: DB developers channel