添加字段

ALTER TABLE CUSTOMERFORMENTRIES ADD(OPERATIONROLEId NUMBER(19) not null);
ALTER TABLE LCUSTOMERFORMENTRIE ADD(OPERATIONROLEId NUMBER(19) not null);

 

一般还需要添加外键,修复之前数据

 

ALTER TABLE CUSTOMERFORMENTRIES ADD  CONSTRAINT FOREIGN  OPERATIONROLEId REFERENCES OPERATIONROLES(ID);
ALTER  TABLE LCUSTOMERFORMENTRIE ADD  CONSTRAINT FOREIGN OPERATIONROLEId REFERENCES  OPERATIONROLES(ID);

 

--------------------------------------------------------------------------------

 

设置为非空：此方法并不好，这种方式太重量级了。

ALTER TABLE customerformentries ADD CONSTRAINT df_cde CHECK(operationroleid IS NOT NULL);

 

这个比较好点:

alter table CUSTOMERFORMENTRIES modify OPERATIONROLEID not null;

 

这些语句用PL SQL Developer软件可以生成的

--------------------------------------------------------------------------------

 

log表lcustomerformentrie一般都不会建外键约束
l开头的是日志表用来记录domain对象改变时.不需要update修复数据,也不要设置成not null