enterprise-service/quality-service/quality-server/sql/quality.sql

DROP TABLE "QUALITY"."BIZ_ORGANIZATION";
DROP TABLE "QUALITY"."BIZ_EQUIPMENT";
DROP TABLE "QUALITY"."BIZ_PERSONNEL_MANAGEMENT";
DROP TABLE "QUALITY"."BIZ_TEST_PARAMETERS";
DROP TABLE "QUALITY"."BIZ_QUALITY_PREDICTION_PLANNED";
DROP TABLE "QUALITY"."BIZ_QUALITY_PREDICTION_AUDIT";
DROP TABLE "QUALITY"."BIZ_QUALITY_PREDICTION_ITEMS";
DROP TABLE "QUALITY"."BIZ_FOOD_STOCK";
DROP TABLE "QUALITY"."BIZ_FOOD_STOCK_ITEMS";
DROP TABLE "QUALITY"."BIZ_GRADE_TEST_RESULTS";
DROP TABLE "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS";
DROP TABLE "QUALITY"."BIZ_SUMMARY_RESULTS";
DROP TABLE "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS";
DROP TABLE "QUALITY"."BIZ_SUMMARY_SUBSTANDARD_SAMPLE";
DROP TABLE "QUALITY"."BIZ_SUMMARY_NOT_SUITABLE";
DROP TABLE "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT";

DROP TABLE "QUALITY"."CCFA";
DROP TABLE "QUALITY"."CYD";
DROP TABLE "QUALITY"."CYJH";
DROP TABLE "QUALITY"."CYPZ";
DROP TABLE "QUALITY"."QYD";
DROP TABLE "QUALITY"."WT";


CREATE TABLE "QUALITY"."BIZ_ORGANIZATION" (
"ID" VARCHAR2(50 BYTE) NOT NULL ,
"CREATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"CREATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"DELETE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"DELETE_TIME" TIMESTAMP(6)  NULL ,
"UPDATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"UPDATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"ORG_ID" VARCHAR2(50 BYTE) NULL ,
"DEPT_ID" VARCHAR2(50 BYTE) NULL ,
"AREA_CODE" VARCHAR2(50 BYTE) NULL ,
"ORGANIZATION_NAME" VARCHAR2(200 BYTE) NULL ,
"INSTITUTIONAL_CATEGORIES" VARCHAR2(50 BYTE) NULL ,
"AFFILIATING_AREA" VARCHAR2(50 BYTE) NULL ,
"DETAILED_ADDRESS" VARCHAR2(200 BYTE) NULL ,
"REGISTRATION_TIME" VARCHAR2(50 BYTE) NULL ,
"ORGANIZATION_CODE" VARCHAR2(50 BYTE) NULL ,
"LEGAL_REPRESENTATIVE" VARCHAR2(200 BYTE) NULL ,
"PHONE" VARCHAR2(50 BYTE) NULL ,
"EMPLOYEES_NUMBER" VARCHAR2(50 BYTE) NULL ,
"EQUIPMENT_NUMBER" VARCHAR2(50 BYTE) NULL ,
"LABORATORY_AREA" VARCHAR2(50 BYTE) NULL ,
"METROLOGICAL_AUTHENTICATION" VARCHAR2(50 BYTE) NULL ,
"MONITORING_BODIES" VARCHAR2(50 BYTE) NULL 
);
COMMENT ON TABLE "QUALITY"."BIZ_ORGANIZATION" IS '机构基本信息';
COMMENT ON COLUMN "QUALITY"."BIZ_ORGANIZATION"."ID" IS 'id';
COMMENT ON COLUMN "QUALITY"."BIZ_ORGANIZATION"."ORGANIZATION_NAME" IS '质检机构名称';
COMMENT ON COLUMN "QUALITY"."BIZ_ORGANIZATION"."INSTITUTIONAL_CATEGORIES" IS '机构类别';
COMMENT ON COLUMN "QUALITY"."BIZ_ORGANIZATION"."AFFILIATING_AREA" IS '所属地区';
COMMENT ON COLUMN "QUALITY"."BIZ_ORGANIZATION"."DETAILED_ADDRESS" IS '详细地址';
COMMENT ON COLUMN "QUALITY"."BIZ_ORGANIZATION"."REGISTRATION_TIME" IS '注册时间';
COMMENT ON COLUMN "QUALITY"."BIZ_ORGANIZATION"."ORGANIZATION_CODE" IS '组织机构代码';
COMMENT ON COLUMN "QUALITY"."BIZ_ORGANIZATION"."LEGAL_REPRESENTATIVE" IS '法定代表人';
COMMENT ON COLUMN "QUALITY"."BIZ_ORGANIZATION"."PHONE" IS '联系电话';
COMMENT ON COLUMN "QUALITY"."BIZ_ORGANIZATION"."EMPLOYEES_NUMBER" IS '员工人数';
COMMENT ON COLUMN "QUALITY"."BIZ_ORGANIZATION"."EQUIPMENT_NUMBER" IS '设备数量';
COMMENT ON COLUMN "QUALITY"."BIZ_ORGANIZATION"."LABORATORY_AREA" IS '办公及实验室面积（㎡）';
COMMENT ON COLUMN "QUALITY"."BIZ_ORGANIZATION"."METROLOGICAL_AUTHENTICATION" IS '是否通过计量认证';
COMMENT ON COLUMN "QUALITY"."BIZ_ORGANIZATION"."MONITORING_BODIES" IS '是否为国家粮食质量监测机构';


CREATE TABLE "QUALITY"."BIZ_EQUIPMENT" (
"ID" VARCHAR2(50 BYTE) NOT NULL ,
"CREATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"CREATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"DELETE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"DELETE_TIME" TIMESTAMP(6)  NULL ,
"UPDATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"UPDATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"ORG_ID" VARCHAR2(50 BYTE) NULL ,
"DEPT_ID" VARCHAR2(50 BYTE) NULL ,
"AREA_CODE" VARCHAR2(50 BYTE) NULL ,
"ORGANIZATION_ID" VARCHAR2(50 BYTE) NULL ,
"EQUIPMENT_NAME" VARCHAR2(200 BYTE) NULL ,
"DEVICE_CODING" VARCHAR2(200 BYTE) NULL ,
"USING_STATE" VARCHAR2(50 BYTE) NULL ,
"MANUFACTURER" VARCHAR2(200 BYTE) NULL ,
"PRODUCTION_DATE" VARCHAR2(50 BYTE) NULL ,
"CONTACT_PERSON" VARCHAR2(50 BYTE) NULL ,
"PHONE" VARCHAR2(50 BYTE) NULL ,
"NUMBER_EQUIPMENT" VARCHAR2(50 BYTE) NULL 
);
COMMENT ON TABLE "QUALITY"."BIZ_EQUIPMENT" IS '仪器设备信息';
COMMENT ON COLUMN "QUALITY"."BIZ_EQUIPMENT"."ID" IS 'id';
COMMENT ON COLUMN "QUALITY"."BIZ_EQUIPMENT"."ORGANIZATION_ID" IS '机构id';
COMMENT ON COLUMN "QUALITY"."BIZ_EQUIPMENT"."EQUIPMENT_NAME" IS '设备名称';
COMMENT ON COLUMN "QUALITY"."BIZ_EQUIPMENT"."DEVICE_CODING" IS '设备编码';
COMMENT ON COLUMN "QUALITY"."BIZ_EQUIPMENT"."USING_STATE" IS '使用状态';
COMMENT ON COLUMN "QUALITY"."BIZ_EQUIPMENT"."MANUFACTURER" IS '生产厂家';
COMMENT ON COLUMN "QUALITY"."BIZ_EQUIPMENT"."PRODUCTION_DATE" IS '生产日期';
COMMENT ON COLUMN "QUALITY"."BIZ_EQUIPMENT"."CONTACT_PERSON" IS '负责人姓名';
COMMENT ON COLUMN "QUALITY"."BIZ_EQUIPMENT"."PHONE" IS '联系方式';
COMMENT ON COLUMN "QUALITY"."BIZ_EQUIPMENT"."NUMBER_EQUIPMENT" IS '设备数量';


CREATE TABLE "QUALITY"."BIZ_PERSONNEL_MANAGEMENT" (
"ID" VARCHAR2(50 BYTE) NOT NULL ,
"CREATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"CREATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"DELETE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"DELETE_TIME" TIMESTAMP(6)  NULL ,
"UPDATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"UPDATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"ORG_ID" VARCHAR2(50 BYTE) NULL ,
"DEPT_ID" VARCHAR2(50 BYTE) NULL ,
"AREA_CODE" VARCHAR2(50 BYTE) NULL ,
"ORGANIZATION_ID" VARCHAR2(50 BYTE) NULL ,
"NAME" VARCHAR2(200 BYTE) NULL ,
"SEX" VARCHAR2(50 BYTE) NULL ,
"EDUCATION" VARCHAR2(50 BYTE) NULL ,
"TECHNICAL" VARCHAR2(200 BYTE) NULL ,
"WORKING_SENIORITY" VARCHAR2(50 BYTE) NULL ,
"PHONE" VARCHAR2(50 BYTE) NULL 
);

COMMENT ON TABLE "QUALITY"."BIZ_PERSONNEL_MANAGEMENT" IS '人员信息';
COMMENT ON COLUMN "QUALITY"."BIZ_PERSONNEL_MANAGEMENT"."ORGANIZATION_ID" IS '机构id';
COMMENT ON COLUMN "QUALITY"."BIZ_PERSONNEL_MANAGEMENT"."NAME" IS '姓名';
COMMENT ON COLUMN "QUALITY"."BIZ_PERSONNEL_MANAGEMENT"."SEX" IS '性别';
COMMENT ON COLUMN "QUALITY"."BIZ_PERSONNEL_MANAGEMENT"."EDUCATION" IS '学历';
COMMENT ON COLUMN "QUALITY"."BIZ_PERSONNEL_MANAGEMENT"."TECHNICAL" IS '职称';
COMMENT ON COLUMN "QUALITY"."BIZ_PERSONNEL_MANAGEMENT"."WORKING_SENIORITY" IS '工作年限';
COMMENT ON COLUMN "QUALITY"."BIZ_PERSONNEL_MANAGEMENT"."PHONE" IS '联系方式';


