T_COM_UPLOAD_FILE

-- Create table
create table T_COM_UPLOAD_FILE
(
  FILE_ID            VARCHAR2(40) not null,
  FILE_SIZE          VARCHAR2(10),
  FILE_TYPE          VARCHAR2(100) not null,
  FILE_NAME          VARCHAR2(1000) not null,
  FILE_PATH          VARCHAR2(1000) not null,
  UPLOAD_TIME        VARCHAR2(20),
  RES_ID             VARCHAR2(40) not null,
  IS_DOWNLOAD        NUMBER(1) default 0 not null,
  CREATETIME         VARCHAR2(20),
  UPDATETIME         VARCHAR2(20),
  LAST_UPDATE_PERSON VARCHAR2(40),
  LAST_UPDATE_TIME   VARCHAR2(20)
);

-- Add comments to the table
comment on table T_COM_UPLOAD_FILE
  is '附件上传信息表';
-- Add comments to the columns
comment on column T_COM_UPLOAD_FILE.FILE_ID
  is '附件ID';
comment on column T_COM_UPLOAD_FILE.FILE_SIZE
  is '文件大小';
comment on column T_COM_UPLOAD_FILE.FILE_TYPE
  is '文件类型';
comment on column T_COM_UPLOAD_FILE.FILE_NAME
  is '文件名称';
comment on column T_COM_UPLOAD_FILE.FILE_PATH
  is '文件保存路径';
comment on column T_COM_UPLOAD_FILE.UPLOAD_TIME
  is '上传时间';
comment on column T_COM_UPLOAD_FILE.RES_ID
  is '主数据表附件ID';
comment on column T_COM_UPLOAD_FILE.IS_DOWNLOAD
  is '是否必须登录后下载:0-否 1-是';
comment on column T_COM_UPLOAD_FILE.CREATETIME
  is '同步用创建时间';
comment on column T_COM_UPLOAD_FILE.UPDATETIME
  is '同步用更新时间';
comment on column T_COM_UPLOAD_FILE.LAST_UPDATE_PERSON
  is '最近修改人';
comment on column T_COM_UPLOAD_FILE.LAST_UPDATE_TIME
  is '最近修改时间';

-- Create/Recreate primary, unique and foreign key constraints
alter table T_COM_UPLOAD_FILE
  add constraint PK1_1_1 primary key (FILE_ID)