HEGII.ss.mes.web/wwwroot/mes/dr/sqlupdate/02T_MST_DR_PARAMETER.sql

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