-- Create table
create table MTB_LOG_FIELD
(
  gid         VARCHAR2(32) not null,
  create_date DATE default SYSDATE not null,
  create_id   VARCHAR2(32) not null,
  modify_date DATE,
  modify_id   VARCHAR2(32),
  is_active   NUMBER(1) default 0 not null,
  is_delete   NUMBER(1) default 0 not null,
  deleted     VARCHAR2(32),
  data_role   VARCHAR2(32) default '-1' not null,
  data_role1  VARCHAR2(32) default '-1',
  data_role2  VARCHAR2(32) default '0',
  uda1c       VARCHAR2(100),
  uda1n       VARCHAR2(100),
  uda2c       VARCHAR2(100),
  uda2n       VARCHAR2(100),
  uda3c       VARCHAR2(100),
  uda3n       VARCHAR2(100),
  uda4c       VARCHAR2(100),
  uda4n       VARCHAR2(100),
  uda5c       VARCHAR2(100),
  uda5n       VARCHAR2(100),
  uda1        VARCHAR2(50),
  uda2        VARCHAR2(50),
  uda3        VARCHAR2(50),
  uda4        VARCHAR2(50),
  uda5        VARCHAR2(50),
  tablea      VARCHAR2(50),
  tableb      VARCHAR2(50),
  fielda      VARCHAR2(50),
  fieldb      VARCHAR2(50)
)
tablespace MESTAR_DATA
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 8K
    minextents 1
    maxextents unlimited
  );
-- Add comments to the table 
comment on table MTB_LOG_FIELD
  is '翻译字段';
-- Add comments to the columns 
comment on column MTB_LOG_FIELD.gid
  is '主键';
comment on column MTB_LOG_FIELD.create_date
  is '创建日期';
comment on column MTB_LOG_FIELD.create_id
  is '创建人';
comment on column MTB_LOG_FIELD.modify_date
  is '修改日期';
comment on column MTB_LOG_FIELD.modify_id
  is '修改人';
comment on column MTB_LOG_FIELD.is_active
  is '激活标识';
comment on column MTB_LOG_FIELD.is_delete
  is '删除标识';
comment on column MTB_LOG_FIELD.data_role
  is '工厂GID';
comment on column MTB_LOG_FIELD.data_role1
  is '工作中心 GID';
comment on column MTB_LOG_FIELD.data_role2
  is '工作中心层级权值';
comment on column MTB_LOG_FIELD.uda1c
  is '备用字段1编码';
comment on column MTB_LOG_FIELD.uda1n
  is '备用字段1名称';
comment on column MTB_LOG_FIELD.uda2c
  is '备用字段2编码';
comment on column MTB_LOG_FIELD.uda2n
  is '备用字段2名称';
comment on column MTB_LOG_FIELD.uda3c
  is '备用字段3编码';
comment on column MTB_LOG_FIELD.uda3n
  is '备用字段3名称';
comment on column MTB_LOG_FIELD.uda4c
  is '备用字段4编码';
comment on column MTB_LOG_FIELD.uda4n
  is '备用字段4名称';
comment on column MTB_LOG_FIELD.uda5c
  is '备用字段5编码';
comment on column MTB_LOG_FIELD.uda5n
  is '备用字段5名称';
comment on column MTB_LOG_FIELD.uda1
  is '预留字段1';
comment on column MTB_LOG_FIELD.uda2
  is '预留字段2';
comment on column MTB_LOG_FIELD.uda3
  is '预留字段3';
comment on column MTB_LOG_FIELD.uda4
  is '预留字段4';
comment on column MTB_LOG_FIELD.uda5
  is '预留字段5';
