Field 1 - Teradata Vantage

Fixed length. Includes:

• Row 1 header.
• Offset array for the variable length columns in the table header, Used to locate those columns.
• Table header row format version.
• Internal ID of the database to which this table belongs.
• Internal ID of the database to which space for this table is charged.
• Table creation timestamp.
• Last table update timestamp.
• Last table archive timestamp.
• Primary index flag.
• Table structure version. Updated each time the table description is modified
• Number of backup tables associated with this table.
• Internal ID of the permanent journal table.
• Table kind. Describes whether the table is permanent, temporary, volatile, or a join index. For temporary tables, volatile tables, and join indexes, also describes preserve-on-commit and transient journaling characteristics.
• Journal type:
  • After
  • Audit
  • Both
  • Before
  • None
• Protection type:
  • Fallback
  • Log
  • None
• User journal flag. Describes whether the table is a user-defined journal or not.
• Hash flag. Describes whether table is hashed or not.
• Dropped flag. Set TRUE from the time the AMP gets a Drop Table step until the table is dropped in the End Transaction step. Otherwise set FALSE.
• DDL change flag.Prevents attempts to update the table after its DDL has changed. Set TRUE when table DDL is modified.
• Byte count of the number of USIs defined on the table.
• Host character set at the time the table was created.
• Number of parent tables referenced by this table.
• Number of child tables referencing this table.
• Merge block ratio for the table.
• Merge block ratio validity. Indicates whether the specified merge block ratio for the table is valid or unspecified.
• Data block size for the table in bytes.
• Data block size validity. Indicates whether the specified data block size for the table is valid or unspecified.
• Percent free space for the table.
• Percent free space validity. Indicates whether the specified percent free space for the table is valid or unspecified.
• Disk I/O integrity checksum. Used to verify the integrity of user tables, join indexes, and secondary indexes.
• Message class of primary step.
• Message kind of primary step.
• Message class of secondary step.
• Message kind of secondary step.
• Host ID.
• Session number.
• Request number.
• Transaction number.
• Table ID of base temporary table. Used only for materialized temporary tables.
• Internal ID for primary key index.
• Restart flag. Tracks restart and non-restart cases of restore jobs during build phase.
• Row format, which specifies whether current environment is packed64 format or aligned row format.
• Dummy space.
• List of index descriptors for the table in Index ID order, one per primary and secondary index defined on the table.
• Row 1 length. Duplicate specification of the length of row 1.
• Map number.
• Map slot.
• 1 byte to indicate whether map is contiguous or sparse.