cejYNLpj

1CREATE TABLE IF NOT EXISTS position(
2  id_position INTEGER PRIMARY KEY AUTOINCREMENT,
3  name TEXT NOT NULL,
4  min REAL NOT NULL CHECK (min > 0),
5  max REAL CHECK (max > 0),
6);
7	
8CREATE TABLE IF NOT EXISTS employee (
9  id_employee INTEGER PRIMARY KEY AUTOINCREMENT,
10  id_position INTEGER NOT NULL,
11  name TEXT NOT NULL,
12  last_name TEXT NOT NULL,
13  data_of_birth TEXT NOT NULL CHECK (DATE(data_of_birth) IS NOT NULL AND data_of_birth < DATE('now','localtime')),
14  salary REAL NOT NULL CHECK (salary >= position.min AND salary <= position.max),
15  FOREIGN KEY(id_stanowisko) REFERENCES stanowisko(id_stanowisko)
16);