HEGII.ss.mes.web/wwwroot/mes/dr/sqlupdate/03T_MST_DR_SYSPARAMETER.sql

-- Create table
create table T_MST_DR_SYSPARAMETER
(
  parameterid   NUMBER not null,
  parametercode NVARCHAR2(32) not null,
  parametername NVARCHAR2(32) not null,
  parametertype NVARCHAR2(32),
  displayno     NUMBER default 0,
  format        NVARCHAR2(64),
  remarks       NVARCHAR2(64),
  accountid     NUMBER not null,
  valueflag     CHAR(1) default 1 not null,
  createtime    DATE default sysdate not null,
  createuserid  NUMBER not null,
  updatetime    DATE default sysdate not null,
  updateuserid  NUMBER not null
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
-- Add comments to the columns 
comment on column T_MST_DR_SYSPARAMETER.parameterid
  is '参数ID';
comment on column T_MST_DR_SYSPARAMETER.parametercode
  is '参数编码';
comment on column T_MST_DR_SYSPARAMETER.parametername
  is '参数名称';
comment on column T_MST_DR_SYSPARAMETER.parametertype
  is '参种类型';
comment on column T_MST_DR_SYSPARAMETER.displayno
  is '显示顺序';
comment on column T_MST_DR_SYSPARAMETER.format
  is '格式化';
comment on column T_MST_DR_SYSPARAMETER.remarks
  is '备注';
comment on column T_MST_DR_SYSPARAMETER.accountid
  is '帐套ID (所属帐套ID)';
comment on column T_MST_DR_SYSPARAMETER.valueflag
  is '有效标识 (1：正常  0：停用)';
comment on column T_MST_DR_SYSPARAMETER.createtime
  is '创建时间 (更新时，不更新该数据)';
comment on column T_MST_DR_SYSPARAMETER.createuserid
  is '创建数据操作员ID (更新时，不更新该数据)';
comment on column T_MST_DR_SYSPARAMETER.updatetime
  is '更新时间 (新建时，取新建时间；更新时，取最新时间更新)';
comment on column T_MST_DR_SYSPARAMETER.updateuserid
  is '更新数据操作员ID (新建时，取创建者ID；更新时，取更新者ID)';
-- Create/Recreate primary, unique and foreign key constraints 
alter table T_MST_DR_SYSPARAMETER
  add primary key (PARAMETERID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );