Data Model Diagrams

Customer – Lessee – Lease – Asset

-----------------------                ------------------------------------
|   rcu Customer      |     cus_s      |   vrcx_cus Customer Short Name   |
|=====================|----------------|==================================|
|   cus_s: customer   |                |   cus_s: customer                |
-----------------------                ------------------------------------
   |        |                                            |
   |        |                                            |
   |        | cus_s    -----------------------     cus_s |
   |        +--------->|   ral Lessee        |<----------+        ----------------------------------
   |                   |=====================|                    |   vrcx_les Lessee Short Name   |
   |                   |   les_s: lessee     |       les_s        |================================|
   |                   |   cus_s: customer   |--------------------|   les_s: lessee                |
   |                   -----------------------                    ----------------------------------
   |                              |                                                |
   |                              |                                                |
   |                              | les_s    -----------------------         les_s |
   |                              +--------->|   rls Lease         |<--------------+
   |                                         |=====================|
   | cus_s                                   |   lse_s: lease      |
   +---------------------------------------->|   les_s: lessee     |
                                             |   cus_s: customer   |
                                             -----------------------
                                                        |
                                                        |
                                                        |          --------------------
                                                        | lse_s    |   req Asset      |
                                                        +--------->|==================|
                                                                   |   lse_s: lease   |
                                                                   |   unit_s: unit   |
                                                                   --------------------

A join with the rls table on rls.cus_s is non-indexed and requires a search of the entire rls table.