Previous Topic: ca_contact TableNext Topic: ca_country Table


ca_contact_type Table

Definitions of type/classifications of personal information stored in the ca_contact table (CA-MDB).

Field

Data Type

Reference

Remarks

creation_date

INTEGER

 

Specifies the date when this record was created.

creation_user

nvarchar(64)

 

Identifies the user or process that created this record.

delete_time

INTEGER

 

Specifies the delete time.

description

nvarchar
(255)

 

Specifies the textual, contact type description.

exclude_ registration

INTEGER

 

Indicates to exclude registration.

hourly_cost

Money

 

Specifies the hourly cost.

id

INTEGER

 

Unique (to the table), numeric contact type ID.
Note: This is a Primary key.

inactive

INTEGER

Active_Boolean_
Table::enum

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

last_update_date

INTEGER

 

Specifies 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

nvarchar
(100)

 

Identifies the unique,contact type name.

user_uuid

UUID

ca_contact:: uuid

This is a unique identifier.
Note: This is also the Primary key.

version_number

INTEGER

 

Version number for transaction integrity.

view_internal

INTEGER

 

Flag to represent whether this contact type is allowed to view internal data.