首先,给表PMS_ENTERPRISEORGANIZATION
要新建一个字段PARENTID
ALTER TABLE PMS_ENTERPRISEORGANIZATION ADD PARENTID varchar(50) DEFAULT NULL;
其次是将PARENTID
设置为外键,关联的是表PMS_ENTERPRISE
的id
ALTER TABLE PMS_ENTERPRISEORGANIZATION ADD FOREIGN KEY (PARENTID) REFERENCES
PMS_ENTERPRISE(id) ON DELETE CASCADE ON UPDATE CASCADE