-- Start of DDL Script for Table SD_MZ.YS_CRBDJ0 -- Generated 31-五月-2021 17:07:51 from SD_MZ@KFHIS5 CREATE TABLE ys_crbdj0 (djid00 NUMBER(10,0) NOT NULL, mzid00 NUMBER(10,0) NOT NULL, hzxm00 VARCHAR2(40) NOT NULL, brxb00 VARCHAR2(8) NOT NULL, brcsrq CHAR(8) NOT NULL, sfzh00 VARCHAR2(20), tydwmc VARCHAR2(200), brlxdh VARCHAR2(30), dzsf00 VARCHAR2(40), dzdjs0 VARCHAR2(40), dzxq00 VARCHAR2(40), dzxzjd VARCHAR2(40), dzc000 VARCHAR2(40), dzmph0 VARCHAR2(40), brlxdz VARCHAR2(200), brzy00 VARCHAR2(30), hejzxm VARCHAR2(40), brls00 VARCHAR2(30) NOT NULL, fbrq00 CHAR(8) NOT NULL, zdrq00 CHAR(8) NOT NULL, zdsj00 CHAR(8), swrq00 CHAR(8), blfl01 VARCHAR2(30) NOT NULL, blfl02 VARCHAR2(50) NOT NULL, tkys00 NUMBER(5,0), tkrq00 CHAR(8) NOT NULL, jbmc00 VARCHAR2(100) NOT NULL, jczcr0 CHAR(1) NOT NULL, bz0000 VARCHAR2(200), czy000 NUMBER(5,0) NOT NULL, czrq00 CHAR(8) NOT NULL, czsj00 CHAR(8) NOT NULL, hy0000 VARCHAR2(20), whcd00 VARCHAR2(20), crly00 VARCHAR2(20), sfsw00 CHAR(1) DEFAULT 'N', sfqr00 CHAR(1) DEFAULT 'N', zdxxid NUMBER(12,0), jlcrb0 VARCHAR2(30), ylcrb0 VARCHAR2(30), blcrb0 VARCHAR2(100), crb001 VARCHAR2(2), crb002 VARCHAR2(2), crb003 VARCHAR2(2), crb004 VARCHAR2(2), crb005 VARCHAR2(2), crb006 VARCHAR2(2), crb007 VARCHAR2(2), crb008 VARCHAR2(2), crb009 VARCHAR2(2), crb010 VARCHAR2(2), crb011 VARCHAR2(2), crb012 VARCHAR2(2), crb013 VARCHAR2(2), crb014 VARCHAR2(2), crb015 VARCHAR2(2), crb016 VARCHAR2(2), crb017 VARCHAR2(2), crb018 VARCHAR2(2), crb019 VARCHAR2(2), crb020 VARCHAR2(2), crb021 VARCHAR2(2), crb022 VARCHAR2(2), crb023 VARCHAR2(2), crb024 VARCHAR2(2), crb025 VARCHAR2(2), crb026 VARCHAR2(2), crb027 VARCHAR2(2), crb028 VARCHAR2(2), crb029 VARCHAR2(2), crb030 VARCHAR2(2), crb031 VARCHAR2(2), crb032 VARCHAR2(2), crb033 VARCHAR2(2), crb034 VARCHAR2(2), crb035 VARCHAR2(2), crb036 VARCHAR2(2), crb037 VARCHAR2(2), crb038 VARCHAR2(2), crb039 VARCHAR2(2), crb040 VARCHAR2(2), crb041 VARCHAR2(2), crb042 VARCHAR2(2), crb043 VARCHAR2(2), crb044 VARCHAR2(2), crb045 VARCHAR2(2), crb046 VARCHAR2(2), crb047 VARCHAR2(2), crb048 VARCHAR2(2), crb049 VARCHAR2(2), crb050 VARCHAR2(2), crb051 VARCHAR2(2), crb052 VARCHAR2(2), crb053 VARCHAR2(2), crb054 VARCHAR2(2), crb055 VARCHAR2(2), crb056 VARCHAR2(2), crb057 VARCHAR2(2), crb058 VARCHAR2(2), crb059 VARCHAR2(2), crb060 VARCHAR2(2), kpbh00 CHAR(16), kplx00 CHAR(20), qtcrb0 VARCHAR2(100), dzjbmc VARCHAR2(220), tkyy00 VARCHAR2(50), dzszc0 VARCHAR2(20), tksj00 CHAR(8), zdyj00 VARCHAR2(40), crb061 VARCHAR2(2), crb062 VARCHAR2(2), crb063 VARCHAR2(2), brid00 NUMBER(10,0), qrr000 NUMBER(5,0), crb064 VARCHAR2(2), crb076 VARCHAR2(2), crb077 VARCHAR2(2), crb078 VARCHAR2(2), crb079 VARCHAR2(2), crb080 VARCHAR2(2), crb081 VARCHAR2(2), crb082 VARCHAR2(2), crb083 VARCHAR2(2), crb075 VARCHAR2(2), crb074 VARCHAR2(2), crb073 VARCHAR2(2), brsznl VARCHAR2(3), crb065 VARCHAR2(2), crb066 VARCHAR2(2), crb067 VARCHAR2(2), crb068 VARCHAR2(2), crb069 VARCHAR2(2), crb070 VARCHAR2(2), crb071 VARCHAR2(2), crb072 VARCHAR2(2), dycs00 NUMBER(5,0) DEFAULT 0, bgrq00 VARCHAR2(8), bgbz00 VARCHAR2(1) DEFAULT '0', brlb00 CHAR(1) DEFAULT '0', yjdjks NUMBER(5,0), bgdwmc VARCHAR2(60), bgdwdh VARCHAR2(30), crb084 VARCHAR2(2), crb085 VARCHAR2(2), crb086 VARCHAR2(2), crb087 VARCHAR2(2), crb088 VARCHAR2(2), crb089 VARCHAR2(2), crb090 VARCHAR2(2), crb091 VARCHAR2(2), crb092 VARCHAR2(2), crb093 VARCHAR2(2) / -- Comments for YS_CRBDJ0 COMMENT ON COLUMN ys_crbdj0.bgbz00 IS '报告标志' / COMMENT ON COLUMN ys_crbdj0.bgdwdh IS '报告单位电话' / COMMENT ON COLUMN ys_crbdj0.bgdwmc IS '报告单位' / COMMENT ON COLUMN ys_crbdj0.bgrq00 IS '报告日期' / COMMENT ON COLUMN ys_crbdj0.blcrb0 IS '丙类传染病' / COMMENT ON COLUMN ys_crbdj0.blfl01 IS '病例分类01' / COMMENT ON COLUMN ys_crbdj0.blfl02 IS '病例分类02' / COMMENT ON COLUMN ys_crbdj0.brcsrq IS '病人出生日期' / COMMENT ON COLUMN ys_crbdj0.brlb00 IS '0为挂号病人,1为未挂号病人,2为未建档的无卡病人' / COMMENT ON COLUMN ys_crbdj0.brls00 IS '病人隶属： --本县区 本市其它县区 本省其它地市 其他省 港澳台 外籍' / COMMENT ON COLUMN ys_crbdj0.brlxdh IS '病人联系电话' / COMMENT ON COLUMN ys_crbdj0.brlxdz IS '联系人地址' / COMMENT ON COLUMN ys_crbdj0.brsznl IS '实足年龄' / COMMENT ON COLUMN ys_crbdj0.brxb00 IS '病人性别' / COMMENT ON COLUMN ys_crbdj0.brzy00 IS '病人职业' / COMMENT ON COLUMN ys_crbdj0.bz0000 IS '备注' / COMMENT ON COLUMN ys_crbdj0.crb001 IS '鼠疫、 打钩=‘-1’ 没有‘0’ 以下同' / COMMENT ON COLUMN ys_crbdj0.crb002 IS '霍乱' / COMMENT ON COLUMN ys_crbdj0.crb003 IS '传染性非典型肺炎、' / COMMENT ON COLUMN ys_crbdj0.crb004 IS '艾滋病、' / COMMENT ON COLUMN ys_crbdj0.crb005 IS '病毒性肝炎' / COMMENT ON COLUMN ys_crbdj0.crb006 IS '甲型、' / COMMENT ON COLUMN ys_crbdj0.crb007 IS '乙型、' / COMMENT ON COLUMN ys_crbdj0.crb008 IS '丙型、' / COMMENT ON COLUMN ys_crbdj0.crb009 IS '戊型' / COMMENT ON COLUMN ys_crbdj0.crb010 IS '未分型' / COMMENT ON COLUMN ys_crbdj0.crb011 IS '脊髓灰质炎、' / COMMENT ON COLUMN ys_crbdj0.crb012 IS '人感染高致病性禽流感' / COMMENT ON COLUMN ys_crbdj0.crb013 IS '麻疹、' / COMMENT ON COLUMN ys_crbdj0.crb014 IS '流行性出血热、' / COMMENT ON COLUMN ys_crbdj0.crb015 IS '狂犬病、' / COMMENT ON COLUMN ys_crbdj0.crb016 IS '流行性乙型脑炎、' / COMMENT ON COLUMN ys_crbdj0.crb017 IS '登革热、' / COMMENT ON COLUMN ys_crbdj0.crb018 IS '炭疽' / COMMENT ON COLUMN ys_crbdj0.crb019 IS '肺炭疽、' / COMMENT ON COLUMN ys_crbdj0.crb020 IS '皮肤炭疽、' / COMMENT ON COLUMN ys_crbdj0.crb021 IS '未分型' / COMMENT ON COLUMN ys_crbdj0.crb022 IS '痢疾' / COMMENT ON COLUMN ys_crbdj0.crb023 IS '细菌性、' / COMMENT ON COLUMN ys_crbdj0.crb024 IS '阿米巴型' / COMMENT ON COLUMN ys_crbdj0.crb025 IS '肺结核' / COMMENT ON COLUMN ys_crbdj0.crb026 IS '涂阳、' / COMMENT ON COLUMN ys_crbdj0.crb027 IS '仅培阳' / COMMENT ON COLUMN ys_crbdj0.crb028 IS '菌阴、' / COMMENT ON COLUMN ys_crbdj0.crb029 IS '未痰检' / COMMENT ON COLUMN ys_crbdj0.crb030 IS '伤寒' / COMMENT ON COLUMN ys_crbdj0.crb031 IS '伤寒、' / COMMENT ON COLUMN ys_crbdj0.crb032 IS '副伤寒' / COMMENT ON COLUMN ys_crbdj0.crb033 IS '流行性脊髓膜火、' / COMMENT ON COLUMN ys_crbdj0.crb034 IS '百日咳、' / COMMENT ON COLUMN ys_crbdj0.crb035 IS '白喉、' / COMMENT ON COLUMN ys_crbdj0.crb036 IS '新生儿破伤风、' / COMMENT ON COLUMN ys_crbdj0.crb037 IS '猩红热、' / COMMENT ON COLUMN ys_crbdj0.crb038 IS '布鲁氏菌病、' / COMMENT ON COLUMN ys_crbdj0.crb039 IS '淋病、梅毒' / COMMENT ON COLUMN ys_crbdj0.crb040 IS 'I期、' / COMMENT ON COLUMN ys_crbdj0.crb041 IS 'II期、' / COMMENT ON COLUMN ys_crbdj0.crb042 IS 'III型、' / COMMENT ON COLUMN ys_crbdj0.crb043 IS '胎传、' / COMMENT ON COLUMN ys_crbdj0.crb044 IS '隐性' / COMMENT ON COLUMN ys_crbdj0.crb045 IS '钩端螺旋体病、' / COMMENT ON COLUMN ys_crbdj0.crb046 IS '血吸虫病、' / COMMENT ON COLUMN ys_crbdj0.crb047 IS '疟疾' / COMMENT ON COLUMN ys_crbdj0.crb048 IS '间日虐、' / COMMENT ON COLUMN ys_crbdj0.crb049 IS '恶性虐、' / COMMENT ON COLUMN ys_crbdj0.crb050 IS '未分型' / COMMENT ON COLUMN ys_crbdj0.crb051 IS '流行性感冒、' / COMMENT ON COLUMN ys_crbdj0.crb052 IS '流行性腮腺炎、' / COMMENT ON COLUMN ys_crbdj0.crb053 IS '风疹、' / COMMENT ON COLUMN ys_crbdj0.crb054 IS '急性初学性结膜炎、' / COMMENT ON COLUMN ys_crbdj0.crb055 IS '麻风病、' / COMMENT ON COLUMN ys_crbdj0.crb056 IS '流行性和地方性斑疹伤寒、' / COMMENT ON COLUMN ys_crbdj0.crb057 IS '黑热病、' / COMMENT ON COLUMN ys_crbdj0.crb058 IS '包虫病、' / COMMENT ON COLUMN ys_crbdj0.crb059 IS '丝虫病、' / COMMENT ON COLUMN ys_crbdj0.crb060 IS '除霍乱、细菌性和阿米巴性痢疾、伤寒和副伤寒意外的感染性腹泻病、' / COMMENT ON COLUMN ys_crbdj0.crb061 IS '甲H1N1' / COMMENT ON COLUMN ys_crbdj0.crb062 IS '手足病' / COMMENT ON COLUMN ys_crbdj0.crb063 IS 'HIV' / COMMENT ON COLUMN ys_crbdj0.crb064 IS '梅毒' / COMMENT ON COLUMN ys_crbdj0.crb065 IS '尖锐湿疣' / COMMENT ON COLUMN ys_crbdj0.crb066 IS '生殖器疱疹' / COMMENT ON COLUMN ys_crbdj0.crb067 IS '水痘' / COMMENT ON COLUMN ys_crbdj0.crb068 IS '肝吸虫病' / COMMENT ON COLUMN ys_crbdj0.crb069 IS '生殖道沙眼衣原体感染' / COMMENT ON COLUMN ys_crbdj0.crb070 IS '结核性胸膜炎' / COMMENT ON COLUMN ys_crbdj0.crb071 IS '人感染猪链球菌' / COMMENT ON COLUMN ys_crbdj0.crb072 IS '不明原因肺炎' / COMMENT ON COLUMN ys_crbdj0.crb073 IS '实足年龄单位(年)' / COMMENT ON COLUMN ys_crbdj0.crb074 IS '实足年龄单位(月)' / COMMENT ON COLUMN ys_crbdj0.crb075 IS '实足年龄单位(天)' / COMMENT ON COLUMN ys_crbdj0.crb084 IS '艾滋病(AIDS)' / COMMENT ON COLUMN ys_crbdj0.crb085 IS '人感染H7N9禽流感' / COMMENT ON COLUMN ys_crbdj0.crb086 IS 'AFP疾病:1是,0不是' / COMMENT ON COLUMN ys_crbdj0.crb087 IS '是否利福平耐药' / COMMENT ON COLUMN ys_crbdj0.crb088 IS '病毒性肝炎丁型' / COMMENT ON COLUMN ys_crbdj0.crb089 IS '埃博拉出血热' / COMMENT ON COLUMN ys_crbdj0.crb090 IS '肠出血性大肠杆菌感染性腹泻' / COMMENT ON COLUMN ys_crbdj0.crb091 IS '中东呼吸综合征（MERS）' / COMMENT ON COLUMN ys_crbdj0.crb092 IS '寨卡病毒病' / COMMENT ON COLUMN ys_crbdj0.crb093 IS '是否新型冠状病毒感染肺炎,0否，-1是' / COMMENT ON COLUMN ys_crbdj0.crly00 IS '传染来源' / COMMENT ON COLUMN ys_crbdj0.czrq00 IS '操作日期' / COMMENT ON COLUMN ys_crbdj0.czsj00 IS '操作时间' / COMMENT ON COLUMN ys_crbdj0.czy000 IS '操作员' / COMMENT ON COLUMN ys_crbdj0.djid00 IS '登记ID' / COMMENT ON COLUMN ys_crbdj0.dzc000 IS '地址村' / COMMENT ON COLUMN ys_crbdj0.dzdjs0 IS '地址地级市' / COMMENT ON COLUMN ys_crbdj0.dzjbmc IS '订正疾病名称' / COMMENT ON COLUMN ys_crbdj0.dzmph0 IS '地址门牌号' / COMMENT ON COLUMN ys_crbdj0.dzsf00 IS '地址省份' / COMMENT ON COLUMN ys_crbdj0.dzszc0 IS '村' / COMMENT ON COLUMN ys_crbdj0.dzxq00 IS '地址县区' / COMMENT ON COLUMN ys_crbdj0.dzxzjd IS '地址乡镇街道' / COMMENT ON COLUMN ys_crbdj0.fbrq00 IS '发病日期' / COMMENT ON COLUMN ys_crbdj0.hejzxm IS '患儿家长姓名' / COMMENT ON COLUMN ys_crbdj0.hy0000 IS '婚姻' / COMMENT ON COLUMN ys_crbdj0.hzxm00 IS '患者姓名' / COMMENT ON COLUMN ys_crbdj0.jbmc00 IS '疾病名称' / COMMENT ON COLUMN ys_crbdj0.jczcr0 IS '密切接触者有无相同症状 0:无 1：有' / COMMENT ON COLUMN ys_crbdj0.jlcrb0 IS '甲类传染病' / COMMENT ON COLUMN ys_crbdj0.kpbh00 IS '卡片编号' / COMMENT ON COLUMN ys_crbdj0.kplx00 IS '卡片类型：1-初步报告 2-订正报告' / COMMENT ON COLUMN ys_crbdj0.mzid00 IS '门诊病人信息流水号(YS_CFXXB0.GHID00)' / COMMENT ON COLUMN ys_crbdj0.qtcrb0 IS '其他传染病' / COMMENT ON COLUMN ys_crbdj0.sfqr00 IS 'Y已确认 N未确认' / COMMENT ON COLUMN ys_crbdj0.sfzh00 IS '身份证号' / COMMENT ON COLUMN ys_crbdj0.swrq00 IS '死亡日期' / COMMENT ON COLUMN ys_crbdj0.tkrq00 IS '填卡日期' / COMMENT ON COLUMN ys_crbdj0.tkys00 IS '填卡医生' / COMMENT ON COLUMN ys_crbdj0.tkyy00 IS '退卡原因' / COMMENT ON COLUMN ys_crbdj0.tydwmc IS '单位名称' / COMMENT ON COLUMN ys_crbdj0.whcd00 IS '文化程度' / COMMENT ON COLUMN ys_crbdj0.yjdjks IS '一键登记病人传染病登记科室' / COMMENT ON COLUMN ys_crbdj0.ylcrb0 IS '乙类类传染病' / COMMENT ON COLUMN ys_crbdj0.zdrq00 IS '诊断日期' / COMMENT ON COLUMN ys_crbdj0.zdsj00 IS '诊断时间' / -- End of DDL Script for Table SD_MZ.YS_CRBDJ0