CREATE TABLE "QUALITY"."BIZ_TEST_PARAMETERS" (
"ID" VARCHAR2(50 BYTE) NOT NULL ,
"CREATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"CREATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"DELETE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"DELETE_TIME" TIMESTAMP(6)  NULL ,
"UPDATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"UPDATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"ORG_ID" VARCHAR2(50 BYTE) NULL ,
"DEPT_ID" VARCHAR2(50 BYTE) NULL ,
"AREA_CODE" VARCHAR2(50 BYTE) NULL ,
"ORGANIZATION_ID" VARCHAR2(50 BYTE) NULL ,
"INSPECTION_CATEGORY" VARCHAR2(200 BYTE) NULL ,
"TEST_PARAMETERS" VARCHAR2(200 BYTE) NULL 
);

COMMENT ON TABLE "QUALITY"."BIZ_TEST_PARAMETERS" IS '检验参数';
COMMENT ON COLUMN "QUALITY"."BIZ_TEST_PARAMETERS"."ID" IS 'ID';
COMMENT ON COLUMN "QUALITY"."BIZ_TEST_PARAMETERS"."ORGANIZATION_ID" IS '机构id';
COMMENT ON COLUMN "QUALITY"."BIZ_TEST_PARAMETERS"."INSPECTION_CATEGORY" IS '检验类别';
COMMENT ON COLUMN "QUALITY"."BIZ_TEST_PARAMETERS"."TEST_PARAMETERS" IS '检验参数';


CREATE TABLE "QUALITY"."BIZ_QUALITY_PREDICTION_PLANNED" (
"ID" VARCHAR2(50 BYTE) NOT NULL ,
"CREATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"CREATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"DELETE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"DELETE_TIME" TIMESTAMP(6)  NULL ,
"UPDATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"UPDATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"ORG_ID" VARCHAR2(50 BYTE) NULL ,
"DEPT_ID" VARCHAR2(50 BYTE) NULL ,
"AREA_CODE" VARCHAR2(50 BYTE) NULL ,
"PLAN_TYPE" VARCHAR2(200 BYTE) NULL ,
"PLAN_FILE_NAME" VARCHAR2(200 BYTE) NULL ,
"DISTRIBUTION_ATTACHMENTS" VARCHAR2(200 BYTE) NULL ,
"SCHEDULED_RELEASE_TIME" VARCHAR2(200 BYTE) NULL ,
"DOWNWARD_STATE" VARCHAR2(50 BYTE) NULL ,
"ATTACHMENTS_ID" VARCHAR2(50 BYTE) NULL ,
"PROCESS_ID" VARCHAR2(50 BYTE) NULL 
);
COMMENT ON TABLE "QUALITY"."BIZ_QUALITY_PREDICTION_PLANNED" IS '品质测报-计划下发';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_PLANNED"."PLAN_TYPE" IS '计划类型';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_PLANNED"."PLAN_FILE_NAME" IS '计划文件名称';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_PLANNED"."DISTRIBUTION_ATTACHMENTS" IS '附件';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_PLANNED"."SCHEDULED_RELEASE_TIME" IS '计划下达时间';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_PLANNED"."DOWNWARD_STATE" IS '状态';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_PLANNED"."ATTACHMENTS_ID" IS '附件id';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_PLANNED"."PROCESS_ID" IS '流程id';

CREATE TABLE "QUALITY"."BIZ_QUALITY_PREDICTION_AUDIT" (
"ID" VARCHAR2(50 BYTE) NOT NULL ,
"CREATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"CREATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"DELETE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"DELETE_TIME" TIMESTAMP(6)  NULL ,
"UPDATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"UPDATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"ORG_ID" VARCHAR2(50 BYTE) NULL ,
"DEPT_ID" VARCHAR2(50 BYTE) NULL ,
"AREA_CODE" VARCHAR2(50 BYTE) NULL ,
"PLAN_TYPE" VARCHAR2(200 BYTE) NULL ,
"PLAN_FILE_NAME" VARCHAR2(200 BYTE) NULL ,
"CITY" VARCHAR2(50 BYTE) NULL ,
"COMPANY_NAME" VARCHAR2(200 BYTE) NULL ,
"MIGRATION_AGENCIES" VARCHAR2(200 BYTE) NULL ,
"MIGRATION_DATE" VARCHAR2(200 BYTE) NULL ,
"RELOCATION_NUMBER" VARCHAR2(200 BYTE) NULL ,
"NATURE_FOOD" VARCHAR2(200 BYTE) NULL ,
"VARIETIES" VARCHAR2(50 BYTE) NULL ,
"SAMPLE_NUMBER" VARCHAR2(200 BYTE) NULL ,
"NUMBER_REPRESENTATIVES" VARCHAR2(200 BYTE) NULL ,
"YEARS" VARCHAR2(50 BYTE) NULL ,
"PLACE_ORIGIN" VARCHAR2(200 BYTE) NULL ,
"REVIEWER" VARCHAR2(200 BYTE) NULL ,
"AUDIT_OPINION" VARCHAR2(500 BYTE) NULL ,
"FINDINGS_AUDIT" VARCHAR2(50 BYTE) NULL ,
"ATTACHMENTS" VARCHAR2(2000 BYTE) NULL ,
"PROCESS_ID" VARCHAR2(50 BYTE) NULL ,
"STATE_NAME" VARCHAR2(50 BYTE) NULL ,
"PLAN_ID" VARCHAR2(50 BYTE) NULL ,
"STATE" VARCHAR2(50 BYTE) NULL ,
"SLSJ_STATE" VARCHAR2(50 BYTE) NULL ,
"SLSJ_MESSAGE" VARCHAR2(500 BYTE) NULL ,
"SZJZX_STATE" VARCHAR2(50 BYTE) NULL ,
"SZJZX_MESSAGE" VARCHAR2(500 BYTE) NULL ,
"SHLSJ_STATE" VARCHAR2(50 BYTE) NULL ,
"SHLSJ_MESSAGE" VARCHAR2(500 BYTE) NULL ,
"SHZJZX_STATE" VARCHAR2(50 BYTE) NULL ,
"SHZJZX_MESSAGE" VARCHAR2(500 BYTE) NULL ,
"XLSJ_STATE" VARCHAR2(50 BYTE) NULL ,
"XLSJ_MESSAGE" VARCHAR2(500 BYTE) NULL ,
"BATCH" VARCHAR2(50 BYTE) NULL 
);
COMMENT ON TABLE "QUALITY"."BIZ_QUALITY_PREDICTION_AUDIT" IS '品质测报-结果审核';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_AUDIT"."PLAN_TYPE" IS '计划类型';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_AUDIT"."PLAN_FILE_NAME" IS '计划文件名称';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_AUDIT"."CITY" IS '盟市';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_AUDIT"."COMPANY_NAME" IS '承储企业名称';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_AUDIT"."MIGRATION_AGENCIES" IS '扦样机构';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_AUDIT"."MIGRATION_DATE" IS '扦样日期';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_AUDIT"."RELOCATION_NUMBER" IS '扦样货位号';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_AUDIT"."NATURE_FOOD" IS '粮食性质';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_AUDIT"."VARIETIES" IS '品种';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_AUDIT"."SAMPLE_NUMBER" IS '样品编号';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_AUDIT"."NUMBER_REPRESENTATIVES" IS '代表数量';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_AUDIT"."YEARS" IS '收获年度';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_AUDIT"."PLACE_ORIGIN" IS '产地';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_AUDIT"."REVIEWER" IS '审核人';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_AUDIT"."AUDIT_OPINION" IS '审核意见';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_AUDIT"."FINDINGS_AUDIT" IS '审核结果';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_AUDIT"."ATTACHMENTS" IS '附件';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_AUDIT"."PROCESS_ID" IS '流程id';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_AUDIT"."STATE_NAME" IS '状态名称';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_AUDIT"."PLAN_ID" IS '计划id';

CREATE TABLE "QUALITY"."BIZ_QUALITY_PREDICTION_ITEMS" (
"ID" VARCHAR2(50 BYTE) NOT NULL ,
"CREATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"CREATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"DELETE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"DELETE_TIME" TIMESTAMP(6)  NULL ,
"UPDATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"UPDATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"ORG_ID" VARCHAR2(50 BYTE) NULL ,
"DEPT_ID" VARCHAR2(50 BYTE) NULL ,
"AREA_CODE" VARCHAR2(50 BYTE) NULL ,
"PLAN_TYPE" VARCHAR2(200 BYTE) NULL ,
"PLAN_FILE_NAME" VARCHAR2(200 BYTE) NULL ,
"VARIETIES" VARCHAR2(50 BYTE) NULL ,
"TEST_INDICATORS" VARCHAR2(50 BYTE) NULL ,
"TEST_VALUE" VARCHAR2(50 BYTE) NULL ,
"ADUIT_ID" VARCHAR2(50 BYTE) NULL ,
"BATCH" VARCHAR2(50 BYTE) NULL 
);
COMMENT ON TABLE "QUALITY"."BIZ_QUALITY_PREDICTION_ITEMS" IS '品质测报检测项目';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_ITEMS"."PLAN_TYPE" IS '计划类型--暂时不用';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_ITEMS"."PLAN_FILE_NAME" IS '计划文件名称--暂时不用';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_ITEMS"."VARIETIES" IS '品种';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_ITEMS"."TEST_INDICATORS" IS '检验指标';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_ITEMS"."TEST_VALUE" IS '检验值';
COMMENT ON COLUMN "QUALITY"."BIZ_QUALITY_PREDICTION_ITEMS"."ADUIT_ID" IS '审核结果id';

