--## 2019.02.23  Create table   数据集标识符字典表
create table SD_ZS.ZS_SJZZD0                          
(                                                           
  ID0000               number(10) not null,                 
  SJJLX0               varchar2(60) not null,               
  SJJMC0               varchar2(60) not null,               
  SJZJMC               varchar2(60) not null,               
  NBBSBM               varchar2(40),                        
  SJYBM0               varchar2(40),                        
  SJYMC0               varchar2(80) not null,               
  SJYSM0               varchar2(300),                       
  BZLY00               varchar2(40),                        
  BB0000               varchar2(10),                        
  SJLX00               varchar2(10),                        
  SJGS00               varchar2(30),                        
  YXZ000               varchar2(60),                        
  SFYX00               char(1) not null,                    
  BZ0000               varchar2(100),                       
  DYZDMC               varchar2(100) ,
  BLXZ00                  VARCHAR2(2)     
);                                                       
-- Add comments to the table 
create synonym ZS_SJZZD0 for SD_ZS.ZS_SJZZD0; 
create sequence SQ_ZS_SJZZD0_ID0000 increment by 1 start with 1 maxvalue 99999999 minvalue 1 cycle nocache;                              
comment on table  SD_ZS.ZS_SJZZD0                      
  is '数据集标识符字典表';                                  
-- Add comments to the columns                              
comment on column ZS_SJZZD0.ID0000                  
  is 'ID0000';                   
comment on column ZS_SJZZD0.SJJLX0        
  is '数据集类型';                                          
comment on column ZS_SJZZD0.SJJMC0        
  is '数据集名称';                                          
comment on column ZS_SJZZD0.SJZJMC    
  is '数据子集名称';                                        
comment on column ZS_SJZZD0.NBBSBM          
  is '内部标识编码';                                        
comment on column ZS_SJZZD0.SJYBM0   
  is '数据元编码';                                          
comment on column ZS_SJZZD0.SJYMC0   
  is '数据元名称';                                          
comment on column ZS_SJZZD0.SJYSM0
  is '数据元说明';                                          
comment on column ZS_SJZZD0.BZLY00    
  is '标准来源';                                            
comment on column ZS_SJZZD0.BB0000             
  is '版本';                                                
comment on column ZS_SJZZD0.SJLX00           
  is '数据类型';                                            
comment on column ZS_SJZZD0.SJGS00         
  is '数据格式';                                            
comment on column ZS_SJZZD0.YXZ000         
  is '允许值';                                              
comment on column ZS_SJZZD0.SFYX00               
  is '是否有效';                                            
comment on column ZS_SJZZD0.DYZDMC         
  is '对应字段名称';    
comment on column ZS_SJZZD0.BLXZ00      
  is '病例性质';