0a	�(�OBJECTIDI
PARENTIDIOBJECTTYPEC	
OBJECTNAMEC�PROPERTYM�CODEM�RIINFOC�USERM�
 

Database  Database                                                                                                                               
Database  TransactionLog                                                                                                                         
Database  StoredProceduresSource                                                                                                                 
Database  StoredProceduresObject                                                                                                                 
Table     customer                                                                                                                        d       
Table     products                                                                                                                        �       
Table     orditems                                                                                                                               
Table     orders                                                                                                                          y       	
Table     employee                                                                                                                        n       
Index     company                                                                                                                                Index     contact                                                                                                                                Index     postalcode                                                                                                                             
Index     cust_id                                                                                                                                Relation  cust_id                                                                                                                                Index     emp_id                                                                                                                                 Relation  emp_id                                                                                                                                 Index     order_id                                                                                                                               Relation  order_id                                                                                                                               Index     product_id                                                                                                                             Relation  product_id                                                                                                                             Index     product_id                                                                                                                             Index     order_id                                                                                                                               	Field     emp_id                                                                                                                          p       	Field     last_name                                                                                                                              	Field     first_name                                                                                                                             	Field     title                                                                                                                                  	Field     birth_date                                                                                                                             	Field     hire_date                                                                                                                              	Field     address                                                                                                                                	Field     city                                                                                                                                   	Field     region                                                                                                                          q        	Field     postalcode                                                                                                                      s       !	Field     country                                                                                                                                "	Field     home_phone                                                                                                                             #	Field     extension                                                                                                                              $	Field     photo                                                                                                                           w       %	Field     notes                                                                                                                                  &	Field     reports_to                                                                                                                      u       '	Index     emp_id                                                                                                                                 (Field     cust_id                                                                                                                         f       )Field     company                                                                                                                                *Field     contact                                                                                                                         h       +Field     title                                                                                                                                  ,Field     address                                                                                                                                -Field     city                                                                                                                                   .Field     region                                                                                                                          i       /Field     postalcode                                                                                                                      k       0Field     country                                                                                                                                1Field     phone                                                                                                                                  2Field     fax                                                                                                                                    3Field     maxordamt                                                                                                                       m       4Index     cust_id                                                                                                                                5
Database  StoredProceduresDependencies                                                                                                           6
View      invoice                                                                                                                                76Field     cust_id_a                                                                                                                       (       86Field     company                                                                                                                         )       96Field     contact                                                                                                                         *       :6Field     title                                                                                                                           +       ;6Field     address                                                                                                                         ,       <6Field     city                                                                                                                            -       =6Field     region                                                                                                                          .       >6Field     postalcode_a                                                                                                                    /       ?6Field     country                                                                                                                         0       @6Field     phone                                                                                                                           1       A6Field     fax                                                                                                                             2       B6Field     maxordamt                                                                                                                       3       C6Field     order_id_a                                                                                                                      4       D6Field     cust_id_b                                                                                                                       5       E6Field     emp_id                                                                                                                          6       F6Field     to_name                                                                                                                         7       G6Field     to_address                                                                                                                      8       H6Field     to_city                                                                                                                         9       I6Field     to_region                                                                                                                       :       J6Field     postalcode_b                                                                                                                    ;       K6Field     to_country                                                                                                                      <       L6Field     ship_count                                                                                                                      =       M6Field     ship_via                                                                                                                        >       N6Field     order_date                                                                                                                      ?       O6Field     order_amt                                                                                                                       @       P6Field     order_dsc                                                                                                                       A       Q6Field     order_net                                                                                                                       B       R6Field     require_by                                                                                                                      C       S6Field     shipped_on                                                                                                                      D       T6Field     freight                                                                                                                         E       U6Field     line_no                                                                                                                         F       V6Field     order_id_b                                                                                                                      G       W6Field     product_id_a                                                                                                                    H       X6Field     unit_price_a                                                                                                                    I       Y6Field     quantity                                                                                                                        J       Z6Field     product_id_b                                                                                                                    K       [6Field     prod_name                                                                                                                       L       \6Field     eng_name                                                                                                                        M       ]6Field     no_in_unit                                                                                                                      N       ^6Field     unit_price_b                                                                                                                    O       _6Field     unit_cost                                                                                                                       P       `6Field     in_stock                                                                                                                        Q       a6Field     on_order                                                                                                                        R       b6Field     reorder_at                                                                                                                      S       c6Field     discontinu                                                                                                                      '       dIndex     country                                                                                                                                e
View      customers in specific country                                                                                                   ^       feField     cust_id                                                                                                                         \       geField     company                                                                                                                         Z       heField     contact                                                                                                                         X       ieField     title                                                                                                                           V       jeField     country                                                                                                                         T       kField     order_id                                                                                                                        {       lField     cust_id                                                                                                                         |       mField     emp_id                                                                                                                          ~       nField     to_name                                                                                                                         �       oField     to_address                                                                                                                      �       pField     to_city                                                                                                                         �       qField     to_region                                                                                                                       �       rField     postalcode                                                                                                                      �       sField     to_country                                                                                                                      �       tField     ship_count                                                                                                                             uField     ship_via                                                                                                                        �       vField     order_date                                                                                                                             wField     order_amt                                                                                                                       �       xField     order_dsc                                                                                                                       �       yField     order_net                                                                                                                       �       zField     require_by                                                                                                                      �       {Field     shipped_on                                                                                                                      �       |Field     freight                                                                                                                         �       }Field     line_no                                                                                                                                ~Field     order_id                                                                                                                        �       Field     product_id                                                                                                                      �       �Field     unit_price                                                                                                                      �       �Field     quantity                                                                                                                        �       �Field     product_id                                                                                                                      �       �Field     prod_name                                                                                                                              �Field     eng_name                                                                                                                               �Field     no_in_unit                                                                                                                      �       �Field     unit_price                                                                                                                      �       �Field     unit_cost                                                                                                                       �       �Field     in_stock                                                                                                                        �       �Field     on_order                                                                                                                               �Field     reorder_at                                                                                                                      	       �Field     discontinu                                                                                                                      