CREATE TABLE "QUALITY"."BIZ_FOOD_STOCK" (
"ID" VARCHAR2(50 BYTE) NOT NULL ,
"CREATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"CREATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"DELETE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"DELETE_TIME" TIMESTAMP(6)  NULL ,
"UPDATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"UPDATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"ORG_ID" VARCHAR2(50 BYTE) NULL ,
"DEPT_ID" VARCHAR2(50 BYTE) NULL ,
"AREA_CODE" VARCHAR2(50 BYTE) NULL ,
"PLAN_FILE_NAME" VARCHAR2(200 BYTE) NULL ,
"TYPE" VARCHAR2(50 BYTE) NULL ,
"CITY" VARCHAR2(200 BYTE) NULL ,
"FILLING_UNIT" VARCHAR2(200 BYTE) NULL ,
"FILLING_DATE" VARCHAR2(200 BYTE) NULL ,
"REGISTRAR" VARCHAR2(200 BYTE) NULL ,
"FINDINGS_AUDIT" VARCHAR2(200 BYTE) NULL ,
"AUDIT_OPINIONS" VARCHAR2(500 BYTE) NULL ,
"PROCESS_ID" VARCHAR2(50 BYTE) NULL ,
"STATE_NAME" VARCHAR2(50 BYTE) NULL ,
"PLAN_ID" VARCHAR2(50 BYTE) NULL ,
"STATE" VARCHAR2(50 BYTE) NULL ,
"SLSJ_STATE" VARCHAR2(50 BYTE) NULL ,
"SLSJ_MESSAGE" VARCHAR2(500 BYTE) NULL ,
"SZJZX_STATE" VARCHAR2(50 BYTE) NULL ,
"SZJZX_MESSAGE" VARCHAR2(500 BYTE) NULL ,
"SHLSJ_STATE" VARCHAR2(50 BYTE) NULL ,
"SHLSJ_MESSAGE" VARCHAR2(500 BYTE) NULL ,
"SHZJZX_STATE" VARCHAR2(50 BYTE) NULL ,
"SHZJZX_MESSAGE" VARCHAR2(500 BYTE) NULL ,
"XLSJ_STATE" VARCHAR2(50 BYTE) NULL ,
"XLSJ_MESSAGE" VARCHAR2(500 BYTE) NULL ,
"BATCH" VARCHAR2(50 BYTE) NULL 
);
COMMENT ON TABLE "QUALITY"."BIZ_FOOD_STOCK" IS '库存粮食质量检测品登统表';
COMMENT ON COLUMN "QUALITY"."BIZ_FOOD_STOCK"."PLAN_FILE_NAME" IS '计划文件名称';
COMMENT ON COLUMN "QUALITY"."BIZ_FOOD_STOCK"."TYPE" IS '检验结果上报 1库存粮食质量检测品登统表 2 检验结果等级表';
COMMENT ON COLUMN "QUALITY"."BIZ_FOOD_STOCK"."CITY" IS '旗县、盟市';
COMMENT ON COLUMN "QUALITY"."BIZ_FOOD_STOCK"."FILLING_UNIT" IS '填报单位';
COMMENT ON COLUMN "QUALITY"."BIZ_FOOD_STOCK"."FILLING_DATE" IS '填报日期';
COMMENT ON COLUMN "QUALITY"."BIZ_FOOD_STOCK"."REGISTRAR" IS '样品信息登统人员';
COMMENT ON COLUMN "QUALITY"."BIZ_FOOD_STOCK"."FINDINGS_AUDIT" IS '审核结果';
COMMENT ON COLUMN "QUALITY"."BIZ_FOOD_STOCK"."AUDIT_OPINIONS" IS '审核意见';
COMMENT ON COLUMN "QUALITY"."BIZ_FOOD_STOCK"."PLAN_ID" IS '计划id';
COMMENT ON COLUMN "QUALITY"."BIZ_FOOD_STOCK"."SHZJZX_STATE" IS '批次';


CREATE TABLE "QUALITY"."BIZ_FOOD_STOCK_ITEMS" (
"ID" VARCHAR2(50 BYTE) NOT NULL ,
"CREATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"CREATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"DELETE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"DELETE_TIME" TIMESTAMP(6)  NULL ,
"UPDATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"UPDATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"ORG_ID" VARCHAR2(50 BYTE) NULL ,
"DEPT_ID" VARCHAR2(50 BYTE) NULL ,
"AREA_CODE" VARCHAR2(50 BYTE) NULL ,
"FOOD_STOCK_ID" VARCHAR2(200 BYTE) NOT NULL ,
"SAMPLE_NUMBER" VARCHAR2(200 BYTE) NULL ,
"CHECK_LIBRARY_POINTS" VARCHAR2(200 BYTE) NULL ,
"WAREHOUSE" VARCHAR2(200 BYTE) NULL ,
"NATURE" VARCHAR2(200 BYTE) NULL ,
"VARIETIES" VARCHAR2(200 BYTE) NULL ,
"BEHALF_NUMBER" NUMBER(18) DEFAULT NULL  NULL ,
"STORAGE_GRADE" VARCHAR2(200 BYTE) NULL ,
"PLACE_ORIGIN" VARCHAR2(200 BYTE) NULL ,
"YEARS" VARCHAR2(200 BYTE) NULL ,
"STORAGE_TIME" VARCHAR2(200 BYTE) NULL ,
"PACKAGING_OR_BULK_PACKING" VARCHAR2(200 BYTE) NULL ,
"LOCAL_SAFE_STORAGE_OF_WATER" VARCHAR2(200 BYTE) NULL ,
"GRAIN_TEMPERATURE" VARCHAR2(200 BYTE) NULL ,
"STORAGE_TECHNOLOGY" VARCHAR2(200 BYTE) NULL ,
"REMARKS" VARCHAR2(200 BYTE) NULL ,
"BATCH" VARCHAR2(50 BYTE) NULL 
);
COMMENT ON TABLE "QUALITY"."BIZ_FOOD_STOCK_ITEMS" IS '库存粮食质量检测品登统--明细表';
COMMENT ON COLUMN "QUALITY"."BIZ_FOOD_STOCK_ITEMS"."ID" IS 'id';
COMMENT ON COLUMN "QUALITY"."BIZ_FOOD_STOCK_ITEMS"."FOOD_STOCK_ID" IS '登统表ID';
COMMENT ON COLUMN "QUALITY"."BIZ_FOOD_STOCK_ITEMS"."SAMPLE_NUMBER" IS '样品编号';
COMMENT ON COLUMN "QUALITY"."BIZ_FOOD_STOCK_ITEMS"."CHECK_LIBRARY_POINTS" IS '检查库点';
COMMENT ON COLUMN "QUALITY"."BIZ_FOOD_STOCK_ITEMS"."WAREHOUSE" IS '扦样处所（仓库或堆垛号码）';
COMMENT ON COLUMN "QUALITY"."BIZ_FOOD_STOCK_ITEMS"."NATURE" IS '储粮性质';
COMMENT ON COLUMN "QUALITY"."BIZ_FOOD_STOCK_ITEMS"."VARIETIES" IS '样品名称';
COMMENT ON COLUMN "QUALITY"."BIZ_FOOD_STOCK_ITEMS"."BEHALF_NUMBER" IS '代表数量（吨）';
COMMENT ON COLUMN "QUALITY"."BIZ_FOOD_STOCK_ITEMS"."STORAGE_GRADE" IS '入库等级';
COMMENT ON COLUMN "QUALITY"."BIZ_FOOD_STOCK_ITEMS"."PLACE_ORIGIN" IS '产地';
COMMENT ON COLUMN "QUALITY"."BIZ_FOOD_STOCK_ITEMS"."YEARS" IS '收获年度';
COMMENT ON COLUMN "QUALITY"."BIZ_FOOD_STOCK_ITEMS"."STORAGE_TIME" IS '入库时间';
COMMENT ON COLUMN "QUALITY"."BIZ_FOOD_STOCK_ITEMS"."PACKAGING_OR_BULK_PACKING" IS '包装或散装';
COMMENT ON COLUMN "QUALITY"."BIZ_FOOD_STOCK_ITEMS"."LOCAL_SAFE_STORAGE_OF_WATER" IS '当地安全储存水分';
COMMENT ON COLUMN "QUALITY"."BIZ_FOOD_STOCK_ITEMS"."GRAIN_TEMPERATURE" IS '粮温';
COMMENT ON COLUMN "QUALITY"."BIZ_FOOD_STOCK_ITEMS"."STORAGE_TECHNOLOGY" IS '使用的储粮技术';
COMMENT ON COLUMN "QUALITY"."BIZ_FOOD_STOCK_ITEMS"."REMARKS" IS '备注';

CREATE TABLE "QUALITY"."BIZ_GRADE_TEST_RESULTS" (
"ID" VARCHAR2(50 BYTE) NOT NULL ,
"CREATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"CREATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"DELETE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"DELETE_TIME" TIMESTAMP(6)  NULL ,
"UPDATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"UPDATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"ORG_ID" VARCHAR2(50 BYTE) NULL ,
"DEPT_ID" VARCHAR2(50 BYTE) NULL ,
"AREA_CODE" VARCHAR2(50 BYTE) NULL ,
"FOOD_STOCK_ID" VARCHAR2(50 BYTE) NOT NULL ,
"PLAN_FILE_NAME" VARCHAR2(200 BYTE) NULL ,
"TYPE" VARCHAR2(50 BYTE) NULL ,
"CITY" VARCHAR2(200 BYTE) NULL ,
"FILLING_UNIT" VARCHAR2(200 BYTE) NULL ,
"FILLING_DATE" VARCHAR2(200 BYTE) NULL ,
"FINDINGS_AUDIT" VARCHAR2(200 BYTE) NULL ,
"AUDIT_OPINIONS" VARCHAR2(200 BYTE) NULL ,
"PROCESS_ID" VARCHAR2(50 BYTE) NULL ,
"STATE_NAME" VARCHAR2(50 BYTE) NULL ,
"VARIETIES" VARCHAR2(255 BYTE) NULL ,
"BATCH" VARCHAR2(50 BYTE) NULL 
);
COMMENT ON TABLE "QUALITY"."BIZ_GRADE_TEST_RESULTS" IS '检验结果等级表';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS"."FOOD_STOCK_ID" IS '库存粮食质量检测品登统表ID';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS"."PLAN_FILE_NAME" IS '计划文件名称';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS"."TYPE" IS '检验结果上报 1库存粮食质量检测品登统表 2 检验结果等级表';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS"."CITY" IS '旗县、盟市';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS"."FILLING_UNIT" IS '填报单位';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS"."FILLING_DATE" IS '填报日期';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS"."FINDINGS_AUDIT" IS '审核结果';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS"."AUDIT_OPINIONS" IS '审核意见';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS"."VARIETIES" IS '样品名称';

