alter table premise_t add column account integer; alter table premise_t add constraint fk_premise_t_account foreign key (account) references account_t(id); alter table premise_t add constraint uk_premise_t_account unique(account); alter table account_entry_t add column document_no integer unique; create sequence unique_number_s start with 1 increment by 1;