Previous Topic: ca_contact_type TableNext Topic: ca_job_function Table


ca_country Table

Country name/code/description information (CA-MDB).

Field

Data Type

Reference

Remarks

country_code

INTEGER

 

Identifies the country code ID.

creation_date

INTEGER

 

Specifies the date that the record was created.

creation_user

nvarchar(64)

 

Specifies the user or process that created the record.

description

nvarchar
(255)

 

Specifies the textual country description.

id

INTEGER

 

Identifies the unique (to the table) numeric ID.
Note: This is a Primary key.

inactive

INTEGER

Active_Boolean_
Table::enum

Sets the Active flag, as follows:
0—False (Active)
1—True (Inactive)

last_update_
date

INTEGER

 

Shows the date of when this record was last updated.

last_update_
user

nvarchar(64)

 

Identifies the user or process that last updated the record.

name

varchar(100)

 

Identifies the unique country name.

phone_mask

nvarchar(60)

 

Specifies the Phone mask of the given country, for example, (###)###-####x################).

version_number

INTEGER

 

Specifies the version number for transaction integrity.