CREATE TABLE "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS" (
"ID" VARCHAR2(50 BYTE) NOT NULL ,
"CREATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"CREATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"DELETE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"DELETE_TIME" TIMESTAMP(6)  NULL ,
"UPDATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"UPDATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"ORG_ID" VARCHAR2(50 BYTE) NULL ,
"DEPT_ID" VARCHAR2(50 BYTE) NULL ,
"AREA_CODE" VARCHAR2(50 BYTE) NULL ,
"WATER_CONTENT" NUMBER(18) NULL ,
"IMPURITY" VARCHAR2(200 BYTE) NULL ,
"IMPERFECT_GRAIN" VARCHAR2(200 BYTE) NULL ,
"BULK_DENSITY" VARCHAR2(200 BYTE) NULL ,
"COLOUR_SMELL" VARCHAR2(200 BYTE) NULL ,
"MOLDY_KERNEL" VARCHAR2(200 BYTE) NULL ,
"TASTE_SCORE" VARCHAR2(200 BYTE) NULL ,
"FATTY_ACID_VALUE" VARCHAR2(200 BYTE) NULL ,
"INSPECTION_GRADE" VARCHAR2(200 BYTE) NULL ,
"RESULT_JUDGMENT" VARCHAR2(200 BYTE) NULL ,
"INTEGRITY_RATE_GRANULE" VARCHAR2(200 BYTE) NULL ,
"DAMAGE_RATE_GRANULE" VARCHAR2(200 BYTE) NULL ,
"ROUGHNESS" VARCHAR2(200 BYTE) NULL ,
"BROWN_RICE" VARCHAR2(200 BYTE) NULL ,
"HEAD_RICE_RATE" VARCHAR2(200 BYTE) NULL ,
"MIXING_RATE" VARCHAR2(200 BYTE) NULL ,
"YELLOW_GRAINED_RICE" VARCHAR2(200 BYTE) NULL ,
"FATTY_ACID_VALUE_STORAGE" VARCHAR2(200 BYTE) NULL ,
"VISCOSITY" VARCHAR2(200 BYTE) NULL ,
"TASTE_SCORE_STORAGE" VARCHAR2(200 BYTE) NULL ,
"COLOUR_SMELL_STORAGE" VARCHAR2(200 BYTE) NULL ,
"RESULT_JUDGMENT_STORAGE" VARCHAR2(200 BYTE) NULL ,
"GLUTEN_WATER_ABSORPTION" VARCHAR2(200 BYTE) NULL ,
"PROTEIN_SOLUBILITY_RATIO" VARCHAR2(200 BYTE) NULL ,
"GRADE_TEST_RESULTS_ID" VARCHAR2(50 BYTE) NULL ,
"SAMPLE_NUMBER" VARCHAR2(200 BYTE) NULL ,
"CHECK_LIBRARY_POINTS" VARCHAR2(200 BYTE) NULL ,
"WAREHOUSE" VARCHAR2(200 BYTE) NULL ,
"NATURE" VARCHAR2(200 BYTE) NULL ,
"VARIETIES" VARCHAR2(200 BYTE) NULL ,
"BEHALF_NUMBER" VARCHAR2(200 BYTE) NULL ,
"STORAGE_GRADE" VARCHAR2(200 BYTE) NULL ,
"PLACE_ORIGIN" VARCHAR2(200 BYTE) NULL ,
"YEARS" VARCHAR2(200 BYTE) NULL ,
"STORAGE_TIME" VARCHAR2(200 BYTE) NULL ,
"FOOD_STOCK_ID" VARCHAR2(50 BYTE) NULL ,
"TYPE" VARCHAR2(50 BYTE) NULL ,
"BATCH" VARCHAR2(50 BYTE) NULL 
);
COMMENT ON TABLE "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS" IS '检验结果登记表-明细';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."ID" IS 'id';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."WATER_CONTENT" IS '水分';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."IMPURITY" IS '杂质';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."IMPERFECT_GRAIN" IS '不完善粒';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."BULK_DENSITY" IS '容重';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."COLOUR_SMELL" IS '色泽气味';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."MOLDY_KERNEL" IS '生霉粒';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."TASTE_SCORE" IS '品尝评分值';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."FATTY_ACID_VALUE" IS '脂肪酸值';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."INSPECTION_GRADE" IS '检验等级';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."RESULT_JUDGMENT" IS '结果判定';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."INTEGRITY_RATE_GRANULE" IS '完整率粒';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."DAMAGE_RATE_GRANULE" IS '损伤率粒';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."ROUGHNESS" IS '出糙率';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."BROWN_RICE" IS '谷外糙米';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."HEAD_RICE_RATE" IS '整精米率';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."MIXING_RATE" IS '互混率';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."YELLOW_GRAINED_RICE" IS '黄粒米';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."FATTY_ACID_VALUE_STORAGE" IS '脂肪酸值-储存品质';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."VISCOSITY" IS '粘度';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."TASTE_SCORE_STORAGE" IS '品尝评分值-储存品质';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."COLOUR_SMELL_STORAGE" IS '色泽气味-储存品质';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."RESULT_JUDGMENT_STORAGE" IS '结果判定-储存品质';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."GLUTEN_WATER_ABSORPTION" IS '面筋吸水量';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."PROTEIN_SOLUBILITY_RATIO" IS '蛋白质溶解比较率';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."GRADE_TEST_RESULTS_ID" IS '登记表id';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."SAMPLE_NUMBER" IS '样品编号';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."CHECK_LIBRARY_POINTS" IS '检查库点';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."WAREHOUSE" IS '扦样处所（仓库或堆垛号码）';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."NATURE" IS '储粮性质';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."VARIETIES" IS '样品名称';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."BEHALF_NUMBER" IS '代表数量（吨）';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."STORAGE_GRADE" IS '入库等级';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."PLACE_ORIGIN" IS '产地';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."YEARS" IS '收获年度';
COMMENT ON COLUMN "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS"."STORAGE_TIME" IS '入库时间';

CREATE TABLE "QUALITY"."BIZ_SUMMARY_RESULTS" (
"ID" VARCHAR2(50 BYTE) NOT NULL ,
"CREATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"CREATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"DELETE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"DELETE_TIME" TIMESTAMP(6)  NULL ,
"UPDATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"UPDATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"ORG_ID" VARCHAR2(50 BYTE) NULL ,
"DEPT_ID" VARCHAR2(50 BYTE) NULL ,
"AREA_CODE" VARCHAR2(50 BYTE) NULL ,
"PLAN_FILE_NAME" VARCHAR2(200 BYTE) NULL ,
"PLAN_ID" VARCHAR2(50 BYTE) NULL ,
"CITY" VARCHAR2(50 BYTE) NULL ,
"TYPE" VARCHAR2(50 BYTE) NULL ,
"FILLING_UNIT" VARCHAR2(200 BYTE) NULL ,
"FOOD_NATURE" VARCHAR2(200 BYTE) NULL ,
"CHECK_POINT" VARCHAR2(200 BYTE) NULL ,
"FINDINGS_AUDIT" VARCHAR2(200 BYTE) NULL ,
"AUDIT_OPINIONS" VARCHAR2(500 BYTE) NULL ,
"PROCESS_ID" VARCHAR2(50 BYTE) NULL ,
"STATE_NAME" VARCHAR2(50 BYTE) NULL ,
"STATE" VARCHAR2(50 BYTE) NULL ,
"SLSJ_STATE" VARCHAR2(50 BYTE) NULL ,
"SLSJ_MESSAGE" VARCHAR2(500 BYTE) NULL ,
"SZJZX_STATE" VARCHAR2(50 BYTE) NULL ,
"SZJZX_MESSAGE" VARCHAR2(500 BYTE) NULL ,
"SHLSJ_STATE" VARCHAR2(50 BYTE) NULL ,
"SHLSJ_MESSAGE" VARCHAR2(500 BYTE) NULL ,
"SHZJZX_STATE" VARCHAR2(50 BYTE) NULL ,
"SHZJZX_MESSAGE" VARCHAR2(500 BYTE) NULL ,
"XLSJ_STATE" VARCHAR2(50 BYTE) NULL ,
"XLSJ_MESSAGE" VARCHAR2(500 BYTE) NULL ,
"BATCH" VARCHAR2(50 BYTE) NULL 
);
COMMENT ON TABLE "QUALITY"."BIZ_SUMMARY_RESULTS" IS '粮食质量检验结果汇总表';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS"."ID" IS 'id';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS"."PLAN_FILE_NAME" IS '计划名称';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS"."PLAN_ID" IS '计划id';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS"."CITY" IS '盟市、旗县';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS"."TYPE" IS '类型（表名）';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS"."FILLING_UNIT" IS '填报单位';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS"."FOOD_NATURE" IS '粮食性质';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS"."CHECK_POINT" IS '检查时点';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS"."FINDINGS_AUDIT" IS '审核结果';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS"."AUDIT_OPINIONS" IS '审核意见';


