AO Logo
 
  
  
  
Schema Columns
AO
AO Industries, Inc.
Application Infrastructure ProviderApplication Infrastructure Provider
Sign UpWhat's NewClient AreaContact UsSite Map
 
your location:   home page ··· aoserv platform ··· software components ··· aoserv client ··· tables ··· table definitions ··· schema columns

TABLE NAME

schema_columns

DESCRIPTION

schema_columns stores the details about the data contained in each column.

COLUMNS

columntypenulluniquereferencesreferenced_bysince_versiondescription
idpkeyfalsetrueschema_foreign_keys.column
schema_foreign_keys.foreignColumn
1.81.18a generated unique pkey
tablestringfalsefalseschema_tables.name1.81.18the name of the table the column is in
namestringfalsefalse1.81.18the name of the column
sinceVersionstringfalsefalseaoserv_protocols.version1.81.18the first aoserv_protocol version this column was in
lastVersionstringtruefalseaoserv_protocols.version1.81.18the last version containing this field
indexshortfalsefalse1.81.18the index of the column
typestringfalsefalseschema_types.name1.0a100the type of data in the column
isNullablebooleanfalsefalse1.81.18if the value may be null
isUniquebooleanfalsefalse1.81.18if true, the value is unique across rows
isPublicbooleanfalsefalse1.81.18if the value is publicly accessible
descriptionstringfalsefalse1.0a100any description associated with the column