HOMES Table Row Storage Size
Table - Sorted Table - Copybook - Create Table - Load File - Row Size - Back To Table Index

Column NameData TypeBytes Used
HOMES_KEY BIGINT8
HOMES_GRPCD SMALLINT10
HOME_A_NUMBER SMALLINT12
HOME_B_KEY SMALLINT14
HOME_A_CHANGE_FLAG VARCHAR(1)15
HOME_A_SITE_FLAG VARCHAR(1)16
HOME_A_SITE_VALUE_CODER VARCHAR(4)20
HOME_A_SITE_VALUE INT24
HOME_A_CURR_VALUE INT28
HOME_A_XFEA_VALUE INT32
HOME_A_TOTAL_SQFTG INT36
HOME_A_BEDROOMS INT40
HOME_A_BATHS INT44
HOME_A_HALF_BATHS INT48
HOME_A_UNITS INT52
HOME_A_FLOORS SMALLINT54
HOME_B_CHANGE_FLAG VARCHAR(1)55
HOME_B_CODE VARCHAR(1)56
HOME_B_ADD_SQFTG_FLAG VARCHAR(1)57
HOME_B_VALUE INT61
HOME_B_ITEMS DECIMAL(6,2)65
HOME_B_SPECIAL DECIMAL(8,3)69
HOME_B_TOTAL_SQFTG INT73
HOME_B_PTS_GRADE SMALLINT75
HOME_B_GRADE SMALLINT77
HOME_B_ADDITION VARCHAR(10)87
HOMES_X_DISTRICT SMALLINT89
HOME_B_NC_FLAG VARCHAR(1)90
HOME_B_NC_NEW INT94
HOME_B_NC_ADD INT98
HOME_B_NC_DEMO INT102
HOME_B_REAPPRAISAL INT106

32 columns are defined.

To Top - Print

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