DBLUN7 *SYSTEM object_id double flag int name char[100] short_name char[12] creation_date char[10] semantics_desc text technical_desc text sys_mo rel sys_sch rel link rel user_viewable rel viewable_note rel go_uo rel go_st rel act_arg rel go_nn_note rel *META_OBJECT object_id double flag int name char[100] type short semantics_desc text mo_mp rel concept_mo rel *META_PROPERTY object_id double flag int name char[100] type short funct int semantics_desc text *SCHEMA object_id double flag int name char[100] short_name char[12] version char[16] creation_date char[10] last_update char[10] lock char type char semantics_desc text technical_desc text trace_on int from rel to rel is_in rel sch_do rel sch_col rel sch_inst rel owner_pu rel user_viewable rel viewable_note rel go_uo rel go_st rel act_arg rel go_nn_note rel *ENTITY_TYPE object_id double flag int name char[100] short_name char[12] semantics_desc text technical_desc text owner_att rel owner_group rel col_do2 rel owner_pu rel et_role1 rel decomp rel general rel domain rel go_uo rel go_st rel act_arg rel go_nn_note rel *REL_TYPE object_id double flag int name char[100] short_name char[12] semantics_desc text technical_desc text owner_att rel owner_group rel col_do2 rel owner_pu rel rt_type rel go_uo rel go_st rel act_arg rel go_nn_note rel *CO_ATTRIBUTE object_id double flag int name char[100] short_name char[12] semantics_desc text technical_desc text min_rep unsigned int max_rep unsigned int set_type char owner_att rel owner_group rel col_do2 rel domain rel at_ro_gr go_uo rel go_st rel act_arg rel go_nn_note rel *SI_ATTRIBUTE object_id double flag int name char[100] short_name char[12] semantics_desc text technical_desc text min_rep unsigned int max_rep unsigned int set_type char stable char recyclable char type char length unsigned int decim short owner_group rel col_do2 rel domain rel at_ro_gr go_uo rel go_st rel act_arg rel go_nn_note rel *ROLE object_id double flag int name char[100] min_con unsigned int max_con unsigned int aggregation char semantics_desc text technical_desc text at_ro_gr et_role2 rel go_uo rel go_st rel act_arg rel go_nn_note rel *ET_ROLE object_id double flag int *GROUP object_id double flag int name char[100] type char funct int min_rep unsigned int max_rep unsigned int semantics_desc text technical_desc text at_ro_gr gr_comp rel member_gr rel go_uo rel go_st rel act_arg rel go_nn_note rel *COMPONENT object_id double flag int *MEMBER_CST object_id double flag int mem_role char *CONSTRAINT object_id double flag int type char mbr_cst rel go_uo rel *COLLECTION object_id double flag int name char[100] short_name char[12] semantics_desc text technical_desc text col_do1 rel go_uo rel go_st rel act_arg rel go_nn_note rel *COL_DO object_id double flag int *CLUSTER object_id double flag int cluster_id char[100] type int criterion char[30] special rel go_uo rel go_st rel act_arg rel go_nn_note rel *SUB_TYPE object_id double flag int value char[30] go_uo rel *USER_VIEW object_id double flag int name char[100] type int zoom int reduce int xgrid int ygrid int font_size int font_name char[30] text_font_size int text_font_name char[30] markplan int uv_uo rel *USER_OBJECT object_id double flag int posx int posy int color int *CONNECTION object_id double flag int type char[10] seq_nbr int *TEXT object_id double flag int name char[100] version char[16] path char[771] creation_date char[10] last_update char[10] type_of_file char[10] num_line int lock char sem_desc text tech_desc text from rel to rel is_in rel text_inst rel line rel user_viewable rel viewable_note rel go_uo rel go_st rel act_arg rel go_nn_note rel *LINE object_id double flag int num int description text go_uo rel *PROD_SET object_id double flag int name char[100] version char[16] creation_date char[10] last_update char[10] lock char sem_desc text tech_desc text from rel to rel is_in rel contains rel set_inst rel go_uo rel *PROD_SET_ELEM object_id double flag int *PROC_UNIT object_id double flag int name char[100] short_name char[12] semantics_desc text technical_desc text type char mode char owner_group rel col_do2 rel p_decl rel p_fct_call rel invokes_pu rel pu_made_of rel needs rel go_st rel act_arg rel go_nn_note rel go_uo rel *ENVIRONMENT object_id double flag int type char mode char go_nn_note rel go_uo rel *STATE object_id double flag int name char[100] short_name char[12] semantics_desc text technical_desc text owner_group rel col_do2 rel st_env rel go_nn_note rel go_uo rel *ELEMENT object_id double flag int type char description text p_made_of rel p_part_of rel go_nn_note rel go_uo rel *SUB_ELEMENT object_id double flag int type char mode char go_nn_note rel go_uo rel *P_EXPRESSION object_id double flag int oper int constant char[255] description text sub_expression rel go_uo rel *CONSUMPTION object_id double flag int min_card_res int max_card_res int min_card_pu int max_card_pu int min_card_role int max_card_role int go_st rel act_arg rel go_nn_note rel go_uo rel *RESOURCE object_id double flag int name char[100] short_name char[12] semantics_desc text technical_desc text type char owner_group rel col_do2 rel is_used rel cp_res rel re_gen rel re_spec rel go_st rel act_arg rel go_nn_note rel go_uo rel *RES_ROLE object_id double flag int name char[100] short_name char[12] semantics_desc text technical_desc text owner_group rel col_do2 rel for rel cp_rol rel ro_gen rel ro_spec rel go_st rel act_arg rel go_nn_note rel go_uo rel *RE_ISA object_id double flag int go_nn_note rel go_uo rel *RO_ISA object_id double flag int go_nn_note rel go_uo rel *CAN_PLAY object_id double flag int go_nn_note rel go_uo rel *DYNAMIC_PROPERTY mp_id double object_id double value text *METHODOLOGY object_id double title char[100] version char[16] date char[10] author char[100] help_file char[255] description text user_viewable rel viewable_note rel *STATEMENT object_id double type int state char glbtrsf trsfscr sub_stmt rel strategy rel condition rel stmt_param rel pp_inst rel ep_inst rel cs_inst rel *EXPRESSION object_id double type int not char weak char sub_expression rel cond_dec rel expr_param rel *PARAMETER object_id double integer int string char[255] analysis_expr anallist type char mode char usage char *PROCESS_TYPE object_id double name char[100] title char[100] explain char[100] description text perform rel form_arg rel invokes rel *TOOLBOX object_id double name char[100] title char[100] functions list_int description text uses rel *TEXT_TYPE object_id double name char[100] title char[100] weak char min_mul int max_mul int usage char description text act_arg rel ttext_inst rel *SCHEMA_TYPE object_id double name char[100] title char[100] weak char min_mul int max_mul int usage char description text act_arg rel tschema_inst rel *PROD_SET_TYPE object_id double name char[100] title char[100] min_mul int max_mul int usage char description text actarg rel tset_inst rel *TEXT_MODEL object_id double name char[100] title char[100] description text default_ext list_char[3] grammar char[255] model_expr rel specialization rel text_conform rel *SCHEMA_MODEL object_id double name char[100] title char[100] description text constraints anallist model_expr rel specialization rel schema_conform rel have_concept rel *MOD_CONCEPT object_id double contextual_name char[100] funct1 unsigned int funct2 unsigned int *ENGINEERING_PROCESS object_id double name char[100] start_date char[10] start_time char[10] end_date char[10] end_time char[10] in_progress char description text flag int io_proc rel made_of rel start rel user_viewable rel viewable_note rel go_uo rel go_nn_note rel *DECISION object_id double name char[100] start_date char[10] start_time char[10] end_date char[10] end_time char[10] in_progress char yes_no char description text flag int io_proc rel go_uo rel go_nn_note rel *PRIMITIVE_PROCESS object_id double name char[100] start_date char[10] start_time char[10] end_date char[10] end_time char[10] in_progress char description text flag int io_proc rel go_uo rel go_nn_note rel *CONTROL_STRUCTURE object_id double name char[100] start_date char[10] start_time char[10] end_date char[10] end_time char[10] in_progress char golist list_int description text io_proc rel *SCHEMA_INSTANCE object_id double usage char checkpoint char[100] flag int go_nn_note rel *TEXT_INSTANCE object_id double usage char checkpoint char[100] flag int go_nn_note rel *PROD_SET_INSTANCE object_id double usage char checkpoint char[100] flag int go_nn_note rel *NOTE object_id double flag int description text note_nn_note rel go_uo rel *NN_NOTE object_id double flag int *DESCRIPTIONS schema double length long text FILE *LOG schema double length long text FILE * *0 0 0 EsamiLIA EsamiLIA 20050804 0 0 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 - 643 43 - 35 - 1 - - - - - - *1 2 0 Project 1 0 - - *1 3 0 Schema 2 0 245 - - *1 4 0 Text 31 0 - - *1 5 0 Product set 41 0 - - *1 6 0 Entity type 11 0 20 246 - - *1 7 0 Rel-type 12 0 21 - - *1 8 0 Atomic attribute 7 0 25 24 23 248 - - *1 9 0 Compound attribute 6 0 26 - - *1 10 0 Group 16 0 249 - - *1 11 0 Role 14 0 22 - - *1 12 0 Collection 4 0 27 247 - - *1 13 0 Processing unit 40 0 28 - - *1 14 0 Processing unit relation 45 0 34 - - *1 15 0 Association 47 0 32 - - *1 16 0 Actor 48 0 30 - - *1 17 0 Actor generalization 62 0 31 - - *1 18 0 State 61 0 33 - - *1 19 0 In-out 43 0 29 - - *2 245 0 line 86 0 0 *2 246 0 line 86 0 0 *2 20 0 Stereotype 86 14 0 *2 21 0 Stereotype 86 14 0 *2 248 0 line 86 0 0 *2 23 0 Stereotype 86 14 0 *2 24 0 Default value 86 2 0 *2 25 0 Value constraint 86 10 0 *2 26 0 Stereotype 86 14 0 *2 249 0 line 86 0 0 *2 22 0 Stereotype 86 14 0 *2 247 0 line 86 0 0 *2 27 0 Stereotype 86 14 0 *2 28 0 Stereotype 86 14 0 *2 34 0 Stereotype 86 14 0 *2 32 0 Stereotype 86 14 0 *2 30 0 Stereotype 86 14 0 *2 31 0 Stereotype 86 14 0 *2 33 0 Stereotype 86 14 1 *2 29 0 Stereotype 86 14 0 *3 43 4864 esami es 1 20050804 20050805 T E 0 0 0 - - - 217 198 185 191 200 193 201 187 195 199 188 197 209 196 - - 44 46 50 648 - - 45 - - 47 51 - - - - *4 185 0 directory_doc 0 0 187 188 - 189 272 - - - 223 - - - - 186 - - - - *4 191 0 esaminatore_dir 0 0 - 225 - - - 220 212 - - - - 192 - - - - *4 193 0 esaminatore 0 0 195 196 197 198 199 200 201 - 202 207 269 - - - 215 - - - - 194 - - - - *5 209 0 svolge l'esame 0 0 - - - - 211 214 - 210 - - - - *5 217 0 appartiene 0 0 - - - - 219 222 - 218 - - - - *7 187 0 id_dir 0 0 1 1 S T F S 5 0 - - - 190 - 228 - - - - *7 188 0 nome_dir 0 0 1 1 S F T V 15 0 - - - 273 - 229 - - - - *7 195 0 id_esaminatore 0 0 1 1 S T F S 5 0 - - - 203 - 232 - - - - *7 196 0 username 0 0 1 1 S F T V 15 0 - - - 208 - 233 - - - - *7 197 0 password 0 0 1 1 S F T V 20 0 - - - - 234 - - - - *7 198 0 cognome 0 0 1 1 S F T V 40 0 - - - - 235 - - - - *7 199 0 nome 0 0 1 1 S F T V 40 0 - - - - 236 - - - - *7 200 0 email 0 0 1 1 S F T V 100 0 - - - 270 - 237 - - - - *7 201 0 group 0 0 1 1 S F T A 1 0 - - - - 238 - - - - *8 214 0 1 N 0 0 226 - 215 - 216 - - - - *8 211 0 1 1 0 0 - 212 - 213 - - - - *8 222 0 1 N 0 0 227 - 223 - 224 - - - - *8 219 0 1 1 0 0 - 220 - 221 - - - - *9 223 0 *9 212 0 *9 220 0 *9 215 0 *10 272 0 IDdirectory_docente A 2 0 N 0 0 - 273 - - 274 - - - - *10 269 0 IDesaminatore_1 A 2 0 N 0 0 - 270 - - 271 - - - - *10 189 0 IDdir_esaminatore A 1 0 N 0 0 - 190 - - 230 - - - - *10 225 0 IDdiritti_scrittura A 1 0 N 0 0 - 226 227 - - 231 - - - - *10 207 0 IDesaminatore_2 A 2 0 N 0 0 - 208 - - 241 - - - - *10 202 0 IDesaminatore A 1 0 N 0 0 - 203 - - 239 - - - - *11 273 0 *11 270 0 *11 226 0 *11 227 0 *11 190 0 *11 203 0 *11 208 0 *18 645 0 0 100 100 0 0 0 0 1 - *18 36 0 0 100 100 0 0 0 0 1 - *18 41 0 23 100 100 0 0 0 0 1 42 51 52 652 653 - *18 45 0 23 100 100 0 0 0 0 1 47 186 192 194 210 213 216 218 221 224 228 229 230 231 232 233 234 235 236 237 238 239 241 271 274 - *18 1 0 23 100 100 0 0 0 0 1 651 - *19 653 0 30000 43984 0 *19 652 0 30000 58984 0 *19 651 0 0 20000 0 *19 274 0 0 0 0 *19 271 0 0 0 0 *19 52 0 30000 13984 0 *19 42 0 100000 10264 0 *19 230 0 0 0 0 *19 239 0 0 0 0 *19 241 0 0 0 0 *19 231 0 0 0 0 *19 213 0 82995 53963 0 *19 216 0 46234 53963 0 *19 221 0 136519 53963 0 *19 224 0 167724 53963 0 *19 228 0 0 0 0 *19 229 0 0 0 0 *19 232 0 0 0 0 *19 233 0 0 0 0 *19 234 0 0 0 0 *19 235 0 0 0 0 *19 236 0 0 0 0 *19 237 0 0 0 0 *19 238 0 0 0 0 *19 210 0 64813 53963 0 *19 218 0 151923 53963 0 *19 186 0 183638 53963 0 *19 192 0 109757 53963 0 *19 194 0 27409 53963 0 *19 51 0 30000 28984 0 *19 47 0 84666 5291 0 *21 643 0 06_schemadb.sql 1 C:\DOCUMENTS AND SETTINGS\SISSI\DESKTOP\Tesi\Documentazione\ 20050805 20050805 G_POSTGRES 1 T 0 0 - - - 644 649 650 - - 645 - - 652 651 - - - - *37 245 43 242:12,258:58,643:368 *37 246 185 242:18,258:64,643:374 *37 246 191 242:23,258:69,643:380 *37 246 193 242:27,258:73,643:384 *37 248 187 242:19,258:65,643:375 *37 248 188 242:20,258:66,643:376 *37 248 195 242:28,258:74,643:385 *37 248 196 242:29,258:75,643:386 *37 248 197 242:30,258:76,643:387 *37 248 198 242:31,258:77,643:388 *37 248 199 242:32,258:78,643:389 *37 248 200 242:33,258:79,643:390 *37 248 201 242:34,258:80,643:391 *37 249 272 643:378 *37 249 269 643:394 *37 249 189 242:21,258:67,643:377 *37 249 225 242:25,258:71,643:382 *37 249 207 242:37,258:83,643:393 *37 249 202 242:35,258:81,643:392 *38 35 20050804 0 36 - - *39 646 17 0 - - - - - 647 - - - *39 38 13 0 - - 39 - - - - - - *39 48 18 0 - - - - - 49 - - - *42 39 No_method No method 0 35 - - - *43 37 Everything Do whatever you want 14001 - 0 38 - *50 40 EsamiLIA 20050804 103434 T 0 0 44 46 644 650 - 49 647 - 35 - 41 - - 42 - - *52 647 Generate SQL 20050805 142400 20050805 142400 F 0 0 648 649 - 653 - - *52 49 New schema 20050804 103825 20050804 103825 F 0 0 50 - 52 - - *54 648 i 0 - *54 44 C 0 - *54 46 n 0 - *54 50 o 0 - *55 650 n 0 - *55 649 o 0 - *55 644 C 0 - *59 0 108 #VALUES= ET RT Att Coll # *59 43 4 *59 643 4 *59 35 4 *60 43 19 *POT "begin-file"