HOMES Table Row Storage Size
Table - Sorted Table - Copybook - Create Table - Format File - Bulk Insert - Row Size - Back To Table Index

Column NameData TypeBytes Used
HOMES_KEY BIGINT8
HOMES_GRPCD TINYINT9
HOME_A_NUMBER TINYINT10
HOME_B_KEY TINYINT11
HOME_A_CHANGE_FLAG VARCHAR(1)12
HOME_A_SITE_FLAG VARCHAR(1)13
HOME_A_SITE_VALUE_CODER VARCHAR(4)17
HOME_A_SITE_VALUE INT21
HOME_A_CURR_VALUE INT25
HOME_A_XFEA_VALUE INT29
HOME_A_TOTAL_SQFTG INT33
HOME_A_BEDROOMS INT37
HOME_A_BATHS INT41
HOME_A_HALF_BATHS INT45
HOME_A_UNITS INT49
HOME_A_FLOORS TINYINT50
HOME_B_CHANGE_FLAG VARCHAR(1)51
HOME_B_CODE VARCHAR(1)52
HOME_B_ADD_SQFTG_FLAG VARCHAR(1)53
HOME_B_VALUE INT57
HOME_B_ITEMS DECIMAL(6,2)61
HOME_B_SPECIAL DECIMAL(8,3)65
HOME_B_TOTAL_SQFTG INT69
HOME_B_PTS_GRADE SMALLINT71
HOME_B_GRADE SMALLINT73
HOME_B_ADDITION VARCHAR(10)83
HOMES_X_DISTRICT TINYINT84
HOME_B_NC_FLAG VARCHAR(1)85
HOME_B_NC_NEW INT89
HOME_B_NC_ADD INT93
HOME_B_NC_DEMO INT97
HOME_B_REAPPRAISAL INT101

32 columns are defined.

To Top - Print

Output Generated By +1DataElements From +1 Software Engineering LLC.
Created on: 23-MAY-2020 11:22 AM