diff options
Diffstat (limited to 'doc/database/ledgersmb.zigzag.dia')
| -rw-r--r-- | doc/database/ledgersmb.zigzag.dia | 5358 |
1 files changed, 4849 insertions, 509 deletions
diff --git a/doc/database/ledgersmb.zigzag.dia b/doc/database/ledgersmb.zigzag.dia index 51ead1b9..d121f1e5 100644 --- a/doc/database/ledgersmb.zigzag.dia +++ b/doc/database/ledgersmb.zigzag.dia @@ -457,11 +457,11 @@ <dia:string># id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#integer#</dia:string> + <dia:string>#serial#</dia:string> </dia:attribute> <dia:attribute name="value"> - <dia:string>#nextval('id'::regclass)#</dia:string> + <dia:string/> </dia:attribute> <dia:attribute name="visibility"> @@ -523,7 +523,7 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># vendor_id#</dia:string> + <dia:string># entity_id#</dia:string> </dia:attribute> <dia:attribute name="type"> <dia:string>#integer#</dia:string> @@ -776,7 +776,7 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># employee_id#</dia:string> + <dia:string># person_id#</dia:string> </dia:attribute> <dia:attribute name="type"> <dia:string>#integer#</dia:string> @@ -1113,11 +1113,11 @@ <dia:string># id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#integer#</dia:string> + <dia:string>#serial#</dia:string> </dia:attribute> <dia:attribute name="value"> - <dia:string>#nextval('id'::regclass)#</dia:string> + <dia:string/> </dia:attribute> <dia:attribute name="visibility"> @@ -1179,7 +1179,7 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># customer_id#</dia:string> + <dia:string># entity_id#</dia:string> </dia:attribute> <dia:attribute name="type"> <dia:string>#integer#</dia:string> @@ -1478,7 +1478,7 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># employee_id#</dia:string> + <dia:string># person_id#</dia:string> </dia:attribute> <dia:attribute name="type"> <dia:string>#integer#</dia:string> @@ -2123,7 +2123,7 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># employee_id#</dia:string> + <dia:string># person_id#</dia:string> </dia:attribute> <dia:attribute name="type"> <dia:string>#integer#</dia:string> @@ -2276,11 +2276,11 @@ <dia:string># id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#integer#</dia:string> + <dia:string>#serial#</dia:string> </dia:attribute> <dia:attribute name="value"> - <dia:string>#nextval('id'::regclass)#</dia:string> + <dia:string/> </dia:attribute> <dia:attribute name="visibility"> @@ -2449,11 +2449,11 @@ <dia:string># id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#integer#</dia:string> + <dia:string>#serial#</dia:string> </dia:attribute> <dia:attribute name="value"> - <dia:string>#nextval('id'::regclass)#</dia:string> + <dia:string/> </dia:attribute> <dia:attribute name="visibility"> @@ -2658,7 +2658,7 @@ <dia:real val="6.6000000000000005"/> </dia:attribute> <dia:attribute name="name"> - <dia:string>#custom_field_catalog#</dia:string> + <dia:string>#company#</dia:string> </dia:attribute> <dia:attribute name="comment"> @@ -2734,7 +2734,7 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># field_id#</dia:string> + <dia:string># id#</dia:string> </dia:attribute> <dia:attribute name="type"> <dia:string>#serial#</dia:string> @@ -2757,7 +2757,7 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># table_id#</dia:string> + <dia:string># entity_id#</dia:string> </dia:attribute> <dia:attribute name="type"> <dia:string>#integer#</dia:string> @@ -2780,7 +2780,76 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># field_name#</dia:string> + <dia:string># legal_name#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#text#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># entity_class_id#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#integer#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># primary_location_id#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#integer#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># tax_id#</dia:string> </dia:attribute> <dia:attribute name="type"> <dia:string>#text#</dia:string> @@ -2804,9 +2873,42 @@ </dia:attribute> <dia:attribute name="visible_operations"> - <dia:boolean val="false"/> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="operations"> + + <dia:composite type="umloperation"> + <dia:attribute name="name"> + <dia:string>#company_legal_name_check#</dia:string> + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="parameters"> + <dia:composite type="umlparameter"> + <dia:attribute name="name"> + <dia:string>#CHECK ((legal_name ~ '[[:alnum ... ext))#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="value"> + <dia:string/> + </dia:attribute> + <dia:attribute name="kind"> + <dia:enum val="0"/> + </dia:attribute> + </dia:composite> + </dia:attribute> + </dia:composite> + </dia:attribute> - <dia:attribute name="operations"/> <dia:attribute name="template"> <dia:boolean val="false"/> @@ -2831,11 +2933,11 @@ <dia:real val="6.6000000000000005"/> </dia:attribute> <dia:attribute name="name"> - <dia:string>#custom_table_catalog#</dia:string> + <dia:string>#company_to_contact#</dia:string> </dia:attribute> <dia:attribute name="comment"> - <dia:string>##</dia:string> + <dia:string># To keep track of the relationship ... pany #</dia:string> </dia:attribute> <dia:attribute name="abstract"> <dia:boolean val="false"/> @@ -2907,10 +3009,10 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># table_id#</dia:string> + <dia:string># company_id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#serial#</dia:string> + <dia:string>#integer#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -2930,10 +3032,10 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># extends#</dia:string> + <dia:string># contact_class_id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#text#</dia:string> + <dia:string>#integer#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -2953,7 +3055,7 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># table_name#</dia:string> + <dia:string># contact#</dia:string> </dia:attribute> <dia:attribute name="type"> <dia:string>#text#</dia:string> @@ -2977,9 +3079,42 @@ </dia:attribute> <dia:attribute name="visible_operations"> - <dia:boolean val="false"/> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="operations"> + + <dia:composite type="umloperation"> + <dia:attribute name="name"> + <dia:string>#company_to_contact_contact_check#</dia:string> + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="parameters"> + <dia:composite type="umlparameter"> + <dia:attribute name="name"> + <dia:string>#CHECK ((contact ~ '[[:alnum:]_ ... ext))#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="value"> + <dia:string/> + </dia:attribute> + <dia:attribute name="kind"> + <dia:enum val="0"/> + </dia:attribute> + </dia:composite> + </dia:attribute> + </dia:composite> + </dia:attribute> - <dia:attribute name="operations"/> <dia:attribute name="template"> <dia:boolean val="false"/> @@ -3004,7 +3139,7 @@ <dia:real val="6.6000000000000005"/> </dia:attribute> <dia:attribute name="name"> - <dia:string>#customer#</dia:string> + <dia:string>#company_to_entity#</dia:string> </dia:attribute> <dia:attribute name="comment"> @@ -3080,14 +3215,14 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># id#</dia:string> + <dia:string># company_id#</dia:string> </dia:attribute> <dia:attribute name="type"> <dia:string>#integer#</dia:string> </dia:attribute> <dia:attribute name="value"> - <dia:string>#nextval('id'::regclass)#</dia:string> + <dia:string/> </dia:attribute> <dia:attribute name="visibility"> @@ -3103,10 +3238,10 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># name#</dia:string> + <dia:string># entity_id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(64)#</dia:string> + <dia:string>#integer#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -3126,10 +3261,10 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># address1#</dia:string> + <dia:string># related_how#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(32)#</dia:string> + <dia:string>#text#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -3149,14 +3284,14 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># address2#</dia:string> + <dia:string># created#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(32)#</dia:string> + <dia:string>#date#</dia:string> </dia:attribute> <dia:attribute name="value"> - <dia:string/> + <dia:string>#('now'::text)::date#</dia:string> </dia:attribute> <dia:attribute name="visibility"> @@ -3170,12 +3305,149 @@ </dia:attribute> </dia:composite> + </dia:attribute> + + <dia:attribute name="visible_operations"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="operations"> + + <dia:composite type="umloperation"> + <dia:attribute name="name"> + <dia:string>#company_to_entity_check#</dia:string> + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="parameters"> + <dia:composite type="umlparameter"> + <dia:attribute name="name"> + <dia:string>#CHECK ((entity_id <> company_id))#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="value"> + <dia:string/> + </dia:attribute> + <dia:attribute name="kind"> + <dia:enum val="0"/> + </dia:attribute> + </dia:composite> + </dia:attribute> + </dia:composite> + + </dia:attribute> + + <dia:attribute name="template"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="templates"/> + </dia:object> + + <dia:object type="UML - Class" version="0" id="O11"> + <dia:attribute name="obj_pos"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.05,-0.05;16.4,6.65"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="16.350000000000001"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="6.6000000000000005"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#company_to_location#</dia:string> + </dia:attribute> + + <dia:attribute name="comment"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_attributes"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="visible_attributes"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="visible_comments"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="wrap_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="wrap_after_char"> + <dia:int val="40"/> + </dia:attribute> + <dia:attribute name="line_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="fill_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="text_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="normal_font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="abstract_font"> + <dia:font family="monospace" style="88" name="Courier"/> + </dia:attribute> + <dia:attribute name="polymorphic_font"> + <dia:font family="monospace" style="8" name="Courier"/> + </dia:attribute> + <dia:attribute name="classname_font"> + <dia:font family="sans" style="80" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font"> + <dia:font family="sans" style="88" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="comment_font"> + <dia:font family="sans" style="8" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="polymorphic_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="abstract_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="comment_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="attributes"> + <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># city#</dia:string> + <dia:string># location_id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(32)#</dia:string> + <dia:string>#integer#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -3195,10 +3467,10 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># state#</dia:string> + <dia:string># company_id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(32)#</dia:string> + <dia:string>#integer#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -3216,12 +3488,116 @@ </dia:attribute> </dia:composite> + </dia:attribute> + + <dia:attribute name="visible_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="operations"/> + + <dia:attribute name="template"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="templates"/> + </dia:object> + + <dia:object type="UML - Class" version="0" id="O12"> + <dia:attribute name="obj_pos"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.05,-0.05;16.4,6.65"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="16.350000000000001"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="6.6000000000000005"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#contact_class#</dia:string> + </dia:attribute> + + <dia:attribute name="comment"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_attributes"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="visible_attributes"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="visible_comments"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="wrap_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="wrap_after_char"> + <dia:int val="40"/> + </dia:attribute> + <dia:attribute name="line_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="fill_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="text_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="normal_font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="abstract_font"> + <dia:font family="monospace" style="88" name="Courier"/> + </dia:attribute> + <dia:attribute name="polymorphic_font"> + <dia:font family="monospace" style="8" name="Courier"/> + </dia:attribute> + <dia:attribute name="classname_font"> + <dia:font family="sans" style="80" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font"> + <dia:font family="sans" style="88" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="comment_font"> + <dia:font family="sans" style="8" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="polymorphic_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="abstract_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="comment_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="attributes"> + <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># zipcode#</dia:string> + <dia:string># id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(10)#</dia:string> + <dia:string>#serial#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -3241,10 +3617,10 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># country#</dia:string> + <dia:string># class#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(32)#</dia:string> + <dia:string>#text#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -3262,12 +3638,149 @@ </dia:attribute> </dia:composite> + </dia:attribute> + + <dia:attribute name="visible_operations"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="operations"> + + <dia:composite type="umloperation"> + <dia:attribute name="name"> + <dia:string>#contact_class_class_check#</dia:string> + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="parameters"> + <dia:composite type="umlparameter"> + <dia:attribute name="name"> + <dia:string>#CHECK (("class" ~ '[[:alnum:]_ ... ext))#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="value"> + <dia:string/> + </dia:attribute> + <dia:attribute name="kind"> + <dia:enum val="0"/> + </dia:attribute> + </dia:composite> + </dia:attribute> + </dia:composite> + + </dia:attribute> + + <dia:attribute name="template"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="templates"/> + </dia:object> + + <dia:object type="UML - Class" version="0" id="O13"> + <dia:attribute name="obj_pos"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.05,-0.05;16.4,6.65"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="16.350000000000001"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="6.6000000000000005"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#country#</dia:string> + </dia:attribute> + + <dia:attribute name="comment"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_attributes"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="visible_attributes"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="visible_comments"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="wrap_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="wrap_after_char"> + <dia:int val="40"/> + </dia:attribute> + <dia:attribute name="line_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="fill_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="text_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="normal_font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="abstract_font"> + <dia:font family="monospace" style="88" name="Courier"/> + </dia:attribute> + <dia:attribute name="polymorphic_font"> + <dia:font family="monospace" style="8" name="Courier"/> + </dia:attribute> + <dia:attribute name="classname_font"> + <dia:font family="sans" style="80" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font"> + <dia:font family="sans" style="88" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="comment_font"> + <dia:font family="sans" style="8" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="polymorphic_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="abstract_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="comment_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="attributes"> + <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># contact#</dia:string> + <dia:string># id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(64)#</dia:string> + <dia:string>#serial#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -3287,10 +3800,10 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># phone#</dia:string> + <dia:string># name#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(20)#</dia:string> + <dia:string>#text#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -3310,10 +3823,10 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># fax#</dia:string> + <dia:string># short_name#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(20)#</dia:string> + <dia:string>#text#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -3333,7 +3846,7 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># email#</dia:string> + <dia:string># itu#</dia:string> </dia:attribute> <dia:attribute name="type"> <dia:string>#text#</dia:string> @@ -3354,9 +3867,223 @@ </dia:attribute> </dia:composite> + </dia:attribute> + + <dia:attribute name="visible_operations"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="operations"> + + <dia:composite type="umloperation"> + <dia:attribute name="name"> + <dia:string>#country_name_check#</dia:string> + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="parameters"> + <dia:composite type="umlparameter"> + <dia:attribute name="name"> + <dia:string>#CHECK ((name ~ '[[:alnum:]_]'::text))#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="value"> + <dia:string/> + </dia:attribute> + <dia:attribute name="kind"> + <dia:enum val="0"/> + </dia:attribute> + </dia:composite> + </dia:attribute> + </dia:composite> + + <dia:composite type="umloperation"> + <dia:attribute name="name"> + <dia:string>#country_short_name_check#</dia:string> + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="parameters"> + <dia:composite type="umlparameter"> + <dia:attribute name="name"> + <dia:string>#CHECK ((short_name ~ '[[:alnum ... ext))#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="value"> + <dia:string/> + </dia:attribute> + <dia:attribute name="kind"> + <dia:enum val="0"/> + </dia:attribute> + </dia:composite> + </dia:attribute> + </dia:composite> + + </dia:attribute> + + <dia:attribute name="template"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="templates"/> + </dia:object> + + <dia:object type="UML - Class" version="0" id="O14"> + <dia:attribute name="obj_pos"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.05,-0.05;16.4,6.65"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="16.350000000000001"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="6.6000000000000005"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#custom_field_catalog#</dia:string> + </dia:attribute> + + <dia:attribute name="comment"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_attributes"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="visible_attributes"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="visible_comments"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="wrap_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="wrap_after_char"> + <dia:int val="40"/> + </dia:attribute> + <dia:attribute name="line_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="fill_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="text_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="normal_font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="abstract_font"> + <dia:font family="monospace" style="88" name="Courier"/> + </dia:attribute> + <dia:attribute name="polymorphic_font"> + <dia:font family="monospace" style="8" name="Courier"/> + </dia:attribute> + <dia:attribute name="classname_font"> + <dia:font family="sans" style="80" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font"> + <dia:font family="sans" style="88" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="comment_font"> + <dia:font family="sans" style="8" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="polymorphic_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="abstract_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="comment_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="attributes"> + <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># notes#</dia:string> + <dia:string># field_id#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#serial#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># table_id#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#integer#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># field_name#</dia:string> </dia:attribute> <dia:attribute name="type"> <dia:string>#text#</dia:string> @@ -3377,12 +4104,116 @@ </dia:attribute> </dia:composite> + </dia:attribute> + + <dia:attribute name="visible_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="operations"/> + + <dia:attribute name="template"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="templates"/> + </dia:object> + + <dia:object type="UML - Class" version="0" id="O15"> + <dia:attribute name="obj_pos"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.05,-0.05;16.4,6.65"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="16.350000000000001"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="6.6000000000000005"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#custom_table_catalog#</dia:string> + </dia:attribute> + + <dia:attribute name="comment"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_attributes"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="visible_attributes"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="visible_comments"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="wrap_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="wrap_after_char"> + <dia:int val="40"/> + </dia:attribute> + <dia:attribute name="line_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="fill_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="text_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="normal_font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="abstract_font"> + <dia:font family="monospace" style="88" name="Courier"/> + </dia:attribute> + <dia:attribute name="polymorphic_font"> + <dia:font family="monospace" style="8" name="Courier"/> + </dia:attribute> + <dia:attribute name="classname_font"> + <dia:font family="sans" style="80" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font"> + <dia:font family="sans" style="88" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="comment_font"> + <dia:font family="sans" style="8" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="polymorphic_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="abstract_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="comment_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="attributes"> + <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># discount#</dia:string> + <dia:string># table_id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#numeric#</dia:string> + <dia:string>#serial#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -3402,14 +4233,14 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># taxincluded#</dia:string> + <dia:string># extends#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#boolean#</dia:string> + <dia:string>#text#</dia:string> </dia:attribute> <dia:attribute name="value"> - <dia:string>#false#</dia:string> + <dia:string/> </dia:attribute> <dia:attribute name="visibility"> @@ -3425,10 +4256,10 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># creditlimit#</dia:string> + <dia:string># table_name#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#numeric#</dia:string> + <dia:string>#text#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -3446,12 +4277,116 @@ </dia:attribute> </dia:composite> + </dia:attribute> + + <dia:attribute name="visible_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="operations"/> + + <dia:attribute name="template"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="templates"/> + </dia:object> + + <dia:object type="UML - Class" version="0" id="O16"> + <dia:attribute name="obj_pos"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.05,-0.05;16.4,6.65"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="16.350000000000001"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="6.6000000000000005"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#customer#</dia:string> + </dia:attribute> + + <dia:attribute name="comment"> + <dia:string># This is now a metadata table that ... ment #</dia:string> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_attributes"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="visible_attributes"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="visible_comments"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="wrap_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="wrap_after_char"> + <dia:int val="40"/> + </dia:attribute> + <dia:attribute name="line_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="fill_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="text_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="normal_font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="abstract_font"> + <dia:font family="monospace" style="88" name="Courier"/> + </dia:attribute> + <dia:attribute name="polymorphic_font"> + <dia:font family="monospace" style="8" name="Courier"/> + </dia:attribute> + <dia:attribute name="classname_font"> + <dia:font family="sans" style="80" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font"> + <dia:font family="sans" style="88" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="comment_font"> + <dia:font family="sans" style="8" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="polymorphic_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="abstract_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="comment_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="attributes"> + <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># terms#</dia:string> + <dia:string># id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#smallint#</dia:string> + <dia:string>#serial#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -3471,10 +4406,10 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># customernumber#</dia:string> + <dia:string># entity_id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(32)#</dia:string> + <dia:string>#integer#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -3494,10 +4429,10 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># cc#</dia:string> + <dia:string># discount#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#text#</dia:string> + <dia:string>#numeric#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -3517,10 +4452,33 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># bcc#</dia:string> + <dia:string># taxincluded#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#text#</dia:string> + <dia:string>#boolean#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string>#false#</dia:string> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># creditlimit#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#numeric#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -3540,10 +4498,10 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># business_id#</dia:string> + <dia:string># terms#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#integer#</dia:string> + <dia:string>#smallint#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -3563,7 +4521,7 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># taxnumber#</dia:string> + <dia:string># customernumber#</dia:string> </dia:attribute> <dia:attribute name="type"> <dia:string>#character varying(32)#</dia:string> @@ -3586,10 +4544,10 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># sic_code#</dia:string> + <dia:string># cc#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(6)#</dia:string> + <dia:string>#text#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -3609,10 +4567,10 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># iban#</dia:string> + <dia:string># bcc#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(34)#</dia:string> + <dia:string>#text#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -3632,10 +4590,10 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># bic#</dia:string> + <dia:string># business_id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(11)#</dia:string> + <dia:string>#integer#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -3655,10 +4613,56 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># employee_id#</dia:string> + <dia:string># sic_code#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#integer#</dia:string> + <dia:string>#character varying(6)#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># iban#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#character varying(34)#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># bic#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#character varying(11)#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -3754,7 +4758,7 @@ </dia:attribute> <dia:attribute name="value"> - <dia:string/> + <dia:string>#('now'::text)::date#</dia:string> </dia:attribute> <dia:attribute name="visibility"> @@ -3791,6 +4795,29 @@ </dia:attribute> </dia:composite> + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># invoice_notes#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#text#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + </dia:attribute> <dia:attribute name="visible_operations"> @@ -3804,7 +4831,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O11"> + <dia:object type="UML - Class" version="0" id="O17"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -3954,7 +4981,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O12"> + <dia:object type="UML - Class" version="0" id="O18"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -4104,7 +5131,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O13"> + <dia:object type="UML - Class" version="0" id="O19"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -4200,11 +5227,11 @@ <dia:string># id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#integer#</dia:string> + <dia:string>#serial#</dia:string> </dia:attribute> <dia:attribute name="value"> - <dia:string>#nextval('id'::regclass)#</dia:string> + <dia:string/> </dia:attribute> <dia:attribute name="visibility"> @@ -4277,7 +5304,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O14"> + <dia:object type="UML - Class" version="0" id="O20"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -4427,7 +5454,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O15"> + <dia:object type="UML - Class" version="0" id="O21"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -4448,7 +5475,7 @@ </dia:attribute> <dia:attribute name="comment"> - <dia:string>##</dia:string> + <dia:string># Is a metadata table specific to employees #</dia:string> </dia:attribute> <dia:attribute name="abstract"> <dia:boolean val="false"/> @@ -4523,11 +5550,34 @@ <dia:string># id#</dia:string> </dia:attribute> <dia:attribute name="type"> + <dia:string>#serial#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># entity_id#</dia:string> + </dia:attribute> + <dia:attribute name="type"> <dia:string>#integer#</dia:string> </dia:attribute> <dia:attribute name="value"> - <dia:string>#nextval('id'::regclass)#</dia:string> + <dia:string/> </dia:attribute> <dia:attribute name="visibility"> @@ -4566,14 +5616,14 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># name#</dia:string> + <dia:string># startdate#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(64)#</dia:string> + <dia:string>#date#</dia:string> </dia:attribute> <dia:attribute name="value"> - <dia:string/> + <dia:string>#('now'::text)::date#</dia:string> </dia:attribute> <dia:attribute name="visibility"> @@ -4589,10 +5639,10 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># address1#</dia:string> + <dia:string># enddate#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(32)#</dia:string> + <dia:string>#date#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -4612,10 +5662,10 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># address2#</dia:string> + <dia:string># notes#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(32)#</dia:string> + <dia:string>#text#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -4635,10 +5685,10 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># city#</dia:string> + <dia:string># role#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(32)#</dia:string> + <dia:string>#character varying(20)#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -4658,14 +5708,14 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># state#</dia:string> + <dia:string># sales#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(32)#</dia:string> + <dia:string>#boolean#</dia:string> </dia:attribute> <dia:attribute name="value"> - <dia:string/> + <dia:string>#false#</dia:string> </dia:attribute> <dia:attribute name="visibility"> @@ -4681,10 +5731,10 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># zipcode#</dia:string> + <dia:string># ssn#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(10)#</dia:string> + <dia:string>#character varying(20)#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -4704,10 +5754,10 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># country#</dia:string> + <dia:string># iban#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(32)#</dia:string> + <dia:string>#character varying(34)#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -4727,10 +5777,10 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># workphone#</dia:string> + <dia:string># bic#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(20)#</dia:string> + <dia:string>#character varying(11)#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -4750,10 +5800,10 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># homephone#</dia:string> + <dia:string># managerid#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(20)#</dia:string> + <dia:string>#integer#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -4773,14 +5823,14 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># startdate#</dia:string> + <dia:string># employeenumber#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#date#</dia:string> + <dia:string>#character varying(32)#</dia:string> </dia:attribute> <dia:attribute name="value"> - <dia:string>#('now'::text)::date#</dia:string> + <dia:string/> </dia:attribute> <dia:attribute name="visibility"> @@ -4796,7 +5846,7 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># enddate#</dia:string> + <dia:string># dob#</dia:string> </dia:attribute> <dia:attribute name="type"> <dia:string>#date#</dia:string> @@ -4817,12 +5867,116 @@ </dia:attribute> </dia:composite> + </dia:attribute> + + <dia:attribute name="visible_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="operations"/> + + <dia:attribute name="template"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="templates"/> + </dia:object> + + <dia:object type="UML - Class" version="0" id="O22"> + <dia:attribute name="obj_pos"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.05,-0.05;16.4,6.65"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="16.350000000000001"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="6.6000000000000005"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#entity#</dia:string> + </dia:attribute> + + <dia:attribute name="comment"> + <dia:string># The primary entity table to map to ... acts #</dia:string> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_attributes"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="visible_attributes"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="visible_comments"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="wrap_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="wrap_after_char"> + <dia:int val="40"/> + </dia:attribute> + <dia:attribute name="line_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="fill_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="text_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="normal_font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="abstract_font"> + <dia:font family="monospace" style="88" name="Courier"/> + </dia:attribute> + <dia:attribute name="polymorphic_font"> + <dia:font family="monospace" style="8" name="Courier"/> + </dia:attribute> + <dia:attribute name="classname_font"> + <dia:font family="sans" style="80" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font"> + <dia:font family="sans" style="88" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="comment_font"> + <dia:font family="sans" style="8" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="polymorphic_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="abstract_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="comment_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="attributes"> + <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># notes#</dia:string> + <dia:string># id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#text#</dia:string> + <dia:string>#serial#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -4842,10 +5996,10 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># role#</dia:string> + <dia:string># name#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(20)#</dia:string> + <dia:string>#text#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -4865,14 +6019,14 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># sales#</dia:string> + <dia:string># entity_class#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#boolean#</dia:string> + <dia:string>#integer#</dia:string> </dia:attribute> <dia:attribute name="value"> - <dia:string>#false#</dia:string> + <dia:string/> </dia:attribute> <dia:attribute name="visibility"> @@ -4886,12 +6040,149 @@ </dia:attribute> </dia:composite> + </dia:attribute> + + <dia:attribute name="visible_operations"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="operations"> + + <dia:composite type="umloperation"> + <dia:attribute name="name"> + <dia:string>#entity_name_check#</dia:string> + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="parameters"> + <dia:composite type="umlparameter"> + <dia:attribute name="name"> + <dia:string>#CHECK ((name ~ '[[:alnum:]_]'::text))#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="value"> + <dia:string/> + </dia:attribute> + <dia:attribute name="kind"> + <dia:enum val="0"/> + </dia:attribute> + </dia:composite> + </dia:attribute> + </dia:composite> + + </dia:attribute> + + <dia:attribute name="template"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="templates"/> + </dia:object> + + <dia:object type="UML - Class" version="0" id="O23"> + <dia:attribute name="obj_pos"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.05,-0.05;16.4,6.65"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="16.350000000000001"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="6.6000000000000005"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#entity_class#</dia:string> + </dia:attribute> + + <dia:attribute name="comment"> + <dia:string># Defines the class type such as ven ... oyee #</dia:string> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_attributes"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="visible_attributes"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="visible_comments"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="wrap_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="wrap_after_char"> + <dia:int val="40"/> + </dia:attribute> + <dia:attribute name="line_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="fill_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="text_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="normal_font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="abstract_font"> + <dia:font family="monospace" style="88" name="Courier"/> + </dia:attribute> + <dia:attribute name="polymorphic_font"> + <dia:font family="monospace" style="8" name="Courier"/> + </dia:attribute> + <dia:attribute name="classname_font"> + <dia:font family="sans" style="80" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font"> + <dia:font family="sans" style="88" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="comment_font"> + <dia:font family="sans" style="8" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="polymorphic_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="abstract_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="comment_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="attributes"> + <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># email#</dia:string> + <dia:string># id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#text#</dia:string> + <dia:string>#serial#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -4911,10 +6202,10 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># ssn#</dia:string> + <dia:string># class#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(20)#</dia:string> + <dia:string>#text#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -4934,15 +6225,37 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># iban#</dia:string> + <dia:string># active#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(34)#</dia:string> + <dia:string>#boolean#</dia:string> </dia:attribute> <dia:attribute name="value"> - <dia:string/> + <dia:string>#true#</dia:string> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + </dia:attribute> + <dia:attribute name="visible_operations"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="operations"> + + <dia:composite type="umloperation"> + <dia:attribute name="name"> + <dia:string>#entity_class_class_check#</dia:string> </dia:attribute> <dia:attribute name="visibility"> <dia:enum val="3"/> @@ -4953,14 +6266,129 @@ <dia:attribute name="class_scope"> <dia:boolean val="false"/> </dia:attribute> + <dia:attribute name="parameters"> + <dia:composite type="umlparameter"> + <dia:attribute name="name"> + <dia:string>#CHECK (("class" ~ '[[:alnum:]_ ... ext))#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="value"> + <dia:string/> + </dia:attribute> + <dia:attribute name="kind"> + <dia:enum val="0"/> + </dia:attribute> + </dia:composite> + </dia:attribute> </dia:composite> + </dia:attribute> + + <dia:attribute name="template"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="templates"/> + </dia:object> + + <dia:object type="UML - Class" version="0" id="O24"> + <dia:attribute name="obj_pos"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.05,-0.05;16.4,6.65"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="16.350000000000001"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="6.6000000000000005"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#entity_class_to_entity#</dia:string> + </dia:attribute> + + <dia:attribute name="comment"> + <dia:string># Relation builder for classes to entity #</dia:string> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_attributes"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="visible_attributes"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="visible_comments"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="wrap_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="wrap_after_char"> + <dia:int val="40"/> + </dia:attribute> + <dia:attribute name="line_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="fill_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="text_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="normal_font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="abstract_font"> + <dia:font family="monospace" style="88" name="Courier"/> + </dia:attribute> + <dia:attribute name="polymorphic_font"> + <dia:font family="monospace" style="8" name="Courier"/> + </dia:attribute> + <dia:attribute name="classname_font"> + <dia:font family="sans" style="80" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font"> + <dia:font family="sans" style="88" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="comment_font"> + <dia:font family="sans" style="8" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="polymorphic_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="abstract_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="comment_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="attributes"> + <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># bic#</dia:string> + <dia:string># entity_class_id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(11)#</dia:string> + <dia:string>#integer#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -4980,7 +6408,7 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># managerid#</dia:string> + <dia:string># entity_id#</dia:string> </dia:attribute> <dia:attribute name="type"> <dia:string>#integer#</dia:string> @@ -5001,12 +6429,116 @@ </dia:attribute> </dia:composite> + </dia:attribute> + + <dia:attribute name="visible_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="operations"/> + + <dia:attribute name="template"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="templates"/> + </dia:object> + + <dia:object type="UML - Class" version="0" id="O25"> + <dia:attribute name="obj_pos"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.05,-0.05;16.4,6.65"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="16.350000000000001"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="6.6000000000000005"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#entity_other_name#</dia:string> + </dia:attribute> + + <dia:attribute name="comment"> + <dia:string># Similar to company_other_name, a p ... son. #</dia:string> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_attributes"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="visible_attributes"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="visible_comments"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="wrap_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="wrap_after_char"> + <dia:int val="40"/> + </dia:attribute> + <dia:attribute name="line_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="fill_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="text_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="normal_font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="abstract_font"> + <dia:font family="monospace" style="88" name="Courier"/> + </dia:attribute> + <dia:attribute name="polymorphic_font"> + <dia:font family="monospace" style="8" name="Courier"/> + </dia:attribute> + <dia:attribute name="classname_font"> + <dia:font family="sans" style="80" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font"> + <dia:font family="sans" style="88" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="comment_font"> + <dia:font family="sans" style="8" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="polymorphic_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="abstract_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="comment_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="attributes"> + <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># employeenumber#</dia:string> + <dia:string># entity_id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#character varying(32)#</dia:string> + <dia:string>#integer#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -5026,10 +6558,10 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># dob#</dia:string> + <dia:string># other_name#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#date#</dia:string> + <dia:string>#text#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -5050,9 +6582,42 @@ </dia:attribute> <dia:attribute name="visible_operations"> - <dia:boolean val="false"/> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="operations"> + + <dia:composite type="umloperation"> + <dia:attribute name="name"> + <dia:string>#entity_other_name_other_name_check#</dia:string> + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="parameters"> + <dia:composite type="umlparameter"> + <dia:attribute name="name"> + <dia:string>#CHECK ((other_name ~ '[[:alnum ... ext))#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="value"> + <dia:string/> + </dia:attribute> + <dia:attribute name="kind"> + <dia:enum val="0"/> + </dia:attribute> + </dia:composite> + </dia:attribute> + </dia:composite> + </dia:attribute> - <dia:attribute name="operations"/> <dia:attribute name="template"> <dia:boolean val="false"/> @@ -5060,7 +6625,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O16"> + <dia:object type="UML - Class" version="0" id="O26"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -5256,7 +6821,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O17"> + <dia:object type="UML - Class" version="0" id="O27"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -5406,7 +6971,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O18"> + <dia:object type="UML - Class" version="0" id="O28"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -5502,11 +7067,11 @@ <dia:string># id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#integer#</dia:string> + <dia:string>#serial#</dia:string> </dia:attribute> <dia:attribute name="value"> - <dia:string>#nextval('id'::regclass)#</dia:string> + <dia:string/> </dia:attribute> <dia:attribute name="visibility"> @@ -5591,7 +7156,7 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># employee_id#</dia:string> + <dia:string># person_id#</dia:string> </dia:attribute> <dia:attribute name="type"> <dia:string>#integer#</dia:string> @@ -5671,7 +7236,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O19"> + <dia:object type="UML - Class" version="0" id="O29"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -5902,7 +7467,7 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># employee_id#</dia:string> + <dia:string># person_id#</dia:string> </dia:attribute> <dia:attribute name="type"> <dia:string>#integer#</dia:string> @@ -5959,7 +7524,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O20"> + <dia:object type="UML - Class" version="0" id="O30"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -6055,11 +7620,11 @@ <dia:string># id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#integer#</dia:string> + <dia:string>#serial#</dia:string> </dia:attribute> <dia:attribute name="value"> - <dia:string>#nextval('invoicei ... lass)#</dia:string> + <dia:string/> </dia:attribute> <dia:attribute name="visibility"> @@ -6408,7 +7973,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O21"> + <dia:object type="UML - Class" version="0" id="O31"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -6504,11 +8069,11 @@ <dia:string># id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#integer#</dia:string> + <dia:string>#serial#</dia:string> </dia:attribute> <dia:attribute name="value"> - <dia:string>#nextval('jcitemsi ... lass)#</dia:string> + <dia:string/> </dia:attribute> <dia:attribute name="visibility"> @@ -6754,7 +8319,7 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># employee_id#</dia:string> + <dia:string># person_id#</dia:string> </dia:attribute> <dia:attribute name="type"> <dia:string>#integer#</dia:string> @@ -6811,7 +8376,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O22"> + <dia:object type="UML - Class" version="0" id="O32"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -6961,7 +8526,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O23"> + <dia:object type="UML - Class" version="0" id="O33"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -6978,7 +8543,7 @@ <dia:real val="6.6000000000000005"/> </dia:attribute> <dia:attribute name="name"> - <dia:string>#makemodel#</dia:string> + <dia:string>#location#</dia:string> </dia:attribute> <dia:attribute name="comment"> @@ -7054,10 +8619,10 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># parts_id#</dia:string> + <dia:string># id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#integer#</dia:string> + <dia:string>#serial#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -7077,7 +8642,7 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># make#</dia:string> + <dia:string># line_one#</dia:string> </dia:attribute> <dia:attribute name="type"> <dia:string>#text#</dia:string> @@ -7100,7 +8665,99 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># model#</dia:string> + <dia:string># line_two#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#text#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># line_three#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#text#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># city_province#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#text#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># country_id#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#integer#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># mail_code#</dia:string> </dia:attribute> <dia:attribute name="type"> <dia:string>#text#</dia:string> @@ -7124,9 +8781,104 @@ </dia:attribute> <dia:attribute name="visible_operations"> - <dia:boolean val="false"/> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="operations"> + + <dia:composite type="umloperation"> + <dia:attribute name="name"> + <dia:string>#location_city_province_check#</dia:string> + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="parameters"> + <dia:composite type="umlparameter"> + <dia:attribute name="name"> + <dia:string>#CHECK ((city_province ~ '[[:al ... ext))#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="value"> + <dia:string/> + </dia:attribute> + <dia:attribute name="kind"> + <dia:enum val="0"/> + </dia:attribute> + </dia:composite> + </dia:attribute> + </dia:composite> + + <dia:composite type="umloperation"> + <dia:attribute name="name"> + <dia:string>#location_line_one_check#</dia:string> + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="parameters"> + <dia:composite type="umlparameter"> + <dia:attribute name="name"> + <dia:string>#CHECK ((line_one ~ '[[:alnum:] ... ext))#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="value"> + <dia:string/> + </dia:attribute> + <dia:attribute name="kind"> + <dia:enum val="0"/> + </dia:attribute> + </dia:composite> + </dia:attribute> + </dia:composite> + + <dia:composite type="umloperation"> + <dia:attribute name="name"> + <dia:string>#location_mail_code_check#</dia:string> + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="parameters"> + <dia:composite type="umlparameter"> + <dia:attribute name="name"> + <dia:string>#CHECK ((mail_code ~ '[[:alnum: ... ext))#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="value"> + <dia:string/> + </dia:attribute> + <dia:attribute name="kind"> + <dia:enum val="0"/> + </dia:attribute> + </dia:composite> + </dia:attribute> + </dia:composite> + </dia:attribute> - <dia:attribute name="operations"/> <dia:attribute name="template"> <dia:boolean val="false"/> @@ -7134,7 +8886,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O24"> + <dia:object type="UML - Class" version="0" id="O34"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -7151,7 +8903,7 @@ <dia:real val="6.6000000000000005"/> </dia:attribute> <dia:attribute name="name"> - <dia:string>#oe#</dia:string> + <dia:string>#makemodel#</dia:string> </dia:attribute> <dia:attribute name="comment"> @@ -7227,14 +8979,14 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># id#</dia:string> + <dia:string># parts_id#</dia:string> </dia:attribute> <dia:attribute name="type"> <dia:string>#integer#</dia:string> </dia:attribute> <dia:attribute name="value"> - <dia:string>#nextval('id'::regclass)#</dia:string> + <dia:string/> </dia:attribute> <dia:attribute name="visibility"> @@ -7250,7 +9002,7 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># ordnumber#</dia:string> + <dia:string># make#</dia:string> </dia:attribute> <dia:attribute name="type"> <dia:string>#text#</dia:string> @@ -7273,14 +9025,14 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># transdate#</dia:string> + <dia:string># model#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#date#</dia:string> + <dia:string>#text#</dia:string> </dia:attribute> <dia:attribute name="value"> - <dia:string>#('now'::text)::date#</dia:string> + <dia:string/> </dia:attribute> <dia:attribute name="visibility"> @@ -7294,12 +9046,116 @@ </dia:attribute> </dia:composite> + </dia:attribute> + + <dia:attribute name="visible_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="operations"/> + + <dia:attribute name="template"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="templates"/> + </dia:object> + + <dia:object type="UML - Class" version="0" id="O35"> + <dia:attribute name="obj_pos"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.05,-0.05;16.4,6.65"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="16.350000000000001"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="6.6000000000000005"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#oe#</dia:string> + </dia:attribute> + + <dia:attribute name="comment"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_attributes"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="visible_attributes"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="visible_comments"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="wrap_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="wrap_after_char"> + <dia:int val="40"/> + </dia:attribute> + <dia:attribute name="line_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="fill_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="text_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="normal_font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="abstract_font"> + <dia:font family="monospace" style="88" name="Courier"/> + </dia:attribute> + <dia:attribute name="polymorphic_font"> + <dia:font family="monospace" style="8" name="Courier"/> + </dia:attribute> + <dia:attribute name="classname_font"> + <dia:font family="sans" style="80" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font"> + <dia:font family="sans" style="88" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="comment_font"> + <dia:font family="sans" style="8" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="polymorphic_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="abstract_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="comment_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="attributes"> + <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># vendor_id#</dia:string> + <dia:string># id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#integer#</dia:string> + <dia:string>#serial#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -7319,7 +9175,53 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># customer_id#</dia:string> + <dia:string># ordnumber#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#text#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># transdate#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#date#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string>#('now'::text)::date#</dia:string> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># entity_id#</dia:string> </dia:attribute> <dia:attribute name="type"> <dia:string>#integer#</dia:string> @@ -7503,7 +9405,7 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># employee_id#</dia:string> + <dia:string># person_id#</dia:string> </dia:attribute> <dia:attribute name="type"> <dia:string>#integer#</dia:string> @@ -7731,6 +9633,29 @@ </dia:attribute> </dia:composite> + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># oe_class_id#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#integer#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + </dia:attribute> <dia:attribute name="visible_operations"> @@ -7744,7 +9669,190 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O25"> + <dia:object type="UML - Class" version="0" id="O36"> + <dia:attribute name="obj_pos"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.05,-0.05;16.4,6.65"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="16.350000000000001"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="6.6000000000000005"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#oe_class#</dia:string> + </dia:attribute> + + <dia:attribute name="comment"> + <dia:string># This could probably be done better ... tion #</dia:string> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_attributes"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="visible_attributes"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="visible_comments"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="wrap_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="wrap_after_char"> + <dia:int val="40"/> + </dia:attribute> + <dia:attribute name="line_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="fill_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="text_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="normal_font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="abstract_font"> + <dia:font family="monospace" style="88" name="Courier"/> + </dia:attribute> + <dia:attribute name="polymorphic_font"> + <dia:font family="monospace" style="8" name="Courier"/> + </dia:attribute> + <dia:attribute name="classname_font"> + <dia:font family="sans" style="80" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font"> + <dia:font family="sans" style="88" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="comment_font"> + <dia:font family="sans" style="8" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="polymorphic_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="abstract_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="comment_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="attributes"> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># id#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#smallint#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># oe_class#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#text#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + </dia:attribute> + + <dia:attribute name="visible_operations"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="operations"> + + <dia:composite type="umloperation"> + <dia:attribute name="name"> + <dia:string>#oe_class_id_check#</dia:string> + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="parameters"> + <dia:composite type="umlparameter"> + <dia:attribute name="name"> + <dia:string>#CHECK (((id = 1) OR (id = 2)))#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="value"> + <dia:string/> + </dia:attribute> + <dia:attribute name="kind"> + <dia:enum val="0"/> + </dia:attribute> + </dia:composite> + </dia:attribute> + </dia:composite> + + </dia:attribute> + + <dia:attribute name="template"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="templates"/> + </dia:object> + + <dia:object type="UML - Class" version="0" id="O37"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -7840,11 +9948,11 @@ <dia:string># id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#integer#</dia:string> + <dia:string>#serial#</dia:string> </dia:attribute> <dia:attribute name="value"> - <dia:string>#nextval('orderite ... lass)#</dia:string> + <dia:string/> </dia:attribute> <dia:attribute name="visibility"> @@ -8147,7 +10255,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O26"> + <dia:object type="UML - Class" version="0" id="O38"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -8243,11 +10351,11 @@ <dia:string># id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#integer#</dia:string> + <dia:string>#serial#</dia:string> </dia:attribute> <dia:attribute name="value"> - <dia:string>#nextval('id'::regclass)#</dia:string> + <dia:string/> </dia:attribute> <dia:attribute name="visibility"> @@ -8872,7 +10980,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O27"> + <dia:object type="UML - Class" version="0" id="O39"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -9183,7 +11291,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O28"> + <dia:object type="UML - Class" version="0" id="O40"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -9279,11 +11387,11 @@ <dia:string># id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#integer#</dia:string> + <dia:string>#serial#</dia:string> </dia:attribute> <dia:attribute name="value"> - <dia:string>#nextval('id'::regclass)#</dia:string> + <dia:string/> </dia:attribute> <dia:attribute name="visibility"> @@ -9333,7 +11441,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O29"> + <dia:object type="UML - Class" version="0" id="O41"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -9506,7 +11614,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O30"> + <dia:object type="UML - Class" version="0" id="O42"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -9599,7 +11707,7 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># vendor_id#</dia:string> + <dia:string># entity_id#</dia:string> </dia:attribute> <dia:attribute name="type"> <dia:string>#integer#</dia:string> @@ -9771,7 +11879,921 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O31"> + <dia:object type="UML - Class" version="0" id="O43"> + <dia:attribute name="obj_pos"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.05,-0.05;16.4,6.65"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="16.350000000000001"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="6.6000000000000005"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#person#</dia:string> + </dia:attribute> + + <dia:attribute name="comment"> + <dia:string># Every person, must have an entity ... _id. #</dia:string> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_attributes"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="visible_attributes"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="visible_comments"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="wrap_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="wrap_after_char"> + <dia:int val="40"/> + </dia:attribute> + <dia:attribute name="line_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="fill_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="text_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="normal_font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="abstract_font"> + <dia:font family="monospace" style="88" name="Courier"/> + </dia:attribute> + <dia:attribute name="polymorphic_font"> + <dia:font family="monospace" style="8" name="Courier"/> + </dia:attribute> + <dia:attribute name="classname_font"> + <dia:font family="sans" style="80" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font"> + <dia:font family="sans" style="88" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="comment_font"> + <dia:font family="sans" style="8" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="polymorphic_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="abstract_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="comment_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="attributes"> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># id#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#serial#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># entity_id#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#integer#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># salutation_id#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#integer#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># first_name#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#text#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># middle_name#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#text#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># last_name#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#text#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># primary_location_id#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#integer#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + </dia:attribute> + + <dia:attribute name="visible_operations"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="operations"> + + <dia:composite type="umloperation"> + <dia:attribute name="name"> + <dia:string>#person_first_name_check#</dia:string> + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="parameters"> + <dia:composite type="umlparameter"> + <dia:attribute name="name"> + <dia:string>#CHECK ((first_name ~ '[[:alnum ... ext))#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="value"> + <dia:string/> + </dia:attribute> + <dia:attribute name="kind"> + <dia:enum val="0"/> + </dia:attribute> + </dia:composite> + </dia:attribute> + </dia:composite> + + <dia:composite type="umloperation"> + <dia:attribute name="name"> + <dia:string>#person_last_name_check#</dia:string> + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="parameters"> + <dia:composite type="umlparameter"> + <dia:attribute name="name"> + <dia:string>#CHECK ((last_name ~ '[[:alnum: ... ext))#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="value"> + <dia:string/> + </dia:attribute> + <dia:attribute name="kind"> + <dia:enum val="0"/> + </dia:attribute> + </dia:composite> + </dia:attribute> + </dia:composite> + + </dia:attribute> + + <dia:attribute name="template"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="templates"/> + </dia:object> + + <dia:object type="UML - Class" version="0" id="O44"> + <dia:attribute name="obj_pos"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.05,-0.05;16.4,6.65"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="16.350000000000001"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="6.6000000000000005"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#person_to_company#</dia:string> + </dia:attribute> + + <dia:attribute name="comment"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_attributes"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="visible_attributes"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="visible_comments"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="wrap_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="wrap_after_char"> + <dia:int val="40"/> + </dia:attribute> + <dia:attribute name="line_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="fill_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="text_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="normal_font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="abstract_font"> + <dia:font family="monospace" style="88" name="Courier"/> + </dia:attribute> + <dia:attribute name="polymorphic_font"> + <dia:font family="monospace" style="8" name="Courier"/> + </dia:attribute> + <dia:attribute name="classname_font"> + <dia:font family="sans" style="80" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font"> + <dia:font family="sans" style="88" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="comment_font"> + <dia:font family="sans" style="8" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="polymorphic_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="abstract_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="comment_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="attributes"> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># location_id#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#integer#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># person_id#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#integer#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + </dia:attribute> + + <dia:attribute name="visible_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="operations"/> + + <dia:attribute name="template"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="templates"/> + </dia:object> + + <dia:object type="UML - Class" version="0" id="O45"> + <dia:attribute name="obj_pos"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.05,-0.05;16.4,6.65"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="16.350000000000001"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="6.6000000000000005"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#person_to_contact#</dia:string> + </dia:attribute> + + <dia:attribute name="comment"> + <dia:string># To keep track of the relationship ... dual #</dia:string> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_attributes"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="visible_attributes"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="visible_comments"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="wrap_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="wrap_after_char"> + <dia:int val="40"/> + </dia:attribute> + <dia:attribute name="line_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="fill_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="text_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="normal_font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="abstract_font"> + <dia:font family="monospace" style="88" name="Courier"/> + </dia:attribute> + <dia:attribute name="polymorphic_font"> + <dia:font family="monospace" style="8" name="Courier"/> + </dia:attribute> + <dia:attribute name="classname_font"> + <dia:font family="sans" style="80" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font"> + <dia:font family="sans" style="88" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="comment_font"> + <dia:font family="sans" style="8" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="polymorphic_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="abstract_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="comment_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="attributes"> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># person_id#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#integer#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># contact_class_id#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#integer#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># contact#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#text#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + </dia:attribute> + + <dia:attribute name="visible_operations"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="operations"> + + <dia:composite type="umloperation"> + <dia:attribute name="name"> + <dia:string>#person_to_contact_contact_check#</dia:string> + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="parameters"> + <dia:composite type="umlparameter"> + <dia:attribute name="name"> + <dia:string>#CHECK ((contact ~ '[[:alnum:]_ ... ext))#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="value"> + <dia:string/> + </dia:attribute> + <dia:attribute name="kind"> + <dia:enum val="0"/> + </dia:attribute> + </dia:composite> + </dia:attribute> + </dia:composite> + + </dia:attribute> + + <dia:attribute name="template"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="templates"/> + </dia:object> + + <dia:object type="UML - Class" version="0" id="O46"> + <dia:attribute name="obj_pos"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.05,-0.05;16.4,6.65"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="16.350000000000001"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="6.6000000000000005"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#person_to_entity#</dia:string> + </dia:attribute> + + <dia:attribute name="comment"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_attributes"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="visible_attributes"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="visible_comments"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="wrap_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="wrap_after_char"> + <dia:int val="40"/> + </dia:attribute> + <dia:attribute name="line_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="fill_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="text_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="normal_font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="abstract_font"> + <dia:font family="monospace" style="88" name="Courier"/> + </dia:attribute> + <dia:attribute name="polymorphic_font"> + <dia:font family="monospace" style="8" name="Courier"/> + </dia:attribute> + <dia:attribute name="classname_font"> + <dia:font family="sans" style="80" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font"> + <dia:font family="sans" style="88" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="comment_font"> + <dia:font family="sans" style="8" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="polymorphic_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="abstract_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="comment_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="attributes"> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># person_id#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#integer#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># entity_id#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#integer#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># related_how#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#text#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># created#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#date#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string>#('now'::text)::date#</dia:string> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + </dia:attribute> + + <dia:attribute name="visible_operations"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="operations"> + + <dia:composite type="umloperation"> + <dia:attribute name="name"> + <dia:string>#person_to_entity_check#</dia:string> + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="parameters"> + <dia:composite type="umlparameter"> + <dia:attribute name="name"> + <dia:string>#CHECK ((entity_id <> person_id))#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="value"> + <dia:string/> + </dia:attribute> + <dia:attribute name="kind"> + <dia:enum val="0"/> + </dia:attribute> + </dia:composite> + </dia:attribute> + </dia:composite> + + </dia:attribute> + + <dia:attribute name="template"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="templates"/> + </dia:object> + + <dia:object type="UML - Class" version="0" id="O47"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -9867,11 +12889,11 @@ <dia:string># id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#integer#</dia:string> + <dia:string>#serial#</dia:string> </dia:attribute> <dia:attribute name="value"> - <dia:string>#nextval('id'::regclass)#</dia:string> + <dia:string/> </dia:attribute> <dia:attribute name="visibility"> @@ -9921,7 +12943,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O32"> + <dia:object type="UML - Class" version="0" id="O48"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -10017,11 +13039,11 @@ <dia:string># id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#integer#</dia:string> + <dia:string>#serial#</dia:string> </dia:attribute> <dia:attribute name="value"> - <dia:string>#nextval('id'::regclass)#</dia:string> + <dia:string/> </dia:attribute> <dia:attribute name="visibility"> @@ -10232,7 +13254,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O33"> + <dia:object type="UML - Class" version="0" id="O49"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -10543,7 +13565,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O34"> + <dia:object type="UML - Class" version="0" id="O50"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -10739,7 +13761,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O35"> + <dia:object type="UML - Class" version="0" id="O51"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -10935,7 +13957,157 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O36"> + <dia:object type="UML - Class" version="0" id="O52"> + <dia:attribute name="obj_pos"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.05,-0.05;16.4,6.65"/> + </dia:attribute> + <dia:attribute name="elem_corner"> + <dia:point val="0,0"/> + </dia:attribute> + <dia:attribute name="elem_width"> + <dia:real val="16.350000000000001"/> + </dia:attribute> + <dia:attribute name="elem_height"> + <dia:real val="6.6000000000000005"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#salutation#</dia:string> + </dia:attribute> + + <dia:attribute name="comment"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_attributes"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="suppress_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="visible_attributes"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="visible_comments"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:attribute name="wrap_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="wrap_after_char"> + <dia:int val="40"/> + </dia:attribute> + <dia:attribute name="line_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="fill_color"> + <dia:color val="#ffffff"/> + </dia:attribute> + <dia:attribute name="text_color"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="normal_font"> + <dia:font family="monospace" style="0" name="Courier"/> + </dia:attribute> + <dia:attribute name="abstract_font"> + <dia:font family="monospace" style="88" name="Courier"/> + </dia:attribute> + <dia:attribute name="polymorphic_font"> + <dia:font family="monospace" style="8" name="Courier"/> + </dia:attribute> + <dia:attribute name="classname_font"> + <dia:font family="sans" style="80" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font"> + <dia:font family="sans" style="88" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="comment_font"> + <dia:font family="sans" style="8" name="Helvetica"/> + </dia:attribute> + <dia:attribute name="font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="polymorphic_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="abstract_font_height"> + <dia:real val="0.80000000000000004"/> + </dia:attribute> + <dia:attribute name="classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="abstract_classname_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="comment_font_height"> + <dia:real val="1"/> + </dia:attribute> + <dia:attribute name="attributes"> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># id#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#serial#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + <dia:composite type="umlattribute"> + <dia:attribute name="name"> + <dia:string># salutation#</dia:string> + </dia:attribute> + <dia:attribute name="type"> + <dia:string>#text#</dia:string> + </dia:attribute> + <dia:attribute name="value"> + + <dia:string/> + + </dia:attribute> + <dia:attribute name="visibility"> + <dia:enum val="3"/> + </dia:attribute> + <dia:attribute name="abstract"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="class_scope"> + <dia:boolean val="false"/> + </dia:attribute> + </dia:composite> + + </dia:attribute> + + <dia:attribute name="visible_operations"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="operations"/> + + <dia:attribute name="template"> + <dia:boolean val="false"/> + </dia:attribute> + <dia:attribute name="templates"/> + </dia:object> + + <dia:object type="UML - Class" version="0" id="O53"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -11338,7 +14510,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O37"> + <dia:object type="UML - Class" version="0" id="O54"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -11511,7 +14683,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O38"> + <dia:object type="UML - Class" version="0" id="O55"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -11730,7 +14902,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O39"> + <dia:object type="UML - Class" version="0" id="O56"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -11972,7 +15144,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O40"> + <dia:object type="UML - Class" version="0" id="O57"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -12145,7 +15317,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O41"> + <dia:object type="UML - Class" version="0" id="O58"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -12295,7 +15467,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O42"> + <dia:object type="UML - Class" version="0" id="O59"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -12445,7 +15617,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O43"> + <dia:object type="UML - Class" version="0" id="O60"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -12618,7 +15790,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O44"> + <dia:object type="UML - Class" version="0" id="O61"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -12639,7 +15811,7 @@ </dia:attribute> <dia:attribute name="comment"> - <dia:string>##</dia:string> + <dia:string># Now a meta data table #</dia:string> </dia:attribute> <dia:attribute name="abstract"> <dia:boolean val="false"/> @@ -12714,260 +15886,7 @@ <dia:string># id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#integer#</dia:string> - </dia:attribute> - <dia:attribute name="value"> - - <dia:string>#nextval('id'::regclass)#</dia:string> - - </dia:attribute> - <dia:attribute name="visibility"> - <dia:enum val="3"/> - </dia:attribute> - <dia:attribute name="abstract"> - <dia:boolean val="false"/> - </dia:attribute> - <dia:attribute name="class_scope"> - <dia:boolean val="false"/> - </dia:attribute> - </dia:composite> - - <dia:composite type="umlattribute"> - <dia:attribute name="name"> - <dia:string># name#</dia:string> - </dia:attribute> - <dia:attribute name="type"> - <dia:string>#character varying(64)#</dia:string> - </dia:attribute> - <dia:attribute name="value"> - - <dia:string/> - - </dia:attribute> - <dia:attribute name="visibility"> - <dia:enum val="3"/> - </dia:attribute> - <dia:attribute name="abstract"> - <dia:boolean val="false"/> - </dia:attribute> - <dia:attribute name="class_scope"> - <dia:boolean val="false"/> - </dia:attribute> - </dia:composite> - - <dia:composite type="umlattribute"> - <dia:attribute name="name"> - <dia:string># address1#</dia:string> - </dia:attribute> - <dia:attribute name="type"> - <dia:string>#character varying(32)#</dia:string> - </dia:attribute> - <dia:attribute name="value"> - - <dia:string/> - - </dia:attribute> - <dia:attribute name="visibility"> - <dia:enum val="3"/> - </dia:attribute> - <dia:attribute name="abstract"> - <dia:boolean val="false"/> - </dia:attribute> - <dia:attribute name="class_scope"> - <dia:boolean val="false"/> - </dia:attribute> - </dia:composite> - - <dia:composite type="umlattribute"> - <dia:attribute name="name"> - <dia:string># address2#</dia:string> - </dia:attribute> - <dia:attribute name="type"> - <dia:string>#character varying(32)#</dia:string> - </dia:attribute> - <dia:attribute name="value"> - - <dia:string/> - - </dia:attribute> - <dia:attribute name="visibility"> - <dia:enum val="3"/> - </dia:attribute> - <dia:attribute name="abstract"> - <dia:boolean val="false"/> - </dia:attribute> - <dia:attribute name="class_scope"> - <dia:boolean val="false"/> - </dia:attribute> - </dia:composite> - - <dia:composite type="umlattribute"> - <dia:attribute name="name"> - <dia:string># city#</dia:string> - </dia:attribute> - <dia:attribute name="type"> - <dia:string>#character varying(32)#</dia:string> - </dia:attribute> - <dia:attribute name="value"> - - <dia:string/> - - </dia:attribute> - <dia:attribute name="visibility"> - <dia:enum val="3"/> - </dia:attribute> - <dia:attribute name="abstract"> - <dia:boolean val="false"/> - </dia:attribute> - <dia:attribute name="class_scope"> - <dia:boolean val="false"/> - </dia:attribute> - </dia:composite> - - <dia:composite type="umlattribute"> - <dia:attribute name="name"> - <dia:string># state#</dia:string> - </dia:attribute> - <dia:attribute name="type"> - <dia:string>#character varying(32)#</dia:string> - </dia:attribute> - <dia:attribute name="value"> - - <dia:string/> - - </dia:attribute> - <dia:attribute name="visibility"> - <dia:enum val="3"/> - </dia:attribute> - <dia:attribute name="abstract"> - <dia:boolean val="false"/> - </dia:attribute> - <dia:attribute name="class_scope"> - <dia:boolean val="false"/> - </dia:attribute> - </dia:composite> - - <dia:composite type="umlattribute"> - <dia:attribute name="name"> - <dia:string># zipcode#</dia:string> - </dia:attribute> - <dia:attribute name="type"> - <dia:string>#character varying(10)#</dia:string> - </dia:attribute> - <dia:attribute name="value"> - - <dia:string/> - - </dia:attribute> - <dia:attribute name="visibility"> - <dia:enum val="3"/> - </dia:attribute> - <dia:attribute name="abstract"> - <dia:boolean val="false"/> - </dia:attribute> - <dia:attribute name="class_scope"> - <dia:boolean val="false"/> - </dia:attribute> - </dia:composite> - - <dia:composite type="umlattribute"> - <dia:attribute name="name"> - <dia:string># country#</dia:string> - </dia:attribute> - <dia:attribute name="type"> - <dia:string>#character varying(32)#</dia:string> - </dia:attribute> - <dia:attribute name="value"> - - <dia:string/> - - </dia:attribute> - <dia:attribute name="visibility"> - <dia:enum val="3"/> - </dia:attribute> - <dia:attribute name="abstract"> - <dia:boolean val="false"/> - </dia:attribute> - <dia:attribute name="class_scope"> - <dia:boolean val="false"/> - </dia:attribute> - </dia:composite> - - <dia:composite type="umlattribute"> - <dia:attribute name="name"> - <dia:string># contact#</dia:string> - </dia:attribute> - <dia:attribute name="type"> - <dia:string>#character varying(64)#</dia:string> - </dia:attribute> - <dia:attribute name="value"> - - <dia:string/> - - </dia:attribute> - <dia:attribute name="visibility"> - <dia:enum val="3"/> - </dia:attribute> - <dia:attribute name="abstract"> - <dia:boolean val="false"/> - </dia:attribute> - <dia:attribute name="class_scope"> - <dia:boolean val="false"/> - </dia:attribute> - </dia:composite> - - <dia:composite type="umlattribute"> - <dia:attribute name="name"> - <dia:string># phone#</dia:string> - </dia:attribute> - <dia:attribute name="type"> - <dia:string>#character varying(20)#</dia:string> - </dia:attribute> - <dia:attribute name="value"> - - <dia:string/> - - </dia:attribute> - <dia:attribute name="visibility"> - <dia:enum val="3"/> - </dia:attribute> - <dia:attribute name="abstract"> - <dia:boolean val="false"/> - </dia:attribute> - <dia:attribute name="class_scope"> - <dia:boolean val="false"/> - </dia:attribute> - </dia:composite> - - <dia:composite type="umlattribute"> - <dia:attribute name="name"> - <dia:string># fax#</dia:string> - </dia:attribute> - <dia:attribute name="type"> - <dia:string>#character varying(20)#</dia:string> - </dia:attribute> - <dia:attribute name="value"> - - <dia:string/> - - </dia:attribute> - <dia:attribute name="visibility"> - <dia:enum val="3"/> - </dia:attribute> - <dia:attribute name="abstract"> - <dia:boolean val="false"/> - </dia:attribute> - <dia:attribute name="class_scope"> - <dia:boolean val="false"/> - </dia:attribute> - </dia:composite> - - <dia:composite type="umlattribute"> - <dia:attribute name="name"> - <dia:string># email#</dia:string> - </dia:attribute> - <dia:attribute name="type"> - <dia:string>#text#</dia:string> + <dia:string>#serial#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -12987,10 +15906,10 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># notes#</dia:string> + <dia:string># entity_id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#text#</dia:string> + <dia:string>#integer#</dia:string> </dia:attribute> <dia:attribute name="value"> @@ -13309,29 +16228,6 @@ <dia:composite type="umlattribute"> <dia:attribute name="name"> - <dia:string># employee_id#</dia:string> - </dia:attribute> - <dia:attribute name="type"> - <dia:string>#integer#</dia:string> - </dia:attribute> - <dia:attribute name="value"> - - <dia:string/> - - </dia:attribute> - <dia:attribute name="visibility"> - <dia:enum val="3"/> - </dia:attribute> - <dia:attribute name="abstract"> - <dia:boolean val="false"/> - </dia:attribute> - <dia:attribute name="class_scope"> - <dia:boolean val="false"/> - </dia:attribute> - </dia:composite> - - <dia:composite type="umlattribute"> - <dia:attribute name="name"> <dia:string># language_code#</dia:string> </dia:attribute> <dia:attribute name="type"> @@ -13458,7 +16354,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O45"> + <dia:object type="UML - Class" version="0" id="O62"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -13608,7 +16504,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O46"> + <dia:object type="UML - Class" version="0" id="O63"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -13704,11 +16600,11 @@ <dia:string># id#</dia:string> </dia:attribute> <dia:attribute name="type"> - <dia:string>#integer#</dia:string> + <dia:string>#serial#</dia:string> </dia:attribute> <dia:attribute name="value"> - <dia:string>#nextval('id'::regclass)#</dia:string> + <dia:string/> </dia:attribute> <dia:attribute name="visibility"> @@ -13758,7 +16654,7 @@ <dia:attribute name="templates"/> </dia:object> - <dia:object type="UML - Class" version="0" id="O47"> + <dia:object type="UML - Class" version="0" id="O64"> <dia:attribute name="obj_pos"> <dia:point val="0,0"/> </dia:attribute> @@ -13911,7 +16807,7 @@ - <dia:object type="UML - Dependency" version="0" id="O48"> + <dia:object type="UML - Dependency" version="0" id="O65"> <dia:attribute name="obj_pos"> <dia:point val="0,3.5"/> </dia:attribute> @@ -13949,7 +16845,7 @@ </dia:connections> </dia:object> - <dia:object type="UML - Dependency" version="0" id="O49"> + <dia:object type="UML - Dependency" version="0" id="O66"> <dia:attribute name="obj_pos"> <dia:point val="0,3.5"/> </dia:attribute> @@ -13973,7 +16869,197 @@ <dia:color val="#000000"/> </dia:attribute> <dia:attribute name="name"> - <dia:string>#custom_field_catalog_table_id_fkey#</dia:string> + <dia:string>#ap_entity_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O2" connection="14"/> + <dia:connection handle="1" to="O22" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O67"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#ap_person_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O2" connection="36"/> + <dia:connection handle="1" to="O43" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O68"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#ar_entity_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O3" connection="14"/> + <dia:connection handle="1" to="O22" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O69"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#ar_person_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O3" connection="40"/> + <dia:connection handle="1" to="O43" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O70"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#audittrail_person_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O5" connection="20"/> + <dia:connection handle="1" to="O43" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O71"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#company_entity_id_fkey#</dia:string> </dia:attribute> <dia:attribute name="stereotype"> <dia:string>##</dia:string> @@ -13983,11 +17069,847 @@ </dia:attribute> <dia:connections> <dia:connection handle="0" to="O8" connection="10"/> - <dia:connection handle="1" to="O9" connection="9"/> + <dia:connection handle="1" to="O22" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O72"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#company_entity_class_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O8" connection="14"/> + <dia:connection handle="1" to="O23" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O73"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#company_primary_location_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O8" connection="16"/> + <dia:connection handle="1" to="O33" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O74"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#company_to_contact_company_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O9" connection="8"/> + <dia:connection handle="1" to="O8" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O75"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#company_to_contact_contact_class_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O9" connection="10"/> + <dia:connection handle="1" to="O12" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O76"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#company_to_entity_company_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O10" connection="8"/> + <dia:connection handle="1" to="O8" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O77"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#company_to_entity_entity_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O10" connection="10"/> + <dia:connection handle="1" to="O22" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O78"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#company_to_location_location_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O11" connection="8"/> + <dia:connection handle="1" to="O33" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O79"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#company_to_location_company_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O11" connection="10"/> + <dia:connection handle="1" to="O8" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O80"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#custom_field_catalog_table_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O14" connection="10"/> + <dia:connection handle="1" to="O15" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O81"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#customer_entity_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O16" connection="10"/> + <dia:connection handle="1" to="O22" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O82"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#employee_entity_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O21" connection="10"/> + <dia:connection handle="1" to="O22" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O83"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#entity_entity_class_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O22" connection="12"/> + <dia:connection handle="1" to="O23" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O84"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#entity_class_to_entity_entity_class_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O24" connection="8"/> + <dia:connection handle="1" to="O23" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O85"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#entity_class_to_entity_entity_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O24" connection="10"/> + <dia:connection handle="1" to="O22" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O86"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#entity_other_name_entity_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O25" connection="8"/> + <dia:connection handle="1" to="O22" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O87"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#gl_person_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O28" connection="16"/> + <dia:connection handle="1" to="O43" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O88"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#inventory_person_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O29" connection="20"/> + <dia:connection handle="1" to="O43" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O89"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#jcitems_person_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O31" connection="30"/> + <dia:connection handle="1" to="O43" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O90"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#location_country_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O33" connection="18"/> + <dia:connection handle="1" to="O13" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O91"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#oe_entity_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O35" connection="14"/> + <dia:connection handle="1" to="O22" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O92"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#oe_person_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O35" connection="30"/> + <dia:connection handle="1" to="O43" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O93"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#oe_oe_class_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O35" connection="50"/> + <dia:connection handle="1" to="O36" connection="9"/> </dia:connections> </dia:object> - <dia:object type="UML - Dependency" version="0" id="O50"> + <dia:object type="UML - Dependency" version="0" id="O94"> <dia:attribute name="obj_pos"> <dia:point val="0,3.5"/> </dia:attribute> @@ -14020,12 +17942,12 @@ <dia:boolean val="true"/> </dia:attribute> <dia:connections> - <dia:connection handle="0" to="O29" connection="8"/> - <dia:connection handle="1" to="O26" connection="9"/> + <dia:connection handle="0" to="O41" connection="8"/> + <dia:connection handle="1" to="O38" connection="9"/> </dia:connections> </dia:object> - <dia:object type="UML - Dependency" version="0" id="O51"> + <dia:object type="UML - Dependency" version="0" id="O95"> <dia:attribute name="obj_pos"> <dia:point val="0,3.5"/> </dia:attribute> @@ -14058,12 +17980,12 @@ <dia:boolean val="true"/> </dia:attribute> <dia:connections> - <dia:connection handle="0" to="O29" connection="10"/> + <dia:connection handle="0" to="O41" connection="10"/> <dia:connection handle="1" to="O7" connection="9"/> </dia:connections> </dia:object> - <dia:object type="UML - Dependency" version="0" id="O52"> + <dia:object type="UML - Dependency" version="0" id="O96"> <dia:attribute name="obj_pos"> <dia:point val="0,3.5"/> </dia:attribute> @@ -14096,12 +18018,392 @@ <dia:boolean val="true"/> </dia:attribute> <dia:connections> - <dia:connection handle="0" to="O29" connection="12"/> - <dia:connection handle="1" to="O40" connection="9"/> + <dia:connection handle="0" to="O41" connection="12"/> + <dia:connection handle="1" to="O57" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O97"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#partsvendor_entity_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O42" connection="8"/> + <dia:connection handle="1" to="O22" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O98"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#person_entity_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O43" connection="10"/> + <dia:connection handle="1" to="O22" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O99"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#person_salutation_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O43" connection="12"/> + <dia:connection handle="1" to="O52" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O100"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#person_primary_location_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O43" connection="20"/> + <dia:connection handle="1" to="O33" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O101"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#person_to_company_location_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O44" connection="8"/> + <dia:connection handle="1" to="O33" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O102"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#person_to_company_person_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O44" connection="10"/> + <dia:connection handle="1" to="O43" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O103"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#person_to_contact_person_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O45" connection="8"/> + <dia:connection handle="1" to="O43" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O104"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#person_to_contact_contact_class_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O45" connection="10"/> + <dia:connection handle="1" to="O12" connection="9"/> </dia:connections> </dia:object> - <dia:object type="UML - Dependency" version="0" id="O53"> + <dia:object type="UML - Dependency" version="0" id="O105"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#person_to_entity_person_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O46" connection="8"/> + <dia:connection handle="1" to="O43" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O106"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#person_to_entity_entity_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O46" connection="10"/> + <dia:connection handle="1" to="O22" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O107"> <dia:attribute name="obj_pos"> <dia:point val="0,3.5"/> </dia:attribute> @@ -14134,12 +18436,12 @@ <dia:boolean val="true"/> </dia:attribute> <dia:connections> - <dia:connection handle="0" to="O39" connection="8"/> + <dia:connection handle="0" to="O56" connection="8"/> <dia:connection handle="1" to="O7" connection="9"/> </dia:connections> </dia:object> - <dia:object type="UML - Dependency" version="0" id="O54"> + <dia:object type="UML - Dependency" version="0" id="O108"> <dia:attribute name="obj_pos"> <dia:point val="0,3.5"/> </dia:attribute> @@ -14172,12 +18474,12 @@ <dia:boolean val="true"/> </dia:attribute> <dia:connections> - <dia:connection handle="0" to="O39" connection="18"/> - <dia:connection handle="1" to="O41" connection="9"/> + <dia:connection handle="0" to="O56" connection="18"/> + <dia:connection handle="1" to="O58" connection="9"/> </dia:connections> </dia:object> - <dia:object type="UML - Dependency" version="0" id="O55"> + <dia:object type="UML - Dependency" version="0" id="O109"> <dia:attribute name="obj_pos"> <dia:point val="0,3.5"/> </dia:attribute> @@ -14210,8 +18512,46 @@ <dia:boolean val="true"/> </dia:attribute> <dia:connections> - <dia:connection handle="0" to="O40" connection="12"/> - <dia:connection handle="1" to="O41" connection="9"/> + <dia:connection handle="0" to="O57" connection="12"/> + <dia:connection handle="1" to="O58" connection="9"/> + </dia:connections> + </dia:object> + + <dia:object type="UML - Dependency" version="0" id="O110"> + <dia:attribute name="obj_pos"> + <dia:point val="0,3.5"/> + </dia:attribute> + <dia:attribute name="obj_bb"> + <dia:rectangle val="-0.0515705,2.29861;25.1127,3.55157"/> + </dia:attribute> + <dia:attribute name="orth_points"> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + <dia:point val="1.0,1.0"/> + </dia:attribute> + <dia:attribute name="orth_orient"> + <dia:enum val="1"/> + <dia:enum val="0"/> + </dia:attribute> + <dia:attribute name="orth_autoroute"> + <dia:boolean val="true"/> + </dia:attribute> + + <dia:attribute name="line_colour"> + <dia:color val="#000000"/> + </dia:attribute> + <dia:attribute name="name"> + <dia:string>#vendor_entity_id_fkey#</dia:string> + </dia:attribute> + <dia:attribute name="stereotype"> + <dia:string>##</dia:string> + </dia:attribute> + <dia:attribute name="draw_arrow"> + <dia:boolean val="true"/> + </dia:attribute> + <dia:connections> + <dia:connection handle="0" to="O61" connection="10"/> + <dia:connection handle="1" to="O22" connection="9"/> </dia:connections> </dia:object> |