CREATE TABLE "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS" (
"ID" VARCHAR2(50 BYTE) NOT NULL ,
"CREATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"CREATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"DELETE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"DELETE_TIME" TIMESTAMP(6)  NULL ,
"UPDATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"UPDATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"ORG_ID" VARCHAR2(50 BYTE) NULL ,
"DEPT_ID" VARCHAR2(50 BYTE) NULL ,
"AREA_CODE" VARCHAR2(50 BYTE) NULL ,
"SUMMARY_ID" VARCHAR2(50 BYTE) NULL ,
"CHECK_LIBRARY_POINTS" VARCHAR2(200 BYTE) NULL ,
"COMPANY_NUMBER" VARCHAR2(200 BYTE) NULL ,
"SAMPLES_TOTAL" VARCHAR2(200 BYTE) NULL ,
"REPRESENTATIVES_NUMBER" VARCHAR2(200 BYTE) NULL ,
"ACHIEVEMENT_RATE" VARCHAR2(200 BYTE) NULL ,
"PADDY_SAMPLES_NUMBER" VARCHAR2(200 BYTE) NULL ,
"PADDY_REPRESENTATIVES_NUMBER" VARCHAR2(200 BYTE) NULL ,
"PADDY_ACHIEVEMENT_RATE" VARCHAR2(200 BYTE) NULL ,
"WHEAT_SAMPLES_NUMBER" VARCHAR2(200 BYTE) NULL ,
"WHEAT_REPRESENTATIVES_NUMBER" VARCHAR2(200 BYTE) NULL ,
"WHEAT_ACHIEVEMENT_RATE" VARCHAR2(200 BYTE) NULL ,
"CORN_SAMPLES_NUMBER" VARCHAR2(200 BYTE) NULL ,
"CORN_REPRESENTATIVES_NUMBER" VARCHAR2(200 BYTE) NULL ,
"CORN_ACHIEVEMENT_RATE" VARCHAR2(200 BYTE) NULL ,
"SOYBEAN_SAMPLES_NUMBER" VARCHAR2(200 BYTE) NULL ,
"SOYBEAN_REPRESENTATIVES_NUMBER" VARCHAR2(200 BYTE) NULL ,
"SOYBEAN_ACHIEVEMENT_RATE" VARCHAR2(200 BYTE) NULL ,
"RICE_SAMPLES_NUMBER" VARCHAR2(200 BYTE) NULL ,
"RICE_REPRESENTATIVES_NUMBER" VARCHAR2(200 BYTE) NULL ,
"RICE_ACHIEVEMENT_RATE" VARCHAR2(200 BYTE) NULL ,
"WHEATMEAL_SAMPLES_NUMBER" VARCHAR2(200 BYTE) NULL ,
"WHEATMEAL_REPRESENTATIVES_NUMB" VARCHAR2(200 BYTE) NULL ,
"WHEATMEAL_ACHIEVEMENT_RATE" VARCHAR2(200 BYTE) NULL ,
"PROCESS_ID" VARCHAR2(50 BYTE) NULL ,
"STATE_NAME" VARCHAR2(50 BYTE) NULL ,
"TYPE" VARCHAR2(50 BYTE) NULL ,
"BATCH" VARCHAR2(50 BYTE) NULL 
);
COMMENT ON TABLE "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS" IS '粮食质量检验结果汇总表----明细表';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS"."ID" IS 'id';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS"."SUMMARY_ID" IS '汇总表id';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS"."CHECK_LIBRARY_POINTS" IS '检查地区或库点';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS"."COMPANY_NUMBER" IS '检查企业个数';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS"."SAMPLES_TOTAL" IS '样品总数';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS"."REPRESENTATIVES_NUMBER" IS '代表数量';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS"."ACHIEVEMENT_RATE" IS '达标率';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS"."PADDY_SAMPLES_NUMBER" IS '稻谷-样品数';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS"."PADDY_REPRESENTATIVES_NUMBER" IS '稻谷-代表数量';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS"."PADDY_ACHIEVEMENT_RATE" IS '稻谷-达标率';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS"."WHEAT_SAMPLES_NUMBER" IS '小麦-样品数';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS"."WHEAT_REPRESENTATIVES_NUMBER" IS '小麦-代表数量';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS"."WHEAT_ACHIEVEMENT_RATE" IS '小麦-达标率';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS"."CORN_SAMPLES_NUMBER" IS '玉米-样品数';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS"."CORN_REPRESENTATIVES_NUMBER" IS '玉米-代表数量';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS"."CORN_ACHIEVEMENT_RATE" IS '玉米-达标率';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS"."SOYBEAN_SAMPLES_NUMBER" IS '大豆-样品数';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS"."SOYBEAN_REPRESENTATIVES_NUMBER" IS '大豆-代表数量';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS"."SOYBEAN_ACHIEVEMENT_RATE" IS '大豆-达标率';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS"."RICE_SAMPLES_NUMBER" IS '大米-样品数';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS"."RICE_REPRESENTATIVES_NUMBER" IS '大米-代表数量';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS"."RICE_ACHIEVEMENT_RATE" IS '大米-达标率';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS"."WHEATMEAL_SAMPLES_NUMBER" IS '小麦粉-样品数';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS"."WHEATMEAL_REPRESENTATIVES_NUMB" IS '小麦粉-代表数量';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS"."WHEATMEAL_ACHIEVEMENT_RATE" IS '小麦粉-达标率';

CREATE TABLE "QUALITY"."BIZ_SUMMARY_SUBSTANDARD_SAMPLE" (
"ID" VARCHAR2(50 BYTE) NOT NULL ,
"CREATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"CREATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"DELETE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"DELETE_TIME" TIMESTAMP(6)  NULL ,
"UPDATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"UPDATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"ORG_ID" VARCHAR2(50 BYTE) NULL ,
"DEPT_ID" VARCHAR2(50 BYTE) NULL ,
"AREA_CODE" VARCHAR2(50 BYTE) NULL ,
"PLAN_FILE_NAME" VARCHAR2(200 BYTE) NULL ,
"PLAN_ID" VARCHAR2(50 BYTE) NULL ,
"CITY" VARCHAR2(50 BYTE) NULL ,
"TYPE" VARCHAR2(50 BYTE) NULL ,
"FILLING_UNIT" VARCHAR2(200 BYTE) NULL ,
"LIBRARY_POINT_NAME" VARCHAR2(200 BYTE) NULL ,
"WAREHOUSE" VARCHAR2(200 BYTE) NULL ,
"SAMPLE_NUMBER" VARCHAR2(200 BYTE) NULL ,
"REPRESENTATIVES_NUMBER" VARCHAR2(200 BYTE) NULL ,
"NATURE" VARCHAR2(200 BYTE) NULL ,
"VARIETIES" VARCHAR2(200 BYTE) NULL ,
"PLACE_ORIGIN" VARCHAR2(200 BYTE) NULL ,
"HARVEST_LIFE" VARCHAR2(200 BYTE) NULL ,
"STORAGE_TIME" VARCHAR2(200 BYTE) NULL ,
"UNQUALIFIED_ITEMS" VARCHAR2(200 BYTE) NULL ,
"DETECTION_VALUE" VARCHAR2(200 BYTE) NULL ,
"FINDINGS_AUDIT" VARCHAR2(200 BYTE) NULL ,
"AUDIT_OPINIONS" VARCHAR2(200 BYTE) NULL ,
"PROCESS_ID" VARCHAR2(50 BYTE) NULL ,
"STATE_NAME" VARCHAR2(50 BYTE) NULL ,
"BATCH" VARCHAR2(50 BYTE) NULL 
);
COMMENT ON TABLE "QUALITY"."BIZ_SUMMARY_SUBSTANDARD_SAMPLE" IS '质量不达标样品汇总表';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_SUBSTANDARD_SAMPLE"."ID" IS 'id';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_SUBSTANDARD_SAMPLE"."PLAN_FILE_NAME" IS '计划名称';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_SUBSTANDARD_SAMPLE"."PLAN_ID" IS '计划id';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_SUBSTANDARD_SAMPLE"."CITY" IS '盟市';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_SUBSTANDARD_SAMPLE"."TYPE" IS '类型（表名）';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_SUBSTANDARD_SAMPLE"."FILLING_UNIT" IS '填报单位';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_SUBSTANDARD_SAMPLE"."LIBRARY_POINT_NAME" IS '库点名称';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_SUBSTANDARD_SAMPLE"."WAREHOUSE" IS '扦样处所';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_SUBSTANDARD_SAMPLE"."SAMPLE_NUMBER" IS '样品编号';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_SUBSTANDARD_SAMPLE"."REPRESENTATIVES_NUMBER" IS '代表数量';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_SUBSTANDARD_SAMPLE"."NATURE" IS '储粮性质';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_SUBSTANDARD_SAMPLE"."VARIETIES" IS '品种';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_SUBSTANDARD_SAMPLE"."PLACE_ORIGIN" IS '产地/生产厂家';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_SUBSTANDARD_SAMPLE"."HARVEST_LIFE" IS '收获年限';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_SUBSTANDARD_SAMPLE"."STORAGE_TIME" IS '入库时间';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_SUBSTANDARD_SAMPLE"."UNQUALIFIED_ITEMS" IS '不达标项目';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_SUBSTANDARD_SAMPLE"."DETECTION_VALUE" IS '检测值';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_SUBSTANDARD_SAMPLE"."FINDINGS_AUDIT" IS '审核结果';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_SUBSTANDARD_SAMPLE"."AUDIT_OPINIONS" IS '审核意见';

CREATE TABLE "QUALITY"."BIZ_SUMMARY_NOT_SUITABLE" (
"ID" VARCHAR2(50 BYTE) NOT NULL ,
"CREATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"CREATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"DELETE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"DELETE_TIME" TIMESTAMP(6)  NULL ,
"UPDATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"UPDATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"ORG_ID" VARCHAR2(50 BYTE) NULL ,
"DEPT_ID" VARCHAR2(50 BYTE) NULL ,
"AREA_CODE" VARCHAR2(50 BYTE) NULL ,
"PLAN_FILE_NAME" VARCHAR2(200 BYTE) NULL ,
"PLAN_ID" VARCHAR2(50 BYTE) NULL ,
"CITY" VARCHAR2(50 BYTE) NULL ,
"TYPE" VARCHAR2(50 BYTE) NULL ,
"FILLING_UNIT" VARCHAR2(200 BYTE) NULL ,
"CHECK_LIBRARY_POINTS" VARCHAR2(200 BYTE) NULL ,
"WAREHOUSE" VARCHAR2(200 BYTE) NULL ,
"FOOD_NATURE" VARCHAR2(200 BYTE) NULL ,
"VARIETIES" VARCHAR2(200 BYTE) NULL ,
"REPRESENTATIVES_NUMBER" VARCHAR2(200 BYTE) NULL ,
"PROJECT" VARCHAR2(200 BYTE) NULL ,
"TEST_VALUE" VARCHAR2(200 BYTE) NULL ,
"SEVERE_INAPPROPRIATE_SURVIVAL" VARCHAR2(200 BYTE) NULL ,
"MILD_UNSUITABLE_STORAGE" VARCHAR2(200 BYTE) NULL ,
"FINDINGS_AUDIT" VARCHAR2(200 BYTE) NULL ,
"AUDIT_OPINIONS" VARCHAR2(200 BYTE) NULL ,
"PROCESS_ID" VARCHAR2(50 BYTE) NULL ,
"STATE_NAME" VARCHAR2(50 BYTE) NULL ,
"BATCH" VARCHAR2(50 BYTE) NULL 
);
COMMENT ON TABLE "QUALITY"."BIZ_SUMMARY_NOT_SUITABLE" IS '储存品质不宜存样品汇总表';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_NOT_SUITABLE"."ID" IS 'id';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_NOT_SUITABLE"."PLAN_FILE_NAME" IS '计划名称';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_NOT_SUITABLE"."PLAN_ID" IS '计划id';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_NOT_SUITABLE"."CITY" IS '盟市';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_NOT_SUITABLE"."TYPE" IS '类型（表名）';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_NOT_SUITABLE"."FILLING_UNIT" IS '填报单位';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_NOT_SUITABLE"."CHECK_LIBRARY_POINTS" IS '检查库点名称';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_NOT_SUITABLE"."WAREHOUSE" IS '扦样处所';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_NOT_SUITABLE"."FOOD_NATURE" IS '粮食性质';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_NOT_SUITABLE"."VARIETIES" IS '样品名称';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_NOT_SUITABLE"."REPRESENTATIVES_NUMBER" IS '代表数量';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_NOT_SUITABLE"."PROJECT" IS '项目';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_NOT_SUITABLE"."TEST_VALUE" IS '检验值';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_NOT_SUITABLE"."SEVERE_INAPPROPRIATE_SURVIVAL" IS '是否为重度不宜存样品';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_NOT_SUITABLE"."MILD_UNSUITABLE_STORAGE" IS '是否为轻度不宜存样品';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_NOT_SUITABLE"."FINDINGS_AUDIT" IS '审核结果';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_NOT_SUITABLE"."AUDIT_OPINIONS" IS '审核意见';


