ziptocity Table (16)
•
Environment: onsite, online
Some tooltip text!
• 1 minute to read
• 1 minute to read
Zip codes and city names. Zip codes used during address entry. You will find more information about addressformat on http;//techdoc.superoffice.com
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| ziptocity_id | Primary key | PK | |
| country_id | Country this zip table is valid for | FK country | ● |
| zipcode | Zipcode | String(11) | |
| city | City field | String(79) | |
| updatedCount | Number of updates made to this record | UShort |
Indexes
| Fields | Types | Description |
|---|---|---|
| ziptocity_id | PK | Clustered, Unique |
| city | String(79) | Index |
| country_id, zipcode | FK, String(11) | Index |
Relationships
| Table | Description |
|---|---|
| country | Country information |
Replication Flags
- Replicate changes DOWN from central to satellites and travellers.
- Replicate changes UP from satellites and travellers back to central.
- Copy to satellite and travel prototypes.
Security Flags
- No access control via user's Role.