start logging T; -- создать табличку H$T и логирующие триггеры для T 

-- создаст табличку Servers (Id PK, Name, Country, Valid)
create entity Servers (Name: string, Country: string, Valid: Boolean not null default True); 

-- создаст табличку Users (Id PK, Name, Server FK to Servers.Id)
create entity Users (Name: string, Server: foreign key to Servers); 

create entity Documents (Owner: foreign key to Users, Created: timestamp not null default current_timestamp, Valid: Boolean not null default True);

-- создаст табличку Orders + 1 уникальный FK на Documents + триггер на удаление, 
-- чтобы удалить и соответствующую запись из Documents
create entity Orders (Client: string, OrderDate: date not null, Sum: Money) inherited from Documents; 

create entity Places (Name: string);
create entity Movements (FromPlace, ToPlace: foreign key to Places) inherited from Documents;

select Client, Owner.Name, Owner.Server.Name from Orders order by Owner.Server.Country; 

update Orders O set O.Valid = False where (O.Created > current_timestamp) or (O.Owner.Server.Country = '');