CREATE TABLE "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT" (
"ID" VARCHAR2(50 BYTE) NOT NULL ,
"CREATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"CREATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"DELETE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"DELETE_TIME" TIMESTAMP(6)  NULL ,
"UPDATE_BY" VARCHAR2(36 BYTE) DEFAULT -1  NULL ,
"UPDATE_TIME" TIMESTAMP(6)  DEFAULT null  NULL ,
"ORG_ID" VARCHAR2(50 BYTE) NULL ,
"DEPT_ID" VARCHAR2(50 BYTE) NULL ,
"AREA_CODE" VARCHAR2(50 BYTE) NULL ,
"PLAN_FILE_NAME" VARCHAR2(200 BYTE) NOT NULL ,
"PLAN_ID" VARCHAR2(50 BYTE) NULL ,
"CITY" VARCHAR2(50 BYTE) NULL ,
"TYPE" VARCHAR2(50 BYTE) NULL ,
"FILLING_UNIT" VARCHAR2(200 BYTE) NULL ,
"FOOD_NATURE" VARCHAR2(200 BYTE) NULL ,
"CHECK_POINT" VARCHAR2(200 BYTE) NULL ,
"INSPECTION_AREA" VARCHAR2(200 BYTE) NULL ,
"COMPANY_NUMBER" VARCHAR2(200 BYTE) NULL ,
"SAMPLES_TOTAL" VARCHAR2(200 BYTE) NULL ,
"REPRESENTATIVES_NUMBER" VARCHAR2(200 BYTE) NULL ,
"SURVIVABILITY_RATE" VARCHAR2(200 BYTE) NULL ,
"MILD_UNSUITABLE_STORAGE" VARCHAR2(200 BYTE) NULL ,
"SEVERE_INAPPROPRIATE_SURVIVAL" VARCHAR2(200 BYTE) NULL ,
"PADDY_SAMPLES_NUMBER" VARCHAR2(200 BYTE) NULL ,
"PADDY_SURVIVABILITY_RATE" VARCHAR2(200 BYTE) NULL ,
"PADDY_MILD_UNSUITABLE_STORAGE" VARCHAR2(200 BYTE) NULL ,
"PADDY_SEVERE_INAPPROPRIATE_SUR" VARCHAR2(200 BYTE) NULL ,
"WHEAT_SAMPLES_NUMBER" VARCHAR2(200 BYTE) NULL ,
"WHEAT_SURVIVABILITY_RATE" VARCHAR2(200 BYTE) NULL ,
"WHEAT_MILD_UNSUITABLE_STORAGE" VARCHAR2(200 BYTE) NULL ,
"WHEAT_SEVERE_INAPPROPRIATE_SUR" VARCHAR2(200 BYTE) NULL ,
"CORN_SAMPLES_NUMBER" VARCHAR2(200 BYTE) NULL ,
"CORN_SURVIVABILITY_RATE" VARCHAR2(200 BYTE) NULL ,
"CORN_MILD_UNSUITABLE_STORAGE" VARCHAR2(200 BYTE) NULL ,
"CORN_SEVERE_INAPPROPRIATE_SURV" VARCHAR2(200 BYTE) NULL ,
"SOYBEAN_SAMPLES_NUMBER" VARCHAR2(200 BYTE) NULL ,
"SOYBEAN_SURVIVABILITY_RATE" VARCHAR2(200 BYTE) NULL ,
"SOYBEAN_MILD_UNSUITABLE_STORAG" VARCHAR2(200 BYTE) NULL ,
"SOYBEAN_SEVERE_INAPPROPRIATE_S" VARCHAR2(200 BYTE) NULL ,
"FINDINGS_AUDIT" VARCHAR2(200 BYTE) NULL ,
"AUDIT_OPINIONS" VARCHAR2(200 BYTE) NULL ,
"PROCESS_ID" VARCHAR2(50 BYTE) NULL ,
"STATE_NAME" VARCHAR2(50 BYTE) NULL ,
"BATCH" VARCHAR2(50 BYTE) NULL 
);
COMMENT ON TABLE "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT" IS '粮食储存品质检验结果汇总表';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."ID" IS 'id';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."PLAN_FILE_NAME" IS '计划名称';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."PLAN_ID" IS '计划id';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."CITY" IS '盟市';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."TYPE" IS '类型（表名）';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."FILLING_UNIT" IS '填报单位';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."FOOD_NATURE" IS '粮食性质';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."CHECK_POINT" IS '检查时点';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."INSPECTION_AREA" IS '检查地区';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."COMPANY_NUMBER" IS '检查企业个数';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."SAMPLES_TOTAL" IS '样品总数';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."REPRESENTATIVES_NUMBER" IS '代表数量';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."SURVIVABILITY_RATE" IS '宜存率';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."MILD_UNSUITABLE_STORAGE" IS '轻度不宜存';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."SEVERE_INAPPROPRIATE_SURVIVAL" IS '重度不宜存';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."PADDY_SAMPLES_NUMBER" IS '稻谷-样品数';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."PADDY_SURVIVABILITY_RATE" IS '稻谷-宜存率';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."PADDY_MILD_UNSUITABLE_STORAGE" IS '稻谷-轻度不宜存率';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."PADDY_SEVERE_INAPPROPRIATE_SUR" IS '稻谷-重度不宜存率';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."WHEAT_SAMPLES_NUMBER" IS '小麦-样品数';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."WHEAT_SURVIVABILITY_RATE" IS '小麦-宜存率';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."WHEAT_MILD_UNSUITABLE_STORAGE" IS '小麦-轻度不宜存率';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."WHEAT_SEVERE_INAPPROPRIATE_SUR" IS '小麦-重度不宜存率';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."CORN_SAMPLES_NUMBER" IS '玉米-样品数';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."CORN_SURVIVABILITY_RATE" IS '玉米-宜存率';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."CORN_MILD_UNSUITABLE_STORAGE" IS '玉米-轻度不宜存率';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."CORN_SEVERE_INAPPROPRIATE_SURV" IS '玉米-重度不宜存率';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."SOYBEAN_SAMPLES_NUMBER" IS '大豆-样品数';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."SOYBEAN_SURVIVABILITY_RATE" IS '大豆宜存率';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."SOYBEAN_MILD_UNSUITABLE_STORAG" IS '大豆-轻度不宜存率';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."SOYBEAN_SEVERE_INAPPROPRIATE_S" IS '大豆-重度不宜存率';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."FINDINGS_AUDIT" IS '审核结果';
COMMENT ON COLUMN "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT"."AUDIT_OPINIONS" IS '审核意见';

CREATE TABLE "QUALITY"."CCFA" (
"ID" VARCHAR2(36 BYTE) NOT NULL ,
"WTID" VARCHAR2(36 BYTE) NULL ,
"CREATE_BY" VARCHAR2(36 BYTE) NULL ,
"CREATE_TIME" TIMESTAMP(6)  NULL ,
"UPDATE_BY" VARCHAR2(36 BYTE) NULL ,
"UPDATE_TIME" TIMESTAMP(6)  NULL ,
"DELETE_BY" VARCHAR2(36 BYTE) NULL ,
"DELETE_TIME" TIMESTAMP(6)  NULL ,
"FABH" VARCHAR2(36 BYTE) NULL ,
"FABT" VARCHAR2(36 BYTE) NULL ,
"ND" VARCHAR2(36 BYTE) NULL ,
"FQSJ" TIMESTAMP(6)  NULL ,
"JSSJ" TIMESTAMP(6)  NULL ,
"FAXQ" VARCHAR2(500 BYTE) NULL ,
"FJID" VARCHAR2(36 BYTE) NULL ,
"ZT" NUMBER NULL ,
"AREA_CODE" VARCHAR2(36 BYTE) NULL ,
"ORG_ID" VARCHAR2(36 BYTE) NULL ,
"DEPT_ID" VARCHAR2(36 BYTE) NULL 
);
COMMENT ON COLUMN "QUALITY"."CCFA"."CREATE_BY" IS '创建人';
COMMENT ON COLUMN "QUALITY"."CCFA"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "QUALITY"."CCFA"."UPDATE_BY" IS '编辑人';
COMMENT ON COLUMN "QUALITY"."CCFA"."UPDATE_TIME" IS '编辑时间';
COMMENT ON COLUMN "QUALITY"."CCFA"."DELETE_BY" IS '删除人';
COMMENT ON COLUMN "QUALITY"."CCFA"."DELETE_TIME" IS '删除时间';
COMMENT ON COLUMN "QUALITY"."CCFA"."FABH" IS '方案编号';
COMMENT ON COLUMN "QUALITY"."CCFA"."FABT" IS '方案标题';
COMMENT ON COLUMN "QUALITY"."CCFA"."ND" IS '年度';
COMMENT ON COLUMN "QUALITY"."CCFA"."FQSJ" IS '发起时间';
COMMENT ON COLUMN "QUALITY"."CCFA"."JSSJ" IS '结束时间';
COMMENT ON COLUMN "QUALITY"."CCFA"."FAXQ" IS '方案详情';
COMMENT ON COLUMN "QUALITY"."CCFA"."FJID" IS '附件id';
COMMENT ON COLUMN "QUALITY"."CCFA"."ZT" IS '状态';
COMMENT ON COLUMN "QUALITY"."CCFA"."AREA_CODE" IS '行政区划';
COMMENT ON COLUMN "QUALITY"."CCFA"."ORG_ID" IS '机构id';
COMMENT ON COLUMN "QUALITY"."CCFA"."DEPT_ID" IS '部门id';

