ca_country

Contains a list of countries and related information

Column Name Column Datatype Column Null Option Column Comment
id integer not null Primary key. Country id.
inactive integer not null Flag representing whether this record is active or inactive. 0=False (Active), 1=True (Inactive)
name nvarchar(100) not null Country name. Unique.
country_code integer with null Country code id.
phone_mask nvarchar(60) with null Phone mask of the given country (e.g. (###)###-####x################).
description nvarchar(255) with null Country description.
creation_user nvarchar(64) with null User or process that created the record.
creation_date integer with null Date the record was created.
last_update_user nvarchar(64) with null User or process that last updated the record.
last_update_date integer with null Date the record was last updated.
version_number integer with null Version number for transaction integrity.

Product Name: Asset

Table Type: Table


Copyright © 2006 CA. All rights reserved.