create table users ( id integer not null, username text not null, role text references user_roles not null, created_at timestamptz not null, updated_at timestamptz not null ); comment on table users is ' User '; comment on column users.id is ' Unique user id '; comment on column users.username is ' Username '; comment on column users.role is ' User Role '; comment on column users.created_at is ' Creation date-time '; comment on column users.updated_at is ' Last update date-time ';