CREATE TABLE "QUALITY"."CYD" (
"ID" VARCHAR2(36 BYTE) NOT NULL ,
"CYPZID" VARCHAR2(36 BYTE) NULL ,
"XZQHMC" VARCHAR2(36 BYTE) NULL ,
"XZQHBM" VARCHAR2(36 BYTE) NULL ,
"GJCYS" VARCHAR2(36 BYTE) NULL ,
"SJCYS" VARCHAR2(36 BYTE) NULL 
);
COMMENT ON COLUMN "QUALITY"."CYD"."ID" IS 'ID';
COMMENT ON COLUMN "QUALITY"."CYD"."CYPZID" IS '采样品种ID';
COMMENT ON COLUMN "QUALITY"."CYD"."XZQHMC" IS '行政区划名称';
COMMENT ON COLUMN "QUALITY"."CYD"."XZQHBM" IS '行政区划编码';
COMMENT ON COLUMN "QUALITY"."CYD"."GJCYS" IS '国家取样数';
COMMENT ON COLUMN "QUALITY"."CYD"."SJCYS" IS '省级采样数';


CREATE TABLE "QUALITY"."CYJH" (
"ID" VARCHAR2(36 BYTE) NOT NULL ,
"CYFAID" VARCHAR2(36 BYTE) NULL ,
"JHBH" VARCHAR2(36 BYTE) NULL ,
"JHMC" VARCHAR2(36 BYTE) NULL 
);
COMMENT ON COLUMN "QUALITY"."CYJH"."ID" IS 'ID';
COMMENT ON COLUMN "QUALITY"."CYJH"."CYFAID" IS '抽样方案ID';
COMMENT ON COLUMN "QUALITY"."CYJH"."JHBH" IS '计划编号';
COMMENT ON COLUMN "QUALITY"."CYJH"."JHMC" IS '计划名称';

CREATE TABLE "QUALITY"."CYPZ" (
"ID" VARCHAR2(36 BYTE) NOT NULL ,
"CYJHID" VARCHAR2(36 BYTE) NULL ,
"YPJBBM" CHAR(10 BYTE) NULL ,
"YPJBMC" CHAR(10 BYTE) NULL ,
"CYPZLXBM" VARCHAR2(36 BYTE) NULL ,
"CYPZLXMC" VARCHAR2(36 BYTE) NULL ,
"CYPZBM" VARCHAR2(36 BYTE) NULL ,
"CYPZMC" VARCHAR2(96 BYTE) NULL 
);
COMMENT ON COLUMN "QUALITY"."CYPZ"."ID" IS 'ID';
COMMENT ON COLUMN "QUALITY"."CYPZ"."CYJHID" IS '采样计划ID';
COMMENT ON COLUMN "QUALITY"."CYPZ"."YPJBBM" IS '样品级别编码';
COMMENT ON COLUMN "QUALITY"."CYPZ"."YPJBMC" IS '样品级别名称';
COMMENT ON COLUMN "QUALITY"."CYPZ"."CYPZLXBM" IS '采样品种类型编码';
COMMENT ON COLUMN "QUALITY"."CYPZ"."CYPZLXMC" IS '采样品种类型名称';
COMMENT ON COLUMN "QUALITY"."CYPZ"."CYPZBM" IS '采样品种编码';
COMMENT ON COLUMN "QUALITY"."CYPZ"."CYPZMC" IS '采样品种名称';


CREATE TABLE "QUALITY"."QYD" (
"ID" VARCHAR2(36 BYTE) NOT NULL ,
"WTID" VARCHAR2(36 BYTE) NULL ,
"CYDID" VARCHAR2(36 BYTE) NULL ,
"DD" VARCHAR2(96 BYTE) NULL ,
"XXDZ" VARCHAR2(500 BYTE) NULL ,
"LXR" VARCHAR2(96 BYTE) NULL ,
"LXDH" NUMBER NULL ,
"BZ" VARCHAR2(500 BYTE) NULL 
);
COMMENT ON COLUMN "QUALITY"."QYD"."WTID" IS '委托ID';
COMMENT ON COLUMN "QUALITY"."QYD"."CYDID" IS '采样地ID';
COMMENT ON COLUMN "QUALITY"."QYD"."DD" IS '地点';
COMMENT ON COLUMN "QUALITY"."QYD"."XXDZ" IS '详细地址';
COMMENT ON COLUMN "QUALITY"."QYD"."LXR" IS '联系人';
COMMENT ON COLUMN "QUALITY"."QYD"."LXDH" IS '联系电话';
COMMENT ON COLUMN "QUALITY"."QYD"."BZ" IS '备注';

CREATE TABLE "QUALITY"."WT" (
"ID" VARCHAR2(36 BYTE) NOT NULL ,
"CREATE_BY" VARCHAR2(36 BYTE) NULL ,
"CREATE_TIME" TIMESTAMP(6)  NULL ,
"UPDATE_BY" VARCHAR2(36 BYTE) NULL ,
"UPDATE_TIME" TIMESTAMP(6)  NULL ,
"DELETE_BY" VARCHAR2(36 BYTE) NULL ,
"DELETE_TIME" TIMESTAMP(6)  NULL ,
"WTBH" VARCHAR2(36 BYTE) NULL ,
"WTBT" VARCHAR2(36 BYTE) NULL ,
"ZJBH" VARCHAR2(36 BYTE) NULL ,
"WTLXBM" VARCHAR2(36 BYTE) NULL ,
"WTLX" VARCHAR2(36 BYTE) NULL ,
"ND" VARCHAR2(36 BYTE) NULL ,
"WTR" VARCHAR2(36 BYTE) NULL ,
"WTSJ" TIMESTAMP(6)  NULL ,
"FQSJ" TIMESTAMP(6)  NULL ,
"JSSJ" TIMESTAMP(6)  NULL ,
"CCDW" VARCHAR2(96 BYTE) NULL ,
"WTNR" VARCHAR2(500 BYTE) NULL ,
"FJID" VARCHAR2(36 BYTE) NULL ,
"LCID" VARCHAR2(36 BYTE) NULL ,
"AREA_CODE" VARCHAR2(36 BYTE) NULL ,
"ORG_ID" VARCHAR2(36 BYTE) NULL ,
"DEPT_ID" VARCHAR2(36 BYTE) NULL 
);
COMMENT ON COLUMN "QUALITY"."WT"."ID" IS 'ID';
COMMENT ON COLUMN "QUALITY"."WT"."CREATE_BY" IS '创建人';
COMMENT ON COLUMN "QUALITY"."WT"."CREATE_TIME" IS '创建时间';
COMMENT ON COLUMN "QUALITY"."WT"."UPDATE_BY" IS '编辑人';
COMMENT ON COLUMN "QUALITY"."WT"."UPDATE_TIME" IS '编辑时间';
COMMENT ON COLUMN "QUALITY"."WT"."DELETE_BY" IS '删除人';
COMMENT ON COLUMN "QUALITY"."WT"."DELETE_TIME" IS '删除时间';
COMMENT ON COLUMN "QUALITY"."WT"."WTBH" IS '委托编号';
COMMENT ON COLUMN "QUALITY"."WT"."WTBT" IS '委托标题';
COMMENT ON COLUMN "QUALITY"."WT"."ZJBH" IS '质检编号';
COMMENT ON COLUMN "QUALITY"."WT"."WTLXBM" IS '委托类型编码';
COMMENT ON COLUMN "QUALITY"."WT"."WTLX" IS '委托类型';
COMMENT ON COLUMN "QUALITY"."WT"."ND" IS '年度';
COMMENT ON COLUMN "QUALITY"."WT"."WTR" IS '委托人';
COMMENT ON COLUMN "QUALITY"."WT"."WTSJ" IS '委托时间';
COMMENT ON COLUMN "QUALITY"."WT"."FQSJ" IS '发起时间';
COMMENT ON COLUMN "QUALITY"."WT"."JSSJ" IS '结束时间';
COMMENT ON COLUMN "QUALITY"."WT"."CCDW" IS '承储单位';
COMMENT ON COLUMN "QUALITY"."WT"."WTNR" IS '委托内容';
COMMENT ON COLUMN "QUALITY"."WT"."FJID" IS '附件Id';
COMMENT ON COLUMN "QUALITY"."WT"."LCID" IS '流程ID';
ALTER TABLE "QUALITY"."BIZ_ORGANIZATION" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "QUALITY"."BIZ_EQUIPMENT" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "QUALITY"."BIZ_PERSONNEL_MANAGEMENT" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "QUALITY"."BIZ_TEST_PARAMETERS" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "QUALITY"."BIZ_QUALITY_PREDICTION_PLANNED" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "QUALITY"."BIZ_QUALITY_PREDICTION_AUDIT" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "QUALITY"."BIZ_QUALITY_PREDICTION_ITEMS" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "QUALITY"."BIZ_FOOD_STOCK" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "QUALITY"."BIZ_FOOD_STOCK_ITEMS" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "QUALITY"."BIZ_FOOD_STOCK_ITEMS" ADD CHECK ("FOOD_STOCK_ID" IS NOT NULL);
ALTER TABLE "QUALITY"."BIZ_GRADE_TEST_RESULTS" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "QUALITY"."BIZ_GRADE_TEST_RESULTS" ADD CHECK ("FOOD_STOCK_ID" IS NOT NULL);
ALTER TABLE "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "QUALITY"."BIZ_SUMMARY_RESULTS" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "QUALITY"."BIZ_SUMMARY_SUBSTANDARD_SAMPLE" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "QUALITY"."BIZ_SUMMARY_NOT_SUITABLE" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "QUALITY"."BIZ_SUMMARY_INSPECTION_RESULT" ADD CHECK ("PLAN_FILE_NAME" IS NOT NULL);
ALTER TABLE "QUALITY"."CCFA" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "QUALITY"."CYD" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "QUALITY"."CYJH" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "QUALITY"."CYPZ" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "QUALITY"."QYD" ADD CHECK ("ID" IS NOT NULL);
ALTER TABLE "QUALITY"."WT" ADD CHECK ("ID" IS NOT NULL);


