CREATE TABLE employees (
employee_id SERIAL PRIMARY KEY,
first_name VARCHAR(50) NOT NULL,
middle_name VARCHAR(50) DEFAULT NULL,
last_name VARCHAR(50) NOT NULL CHECK (TRIM(last_name) <> ''),
hire_date DATE CHECK('2024-01-01' < hire_date AND hire_date < CURRENT_DATE),
email VARCHAR(100) UNIQUE,
salary DECIMAL(10, 2) DEFAULT 50000.00
);
INSERT INTO employees (first_name, middle_name, last_name, hire_date, email, salary)
VALUES
('Иван', NULL, 'Иванов', '2024-09-01', 'ivanov@example.com', 65000.00),
('Анна', 'Сидоровна', 'Иванова', '2024-07-22', 'sidorova@example.com', 85000.00);
INSERT INTO employees (first_name, last_name, hire_date, email, salary)
VALUES
('Jonn', 'Connor', '2024-04-11', 'connor@example.com', 85000.00);
SELECT * FROM employees;
Telegram: DB developers channel