DLS表设计20230905323专病精神卫生防治系统.docx

1.严重精神障碍报告卡表(patient_report_card_info)D1S_01_49_PATIENT_REPORT_CARD_INFO_DAY数据元信息主键字段id业务主键report_card_code是否会硬删除否数据总量IoOo条日增量200熠量时间戳字段cdt更新频次每天更新数据时间范围最近3个月数据更新时间截字段mdt外键信息外键字段名report_card_code关联表名称patient_out_hospita1_info关联表字段report_card_code外健字段名report_card_code关联表名称patient_circu1ation关联字段report_card_code外键字段名patient_code关联表名称patient_basic_info关®字段patient_code湖内信息(采集方填写)更新模式增量更新入湖频率每日一次是否是拉链表是分区信息按年分区建表语句/*=v*Tab1e:"patient_report_card_info"*/*=*/createtab1e'patient_report_card_info"("id"NMBER(6)notnu11,"patient_COde"VARCHAR2(32)f"report_card_codenVARCHAR2(32),"patient_origin"VARCHAR2(4),"patient_name"VARCHAR2(50)f"patient_gender"VARCHAR2(4),"patient_birthday"DATE"id_card_type"VARCHAR2(4),"id_card"VARCHAR2(32),"nation.COde”VARCHAR2(4),"contacts"VARCHAR2(50),"contacts-te1'VARCHAR2(16),"contacts_tes_two"VARCHAR2(16),"contacts_re1_codeBVARCHAR2(4),defau1tNU11,"current_addr_type_code"VARCHAR2(4),"current_addr_code"VARCHAR2(64),Hcurrent_addr_detai1'VARCHAR2(255),"patient_addr_type_codeeVARCHAR2(4),"psychogeny_permanent_addr_code"VARCHAR2(4),npermanen1addr-code''VARCHAR2(64),"permanent_addr_detairVARCHAR2(255),"permanent_addr_type_code-VARCHAR2(4),education-codenVARCHAR2(4),marita1status-codeVARCHAR2(4)1"profession-code'VARCHAR2(4),"fami1y_history"VARCHAR2(4),"onset_date"DATEdefau1tNU11,"signs_medication_code"VARCHAR2(4),"psychogenyfirstcuredate"DATEdefau1tNU11,"psychogeny_first_cure_date_accuracy_code'VARCHAR2(4),"onset_date_accuracy_code"VARCHAR2(4),"psychogeny_past_hospita1BINTEGERdefau1tNU11,"psychogeny_shut_status_history_code"VARCHAR2(4),"psychogeny_past_risk_code"VARCHAR2(4)f"diagnose_org"VARCHAR2(50),"diagnosejime"DATEdefau1tNU11,"disease_diagnosis"VARCHAR2(50),"disease.COde"VARCHAR2(16),"disease_name"VARCHAR2(128),"drug.state"VARCHAR2(4),"informed_consenfVARCHAR2(4),"informed_consent_date"DATEdefau1tNU11,"recorder_code"VARCHAR2(255),"record_doctor"VARCHAR2(50),"record.date"DATEnotnu11,"report_district"VARCHAR2(255)f"report_org"VARCHAR2(255),"report_org_code'VARCHAR2(255),"report_org_phoneBVARCHAR2(64),"have-out-hospitaVARCHAR2(2),"dr"Sma11intdefau1t1,"cdt"DATE,"mdt"DATE,constraintPK_PATIENT_REPORT_CARDNFoprimarykey("id")commentonco1umn"patient_report_cardJnfoM,"patient_birthday"is患者出生日期commentonco1umn"patient_report_cardJnfoM,"onset_date"is'初次发病日期commentonco1umn"patient-report-cardjnfon.,psychogenyirst-cure-date"is首次抗精神科药物治疗时间/commentonco1umn"patient_report_cardjnfo","psychogeny_past_hospitaris既往住院次数/commentonco1umn"patient_report_card_info"."diagnose_time"is确认日期/commentonco1umn"patien1report-cardJnfo","informed-consent-date'is患者知情同意时间commentonco1umn"patient_report_cardjnfo","record_date"is填表日期commentonco1umn"patient_report_card_info"."dr"is删除标识代码:1：数据正常；0:数据已被逻辑删除；2:待审核自定义标识符（必填项）名称（必填）数据类型（必填）数据长度（必填）字典（按需填写）填报要求（必填）说明id主键it(11)必填项数据集的主键patient_code患者的唯一业务codevarchar(32)32必填项患者的唯一业务codereport_card_code患者报告卡的唯一业务编号varchar(32)32必填项患者报告卡的唯一业务编号patient_origin患者来源codevarchar(4)4T:门诊“2”：住院必填项患者来源codepatient_name患者的姓名varchar(16)16必填项患者的姓名patient_gender患者的性别varchar(4)4GB/T2261.1-2003必填项患者的性别patient_birthday患者出生日期date可选患者出生日期id_card_type患者证件类型varchar(4)4CV02.01.101必填项患者证件类型codeid_card患者的证件号varchar(32)32必填项患者的证件号nation_code患者的民族codevarchar(4)4GB3304-1991必填项患者的民族codecontacts监护人姓名varchar(255)255必填项监护人姓名Contactsje1患者监护人电话varchar(16)16必填项患者监护人电话Contactsjesjwo患者监护人电话（副）varchar(16)16必填项患者监护人电话（副）contacts_re1_code患者与监护人关系codevarchar(4)4.01：父母；02：配偶；03：子女；必填项患者与监护人关系code自定义标识符（必填项）名称（必填）数据类型（必填）数据长度（必填）字典（按需填写）填报要求（必填）说明04:亲戚；05:朋友；06:同事；07:同学；08:老师；09：兄弟姐妹；10：社区工作者；11：老乡；12:患者本人；-1：其他Current_addr_type_code患者现住址类别varchar(4)4HBCV02.01.026可选患者现住址类别current_addr_code患者现住址codevarchar(32)32HBCV02.01.003必填项患者现住址code,从全民健康信息平台获取current_addr_detai1患者现住址的详情varchar(255)255必填项患者现住址的详情patient_addr_type_code患者所属地区类型varchar(4)41：本县区；2:本市其它县区；3:本省其它地市；4:其它省必填项患者所属地区类型psychogeny_permanent_addr_code患者户别varchar(4)41:城镇；2:农村；3：外籍；4：不详必填项患者户别permanent_addr_code患者户籍地区codevarchar(32)32GB/T2260-2007必填项患者户籍地区code,从全民健康信息平台获取permanent_addr_detai1患者户籍详细地址varchar(255)255必填项患者户籍详细地址自定义标识符（必填项）名称（必填）数据类型（必填）数据长度（必填）字典（按需填写）填报要求（必填）说明permanent_addr_type_code患者户籍所在地类型varchar(