Class TableFieldSchema
Inheritance
System.Object
TableFieldSchema
Implements
Google.Apis.Requests.IDirectResponseSchema
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Assembly: Google.Apis.Bigquery.v2.dll
Syntax
public class TableFieldSchema : IDirectResponseSchema
Properties
Categories
[Optional] The categories attached to this field, used for field-level access control.
Declaration
[JsonProperty("categories")]
public virtual TableFieldSchema.CategoriesData Categories { get; set; }
Property Value
CollationSpec
Optional. Collation specification of the field. It only can be set on string type field.
Declaration
[JsonProperty("collationSpec")]
public virtual string CollationSpec { get; set; }
Property Value
Type |
Description |
System.String |
|
Description
[Optional] The field description. The maximum length is 1,024 characters.
Declaration
[JsonProperty("description")]
public virtual string Description { get; set; }
Property Value
Type |
Description |
System.String |
|
ETag
Declaration
public virtual string ETag { get; set; }
Property Value
Type |
Description |
System.String |
|
Fields
[Optional] Describes the nested schema fields if the type property is set to RECORD.
Declaration
[JsonProperty("fields")]
public virtual IList<TableFieldSchema> Fields { get; set; }
Property Value
MaxLength
[Optional] Maximum length of values of this field for STRINGS or BYTES. If max_length is not specified, no
maximum length constraint is imposed on this field. If type = "STRING", then max_length represents the
maximum UTF-8 length of strings in this field. If type = "BYTES", then max_length represents the maximum
number of bytes in this field. It is invalid to set this field if type ≠ "STRING" and ≠ "BYTES".
Declaration
[JsonProperty("maxLength")]
public virtual long? MaxLength { get; set; }
Property Value
Type |
Description |
System.Nullable<System.Int64> |
|
Mode
[Optional] The field mode. Possible values include NULLABLE, REQUIRED and REPEATED. The default value is
NULLABLE.
Declaration
[JsonProperty("mode")]
public virtual string Mode { get; set; }
Property Value
Type |
Description |
System.String |
|
Name
[Required] The field name. The name must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_),
and must start with a letter or underscore. The maximum length is 300 characters.
Declaration
[JsonProperty("name")]
public virtual string Name { get; set; }
Property Value
Type |
Description |
System.String |
|
Declaration
[JsonProperty("policyTags")]
public virtual TableFieldSchema.PolicyTagsData PolicyTags { get; set; }
Property Value
Precision
[Optional] Precision (maximum number of total digits in base 10) and scale (maximum number of digits in the
fractional part in base 10) constraints for values of this field for NUMERIC or BIGNUMERIC. It is invalid to
set precision or scale if type ≠ "NUMERIC" and ≠ "BIGNUMERIC". If precision and scale are not specified, no
value range constraint is imposed on this field insofar as values are permitted by the type. Values of this
NUMERIC or BIGNUMERIC field must be in this range when: - Precision (P) and scale (S) are specified: [-10P-S
- 10-S, 10P-S - 10-S] - Precision (P) is specified but not scale (and thus scale is interpreted to be equal
to zero): [-10P + 1, 10P - 1]. Acceptable values for precision and scale if both are specified: - If type =
"NUMERIC": 1 ≤ precision - scale ≤ 29 and 0 ≤ scale ≤ 9. - If type = "BIGNUMERIC": 1 ≤ precision - scale ≤
38 and 0 ≤ scale ≤ 38. Acceptable values for precision if only precision is specified but not scale (and
thus scale is interpreted to be equal to zero): - If type = "NUMERIC": 1 ≤ precision ≤ 29. - If type =
"BIGNUMERIC": 1 ≤ precision ≤ 38. If scale is specified but not precision, then it is invalid.
Declaration
[JsonProperty("precision")]
public virtual long? Precision { get; set; }
Property Value
Type |
Description |
System.Nullable<System.Int64> |
|
Scale
[Optional] See documentation for precision.
Declaration
[JsonProperty("scale")]
public virtual long? Scale { get; set; }
Property Value
Type |
Description |
System.Nullable<System.Int64> |
|
Type
[Required] The field data type. Possible values include STRING, BYTES, INTEGER, INT64 (same as INTEGER),
FLOAT, FLOAT64 (same as FLOAT), NUMERIC, BIGNUMERIC, BOOLEAN, BOOL (same as BOOLEAN), TIMESTAMP, DATE, TIME,
DATETIME, INTERVAL, RECORD (where RECORD indicates that the field contains a nested schema) or STRUCT (same
as RECORD).
Declaration
[JsonProperty("type")]
public virtual string Type { get; set; }
Property Value
Type |
Description |
System.String |
|
Implements
Google.Apis.Requests.IDirectResponseSchema