--System configuration table change log
--drop table Config_log;
CREATE TABLE Config_log
(
ConfigName Varchar2(64) not null, --system parameter name
ConfigType Int not null, --Configuration parameter classification
ConfigClass Int not null, --Parameter level (0=modification not allowed, 1=customized modification allowed)
ConfigValue Varchar2(64) not null, --system parameter value
Remarks Varchar2(255), --Remarks
SerialID int, --modify sequence number
Modiattr varchar(1), --modify attributes
Moditime Date default sysdate, --modification time
Modiopid Varchar2(32) not null, --Modifier
SheetID Varchar2(20),
constraint pk_Config_log PRIMARY KEY(SerialID)
);
Notes are as follows:
--System configuration table change log
/****************************************************** ***********************************/
comment on table Config_log is 'System configuration table change log';
-------------------------------------------------- ----------------------------------
comment on column Config_log.ConfigName is 'system parameter name';
comment on column Config_log.ConfigType is 'Configuration parameter classification';
comment on column Config_log.ConfigClass is 'Parameter level (0=modification not allowed, 1=customized modification allowed)';
comment on column Config_log.ConfigValue is 'system parameter value';
comment on column Config_log.Remarks is 'Remarks';
comment on column Config_log.SerialID is 'modification sequence number';
comment on column Config_log.Modiattr is 'Modify attributes';
comment on column Config_log.Moditime is 'modification time';
comment on column Config_log.Modiopid is 'modifier';
/****************************************************** ***********************************/
Similar software
Release Notes
Software address
- Green versionCheck
- Green versionCheck
- Green versionCheck
- Green versionCheck
it works
it works
it works