Data Model Diagrams

Lease – P/C/R/O Name

------------------------                                  -------------------------------
|   rls Lease          |               por_s              |   vrnm_por Portfolio Name   |
|======================|<---------------------------------|=============================|
|   por_s: portfolio   |<------------------+              |   por_s: portfolio          |
|   com_s: company     |<------------+     |              |   nam_s: portfolio name     |
|   reg_s: region      |<------+     |     |              -------------------------------
|   off_s: office      |       |     |     |
------------------------       |     |     |
                               |     |     |              -----------------------------
                               |     |     |              |   vrnm_com Company Name   |
                               |     |     | p/c          |===========================|
                               |     |     +--------------|   por_s: portfolio        |
                               |     |                    |   com_s: company          |
                               |     |                    |   nam_s: company name     |
                               |     |                    -----------------------------
                               |     |
                               |     |
                               |     |                    ----------------------------
                               |     |                    |   vrnm_reg Region Name   |
                               |     | p/c/r              |==========================|
                               |     +--------------------|   por_s: portfolio       |
                               |                          |   com_s: company         |
                               |                          |   reg_s: region          |
                               |                          |   nam_s: region name     |
                               |                          ----------------------------
                               |
                               |
                               |                          ----------------------------
                               |                          |   vrnm_off Office Name   |
                               |                          |==========================|
                               | p/c/r/o                  |   por_s: portfolio       |
                               +--------------------------|   com_s: company         |
                                                          |   reg_s: region          |
                                                          |   off_s: office          |
                                                          |   nam_s: office name     |
                                                          ----------------------------

  These relationships are applicable to all tables containing Portfolio, Company, Region, and Office.