-- Create table create table SUMMARY ( SOTR_CODE NUMBER, BIRTH_DATE DATE, EDUCATIONAL_LEVEL NUMBER, MARITAL_STATUS CHAR(3), BASIS_SPEC NUMBER, BEG_COMM_WORK DATE, BEG_BAS_WORK DATE, BEG_CONT_WORK DATE, BEG_VSUWORK DATE, WORKING NUMBER, REG_EMPL NUMBER, WORK_BOOK CHAR(15), STR_POLIS CHAR(15), PENS_POLIS CHAR(15), BIRTH_PLACE CHAR(120), BIRTH_PLACE_CODE CHAR(11), COUNTRY_CODE NUMBER, RESIDENT NUMBER, PERS_FILE_NO CHAR(10), SUR_NAME CHAR(30), SNAME CHAR(30), PATRONYMIC CHAR(30), SEX CHAR(1), LITERA CHAR(1), ITEM_NO NUMBER, ITEM_CODE NUMBER, WORK_MODE NUMBER, DIVISION_CODE NUMBER, POST_CODE NUMBER, RAZR NUMBER, ST_PERCENT NUMBER, ACTUAL NUMBER, SROK DATE, COMMEN CHAR(120), FIN_SO NUMBER, CAT_CODE NUMBER, FAC CHAR(254), FAC_CODE NUMBER, KAF_CODE NUMBER, KAF_NAME CHAR(254), DIV_NAME CHAR(254), IN_DATE DATE, OUT_DATE DATE, FULL_NAME CHAR(35), ST_CODE NUMBER, ST_NAME CHAR(30), SC_NAME CHAR(30), ZVANIE CHAR(30), ZV_CODE NUMBER ) tablespace SALARY pctfree 10 initrans 1 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); -- Add comments to the columns comment on column SUMMARY.SOTR_CODE is 'Eia'; comment on column SUMMARY.BIRTH_DATE is 'Aaoa ?i?aaiey'; comment on column SUMMARY.EDUCATIONAL_LEVEL is 'O?iaaiu ia?aciaaiey'; comment on column SUMMARY.MARITAL_STATUS is '?aiao/Caio?'; comment on column SUMMARY.BASIS_SPEC is 'Iniiaiay niaoeaeuiinou (eia)'; comment on column SUMMARY.BEG_COMM_WORK is 'Ia?aei iauaai o?oaiaiai noa?a'; comment on column SUMMARY.BEG_BAS_WORK is 'Iayaei ?aaiou ii iniiaiie niaoeaeuiioe'; comment on column SUMMARY.BEG_CONT_WORK is 'Ia?aei iai?a?uaiiai noa?a'; comment on column SUMMARY.BEG_VSUWORK is 'Ia?aei ?aaiou a AAO'; comment on column SUMMARY.WORKING is '?aaioaao a ianoiyuaa a?aiy (=1)'; comment on column SUMMARY.REG_EMPL is 'Ooaoiue. Yoi oeaea, a eioi?ie ea?aue aeo ioaa?aao ca iaee?ea ii?aaaeaiiiai aeaa ?aaiou. ?ani?aaaeaiea aeo niioaaonoaoao iienaie? TSummWorkMode = (wmReg, wmSovm, wmCompl, wmWide, wmSovm2, wmDog, // Ini Niai Aiiiei ?anoe?a Niaiauaiea Aiaiai? iia? wmSogl, wmHou, wmOnePay, wmComand, wmMix ); // O?_niae Ii?an ?acAuie Eiiaiae? ?aciia'; comment on column SUMMARY.WORK_BOOK is 'Iiia? o?oaiaie eie?ee (aey io?a IE)'; comment on column SUMMARY.STR_POLIS is 'No?aoiaie iieen'; comment on column SUMMARY.PENS_POLIS is 'Iaineiiiue iieen'; comment on column SUMMARY.BIRTH_PLACE is 'Ianoi ?i?aaiey'; comment on column SUMMARY.BIRTH_PLACE_CODE is 'Eia ianoa ?i?aaiey (ii eeanneoeeaoee "KLADR"'; comment on column SUMMARY.COUNTRY_CODE is 'Eia no?aiu'; comment on column SUMMARY.PERS_FILE_NO is 'Aey io?a IE'; comment on column SUMMARY.SUR_NAME is 'Oaieeey'; comment on column SUMMARY.SNAME is 'Eiy'; comment on column SUMMARY.PATRONYMIC is 'Io?anoai'; comment on column SUMMARY.SEX is 'Iie'; comment on column SUMMARY.LITERA is 'Oa?aeoa?enoeea ?aai?aai ianoa (A, A, ...)'; comment on column SUMMARY.ITEM_NO is 'Iiia? aoiia ?aaiou aey aaiiiai nio?oaieea n aaiiie eeoa?ie. Iiey Eia nio?oaieea, Eeoa?a, e aaiiia iiea ia?aco?o ia?ae?iue ee?? a oaaeeoa aoiiia ?aaiou (WU_ITEM)'; comment on column SUMMARY.ITEM_CODE is 'Oieeaeuiue eia aoiia oaaeeou WU_ITEM. Eniieucoaony aey nayce n oaaeeoae WUH, eioi?ay niaa??eo aaou (ca?eneaiey, oaieuiaiey, i?eeaca) e iiia? i?eeaca'; comment on column SUMMARY.WORK_MODE is 'Aea ?aaiou (ni. WORK_MODES)'; comment on column SUMMARY.DIVISION_CODE is 'Eia iia?acaaeaiey'; comment on column SUMMARY.POST_CODE is 'Eia aie?iinoe'; comment on column SUMMARY.RAZR is '?ac?ya'; comment on column SUMMARY.ST_PERCENT is 'I?ioaio noaaee (100 - iieiay noaaea)'; comment on column SUMMARY.ACTUAL is 'Anee aie?iinou aeooaeuia, oi 7, eia?a 0'; comment on column SUMMARY.SROK is 'N?ie eiio?aeoa'; comment on column SUMMARY.COMMEN is 'Eiiiaioa?ee e aoiio ?aaiou'; comment on column SUMMARY.FIN_SO is 'Oeiaine?iaaiea'; comment on column SUMMARY.CAT_CODE is 'Eia eaoaai?ee?. 1 - AOI, 2 - IOI, 3 - IANE, 4 - IIN, 6 - OAI, 10 - Iao eaoaai?ee'; comment on column SUMMARY.FAC is 'Oaeoeuoao (Anee anou)'; comment on column SUMMARY.FAC_CODE is 'Eia oaeoeuoaoa (anee anou, eia?a NULL)'; comment on column SUMMARY.KAF_CODE is 'Eia eaoaa?u'; comment on column SUMMARY.KAF_NAME is 'Eaoaa?a'; comment on column SUMMARY.DIV_NAME is 'Iia?acaaeaiea'; comment on column SUMMARY.IN_DATE is 'Aaoa i?eaia'; comment on column SUMMARY.OUT_DATE is 'Aaoa oaieuiaiey'; comment on column SUMMARY.FULL_NAME is 'Aie?iinou'; comment on column SUMMARY.ST_CODE is 'Eia nooaiaie. 1 - eaiaeaao, 2 - aieoi?'; comment on column SUMMARY.ST_NAME is 'Eiy noaiie'; comment on column SUMMARY.SC_NAME is 'Iaoea'; comment on column SUMMARY.ZVANIE is 'Caaiea'; comment on column SUMMARY.ZV_CODE is 'Eia caaiey (nnueea oa oaaeeoo ZV_ST)'; -- Create/Recreate indexes create index SUMMARY_SOTR_CODE on SUMMARY (SOTR_CODE) tablespace SALARY pctfree 10 initrans 2 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); create index SUMMARY_SURNAME on SUMMARY (SUR_NAME) tablespace SALARY pctfree 10 initrans 2 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); -- Grant/Revoke object privileges grant select, insert, update, delete on SUMMARY to CONTINGENT with grant option; grant select on SUMMARY to INFO_BMU; grant select on SUMMARY to MKOVUZ with grant option; grant select on SUMMARY to MKO_WORKING;