mysql创建视图

-- Create table
create table ODS_QMS.QMS_TRIAL_PROVIDE_BAD_INFORMATION
(
  id                 VARCHAR2(36),
  date_t             VARCHAR2(30),
  factory            VARCHAR2(16),
  provide_code       VARCHAR2(16),
  provide_name       VARCHAR2(16),
  marerial_midd_code VARCHAR2(20),
  marerial_midd_name VARCHAR2(20),
  material_code      VARCHAR2(50),
  bad_number         NUMBER(18,6),
  bad_reason         VARCHAR2(20),
  create_code        VARCHAR2(30),
  create_name        VARCHAR2(30),
  create_time        DATE,
  update_time        DATE,
  update_code        VARCHAR2(30),
  update_name        VARCHAR2(30),
  data_state         VARCHAR2(50)
)
tablespace JD_DW_BUS_DATA
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  )
nologging;
-- Add comments to the table 
comment on table ODS_QMS.QMS_TRIAL_PROVIDE_BAD_INFORMATION
  is '供方制程不良基础信息';
-- Add comments to the columns 
comment on column ODS_QMS.QMS_TRIAL_PROVIDE_BAD_INFORMATION.id
  is 'ID';
comment on column ODS_QMS.QMS_TRIAL_PROVIDE_BAD_INFORMATION.date_t
  is '日期';
comment on column ODS_QMS.QMS_TRIAL_PROVIDE_BAD_INFORMATION.factory
  is '工厂';
comment on column ODS_QMS.QMS_TRIAL_PROVIDE_BAD_INFORMATION.provide_code
  is '供方编码';
comment on column ODS_QMS.QMS_TRIAL_PROVIDE_BAD_INFORMATION.provide_name
  is '供方名称';
comment on column ODS_QMS.QMS_TRIAL_PROVIDE_BAD_INFORMATION.marerial_midd_code
  is '物料中类编码';
comment on column ODS_QMS.QMS_TRIAL_PROVIDE_BAD_INFORMATION.marerial_midd_name
  is '物料中类名称';
comment on column ODS_QMS.QMS_TRIAL_PROVIDE_BAD_INFORMATION.material_code
  is '物料编码';
comment on column ODS_QMS.QMS_TRIAL_PROVIDE_BAD_INFORMATION.bad_number
  is '不良数';
comment on column ODS_QMS.QMS_TRIAL_PROVIDE_BAD_INFORMATION.bad_reason
  is '不良原因';
comment on column ODS_QMS.QMS_TRIAL_PROVIDE_BAD_INFORMATION.create_code
  is '创建人';
comment on column ODS_QMS.QMS_TRIAL_PROVIDE_BAD_INFORMATION.create_name
  is '创建人';
comment on column ODS_QMS.QMS_TRIAL_PROVIDE_BAD_INFORMATION.create_time
  is '创建日期';
comment on column ODS_QMS.QMS_TRIAL_PROVIDE_BAD_INFORMATION.update_time
  is '更新日期';
comment on column ODS_QMS.QMS_TRIAL_PROVIDE_BAD_INFORMATION.update_code
  is '更新人';
comment on column ODS_QMS.QMS_TRIAL_PROVIDE_BAD_INFORMATION.update_name
  is '更新人';
comment on column ODS_QMS.QMS_TRIAL_PROVIDE_BAD_INFORMATION.data_state
  is '数据状态';