Table Name: | csc_country |
Table Number: | 5118 |
Group: | Exchange Mgr |
Description: | Country object which defines each country |
Flags: | |
Baseline/Custom: | Baseline |
Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
---|---|---|---|---|---|---|---|---|
code | LONG | int | DIRECT | Country code used in telephone numbers for that country | ||||
dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
is_default | LONG | int | 22 | 0 | DIRECT | Indicates that this is the default country | ||
name | CHAR | varchar | 2 | 40 | Name of the specific country | |||
objid | LONG | int | 3 | DIRECT | Internal record number | |||
server_id | LONG | int | DIRECT | Exchange protocol server ID number |
Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
---|---|---|---|---|---|---|---|
country2csc_address | OTM | csc_address | address2csc_country | Addresses that belong to the country | |||
country2csc_state_prov | OTM | csc_state_prov | state_prov2csc_country | States or provices which belong to the country | |||
country2csc_tzone | MTM | csc_tzone | time2csc_country | Time zones which are related to the country | mtm_csc_country1_ csc_tzone0 |
Index Name | Fields | Flags |
---|---|---|
name_index | server_id:name | UNIQUE |
Index Name | Fields | Additional Information |
---|---|---|
name_index | server_id, name | nonclustered, unique located on PRIMARY |
objindex | objid | clustered, unique located on PRIMARY |
View ID | View Name | Tables |
---|
csc_country | |||