Asset – Location Name
LeasePak Documentation Suite NETSOL website
Asset

Data Model Diagrams

Asset – Location Name

-------------------                 st_s                 ----------------------------
|   req Asset     |<-------------------------------------|   rst State              |
|=================|                                      |==========================|
|   st_s: state   |<--------------------+                |   st_s: state            |
|   ct_s: county  |                     |                |   st_nam_s: state name   |
|   cy_s: city    |<-------------+      |                ----------------------------
-------------------              |      |
                                 |      |
                                 |      |                ------------------------------
                                 |      |                |   mlo_county County        |
                                 |      | st_s, ct_s     |============================|
                                 |      +----------------|   st_s: state              |
                                 |                       |   ct_s: county             |
                                 |                       |   loc_nam_s: county name   |
                                 |                       ------------------------------
                                 |
                                 |
                                 |                       ----------------------------
                                 |                       |   mlo_city City          |
                                 | st_s, ct_s, cy_s      |==========================|
                                 +-----------------------|   st_s: state            |
                                                         |   ct_s: county           |
                                                         |   cy_s: city             |
                                                         |   loc_nam_s: city name   |
                                                         ----------------------------

Information note:   These relationships are applicable to all tables containing state, county, and city codes.