 
 CREATE TABLE customers (
     customer_id SERIAL PRIMARY KEY,
-    name TEXT NOT NULL
-);
-
-CREATE TABLE orders (
-    id SERIAL PRIMARY KEY,
-    name TEXT NOT NULL,
-    customer INT NOT NULL REFERENCES customers,
-    created_by INT NOT NULL REFERENCES users
+    name TEXT NOT NULL UNIQUE
 );
 
 CREATE TABLE services (
     id SERIAL PRIMARY KEY,
     name TEXT NOT NULL,
     customer INT NOT NULL REFERENCES customers,
-    created_by INT NOT NULL REFERENCES users
+    created_by INT NOT NULL REFERENCES users,
+    UNIQUE(customer, name)
 );
 
 CREATE TABLE servers (

);

CREATE TABLE people (
    id SERIAL PRIMARY KEY
);

CREATE TABLE user_states (


CREATE TABLE users (
    id SERIAL PRIMARY KEY REFERENCES people,
    state INT NOT NULL REFERENCES user_states,
    office INT REFERENCES offices,
    login TEXT UNIQUE
);

CREATE TABLE groups (
