 comment on column users_tracking.action is 'Action done on table record: insert, update, delete';
 comment on column users_tracking.modification_date_time is 'Track date and time';
 
--- @TODO: to be modified or not :)
--- @TODO: Discussion about that needed... :)
 
 create table users_tracking_records
        (

comment on column users_workflow.status is 'Record status: to correct, to be corrected or published';
comment on column users_workflow.modification_date_time is 'Date and time of status change - last date/time is used as actual status, but helps also to keep an history of status change';
comment on column users_workflow.comment is 'Complementary comments';
create table users_tables_fields_tracked
       (
        referenced_relation varchar not null,
        field_name varchar not null,
        user_ref integer not null,
        constraint unq_users_tables_fields_tracked unique (referenced_relation, field_name, user_ref),
        constraint fk_users_tables_fields_tracked_users foreign key (user_ref) references users(id) on delete cascade
       );

        language_full_text full_text_language,
        modification_date_time update_date_time,
        modification_date_mask int not null default '0',
        constraint pk_collection_maintenance primary key (id),
        constraint fk_collection_maintenance_users foreign key (people_ref) references people(id)
       )
inherits (template_table_record_ref);
