数据库变更2011-04-18（Database change 2011-04-18）.docVIP

数据库变更2011-04-18（Database change 2011-04-18） First, replace the table (delete the original table, and then import ADDMP; work with the second step!) FY_B_CSQXETDJ birth defects death report card FY_B_YCFSWDJ maternal death report card FY_B_ETSWDJ registration of child deaths Two, adding tables (implemented by importing ADDMP) FY_D_CSQX birth defects FY_M_JCXM_TY general inspection items D_JKJY_LX types of health education M_SQBZBZ community assistance Standard Dictionary FY_B_ZLSFB_SJQD checklist FY_B_ZLSF_MAX_SJ maximum current receipt number Three, cancel the table (delete): D_FLUP_TYPES B_GR_JKWT Four, adjust the structure of the table 1, table B_JKJY add field: CJRS NUMBER 7,0 / / the number of participants (default 0) 2, table B_DA_GRXX add field JWBS, NVARCHAR2 (80) past medical history Setting: YCBSBZ genetic history (with or without) 3. Table B_SF_ZQ is structured as follows: Adjusting field: SFLB VARCHAR2 (2) NOT NULL / / follow-up length adjustment to the VARCHAR2 category (10) Add fields (after SFLB): SFLBMC VARCHAR2 (40), / / health problems (corresponding to the type name dictionary name D_ZDY_JBLX) JKWTMS VARCHAR2 (160), / / health problem description ICD VARCHAR2 (20), //ICD number QZSJ DATE / / diagnosis time QZDD VARCHAR2 (100), location / / diagnosis QZYS VARCHAR2 (20), the doctor / / diagnosis SFBZ VARCHAR2 (1), mark (1- / / need follow-up,0- does not need to default,0) 4, dictionary D_ZDY_JBLX data content adjustment A, revised records:03, coronary heart disease adjusted to03 elderly B, increase in records:08, coronary heart disease C, adjust table B_SF_ZQ record: UPDATE, B_SF_ZQ, SET, SFLB=08, WHERE, SFLB =03; 5, the health check list structure changes as follows: Table B_GR_JKJC adds the following fields: (Location: CT- check after body) Life style XLZT_JZ VARCHAR2 (2), heart condition (_ / /: / is not tight; the default no) XLZT_YY VARCHAR2 (2), depression (_ / / heart condition choice: whether / is the default; no) XLZT_