ALTER TABLE "QUALITY"."BIZ_FOOD_STOCK" ADD PRIMARY KEY ("ID");
ALTER TABLE "QUALITY"."BIZ_FOOD_STOCK_ITEMS" ADD PRIMARY KEY ("ID");
ALTER TABLE "QUALITY"."BIZ_GRADE_TEST_RESULTS" ADD PRIMARY KEY ("ID");
ALTER TABLE "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS" ADD PRIMARY KEY ("ID");
ALTER TABLE "QUALITY"."BIZ_SUMMARY_RESULTS" ADD PRIMARY KEY ("ID");
ALTER TABLE "QUALITY"."BIZ_SUMMARY_RESULTS_ITEMS" ADD PRIMARY KEY ("ID");
ALTER TABLE "QUALITY"."BIZ_SUMMARY_SUBSTANDARD_SAMPLE" ADD PRIMARY KEY ("ID");
ALTER TABLE "QUALITY"."CCFA" ADD PRIMARY KEY ("ID");
ALTER TABLE "QUALITY"."CYD" ADD PRIMARY KEY ("ID");
ALTER TABLE "QUALITY"."CYJH" ADD PRIMARY KEY ("ID");
ALTER TABLE "QUALITY"."CYPZ" ADD PRIMARY KEY ("ID");
ALTER TABLE "QUALITY"."QYD" ADD PRIMARY KEY ("ID");
ALTER TABLE "QUALITY"."WT" ADD PRIMARY KEY ("ID");

ALTER TABLE "QUALITY"."BIZ_FOOD_STOCK_ITEMS" ADD FOREIGN KEY ("FOOD_STOCK_ID") REFERENCES "QUALITY"."BIZ_FOOD_STOCK" ("ID") DISABLE;
ALTER TABLE "QUALITY"."BIZ_GRADE_TEST_RESULTS" ADD FOREIGN KEY ("FOOD_STOCK_ID") REFERENCES "QUALITY"."BIZ_FOOD_STOCK" ("ID") DISABLE;
ALTER TABLE "QUALITY"."BIZ_GRADE_TEST_RESULTS_ITEMS" ADD FOREIGN KEY ("GRADE_TEST_RESULTS_ID") REFERENCES "QUALITY"."BIZ_GRADE_TEST_RESULTS" ("ID") DISABLE;
ALTER TABLE "QUALITY"."CCFA" ADD FOREIGN KEY ("WTID") REFERENCES "QUALITY"."WT" ("ID");
ALTER TABLE "QUALITY"."CYD" ADD FOREIGN KEY ("CYPZID") REFERENCES "QUALITY"."CYPZ" ("ID");
ALTER TABLE "QUALITY"."CYJH" ADD FOREIGN KEY ("CYFAID") REFERENCES "QUALITY"."CCFA" ("ID");
ALTER TABLE "QUALITY"."CYPZ" ADD FOREIGN KEY ("CYJHID") REFERENCES "QUALITY"."CYJH" ("ID");
ALTER TABLE "QUALITY"."QYD" ADD FOREIGN KEY ("CYDID") REFERENCES "QUALITY"."CYD" ("ID");
ALTER TABLE "QUALITY"."QYD" ADD FOREIGN KEY ("WTID") REFERENCES "QUALITY"."WT" ("ID");


--扦样地表结构
alter table QYD add (ORG_ID VARCHAR2(36) null);
alter table QYD add (DEPT_ID VARCHAR2(36) null);
alter table QYD add (AREA_CODE VARCHAR2(36) null);
alter table QYD add (CREATE_BY VARCHAR2(36) null);
alter table QYD add (CREATE_TIME TIMESTAMP);
alter table QYD add (UPDATE_BY VARCHAR2(36) null);
alter table QYD add (UPDATE_TIME TIMESTAMP);
alter table QYD add (DELETE_BY VARCHAR2(36) null);
alter table QYD add (DELETE_TIME TIMESTAMP);

comment on column QYD.ORG_ID is '组织机构id';
comment on column QYD.DEPT_ID is '部门ID';
comment on column QYD.AREA_CODE is '行政区划code';
comment on column QYD.CREATE_BY is '创建人';
comment on column QYD.CREATE_TIME is '创建时间';
comment on column QYD.UPDATE_BY is '修改人';
comment on column QYD.UPDATE_TIME is '修改时间';
comment on column QYD.DELETE_BY is '删除人';
comment on column QYD.DELETE_TIME is '删除时间';

--抽查方案表结构
alter table CCFA add (FJMC VARCHAR2(200) null); 
alter table CCFA add (WTLX VARCHAR2(50) null); 
comment on column CCFA.FJMC is '附件名称';
comment on column CCFA.WTLX is '委托类型';

--采样品种字段类型长度修改
alter table CYPZ modify (YPJBBM VARCHAR2(36));
alter table CYPZ modify (YPJBMC VARCHAR2(36));

--机构基本信息表
alter table BIZ_ORGANIZATION add ( INSTITUTIONAL VARCHAR2(36) null);
alter table BIZ_ORGANIZATION add ( UNIT VARCHAR2(50) null);
alter table BIZ_ORGANIZATION add ( FUND_SOURCES VARCHAR2(50) null);
alter table BIZ_ORGANIZATION add ( LINK_MAN VARCHAR2(50) null);
alter table BIZ_ORGANIZATION add ( CONTACT_INFORMATION VARCHAR2(50) null);
alter table BIZ_ORGANIZATION add ( UNIT_ADDRESS VARCHAR2(200) null);
alter table BIZ_ORGANIZATION add ( REMIT VARCHAR2(200) null);

comment on column BIZ_ORGANIZATION.INSTITUTIONAL is '机构性质--天津';
comment on column BIZ_ORGANIZATION.UNIT is '所属单位--天津';
comment on column BIZ_ORGANIZATION.FUND_SOURCES is '经费来源--天津';
comment on column BIZ_ORGANIZATION.LINK_MAN is '联系人--天津';
comment on column BIZ_ORGANIZATION.CONTACT_INFORMATION is '联系方式--天津';
comment on column BIZ_ORGANIZATION.UNIT_ADDRESS is '单位地址--天津';
comment on column BIZ_ORGANIZATION.REMIT is '职责权限--天津';

--人员基本信息
alter table BIZ_PERSONNEL_MANAGEMENT add ( NATION VARCHAR2(36) null);
alter table BIZ_PERSONNEL_MANAGEMENT add ( UNIT VARCHAR2(200) null);
alter table BIZ_PERSONNEL_MANAGEMENT add ( BIRTHDAY VARCHAR2(36) null);
alter table BIZ_PERSONNEL_MANAGEMENT add ( ID_CARD VARCHAR2(36) null);
alter table BIZ_PERSONNEL_MANAGEMENT add ( VOCATIONAL_GRADE VARCHAR2(36) null);

comment on column BIZ_PERSONNEL_MANAGEMENT.NATION is '民族--天津';
comment on column BIZ_PERSONNEL_MANAGEMENT.UNIT is '工作单位--天津';
comment on column BIZ_PERSONNEL_MANAGEMENT.BIRTHDAY is '出生年月--天津';
comment on column BIZ_PERSONNEL_MANAGEMENT.ID_CARD is '身份证号码--天津';
comment on column BIZ_PERSONNEL_MANAGEMENT.VOCATIONAL_GRADE is '职业等级--天津';


--机构设备管理
alter table BIZ_EQUIPMENT add ( UNIT VARCHAR2(50) null);
alter table BIZ_EQUIPMENT add ( DOMESTIC_IMPORT VARCHAR2(36) null);
alter table BIZ_EQUIPMENT add ( MODEL VARCHAR2(36) null);
alter table BIZ_EQUIPMENT add ( VALUE VARCHAR2(36) null);
alter table BIZ_EQUIPMENT add ( FACTORY_CODE VARCHAR2(50) null);
alter table BIZ_EQUIPMENT add ( ENABLE_DATE TIMESTAMP null);
alter table BIZ_EQUIPMENT add ( RECEIPT_DATE TIMESTAMP null);
alter table BIZ_EQUIPMENT add ( RECEIVING_STATE VARCHAR2(36) null);
alter table BIZ_EQUIPMENT add ( PLACE_POINT VARCHAR2(100) null);
alter table BIZ_EQUIPMENT add ( WHETHER_CERTIFY VARCHAR2(36) null);
alter table BIZ_EQUIPMENT add ( SOFTWARE_NAME VARCHAR2(200) null);
alter table BIZ_EQUIPMENT add ( TECHNICAL_PARAMETER VARCHAR2(200) null);

comment on column BIZ_EQUIPMENT.UNIT is '所在单位--天津';
comment on column BIZ_EQUIPMENT.DOMESTIC_IMPORT is '国产/进口--天津';
comment on column BIZ_EQUIPMENT.MODEL is '型号--天津';
comment on column BIZ_EQUIPMENT.VALUE is '价值--天津';
comment on column BIZ_EQUIPMENT.FACTORY_CODE is '出厂编码--天津';
comment on column BIZ_EQUIPMENT.ENABLE_DATE is '启用日期--天津';
comment on column BIZ_EQUIPMENT.RECEIPT_DATE is '收获日期--天津';
comment on column BIZ_EQUIPMENT.RECEIVING_STATE is '接收状态--天津';
comment on column BIZ_EQUIPMENT.PLACE_POINT is '放置点--天津';
comment on column BIZ_EQUIPMENT.WHETHER_CERTIFY is '是否造册--天津';
comment on column BIZ_EQUIPMENT.SOFTWARE_NAME is '软件名称--天津';
comment on column BIZ_EQUIPMENT.TECHNICAL_PARAMETER is '技术参数--天津';