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

Column NameData TypeBytes Used
HOMES_KEY BIGINT8
HOMES_GRPCD BYTEINT10
HOME_A_NUMBER BYTEINT12
HOME_B_KEY BYTEINT14
HOME_A_CHANGE_FLAG CHAR(1)15
HOME_A_SITE_FLAG CHAR(1)16
HOME_A_SITE_VALUE_CODER CHAR(4)20
HOME_A_SITE_VALUE INTEGER24
HOME_A_CURR_VALUE INTEGER28
HOME_A_XFEA_VALUE INTEGER32
HOME_A_TOTAL_SQFTG INTEGER36
HOME_A_BEDROOMS INTEGER40
HOME_A_BATHS SMALLINT42
HOME_A_HALF_BATHS SMALLINT44
HOME_A_UNITS SMALLINT46
HOME_A_FLOORS BYTEINT48
HOME_B_CHANGE_FLAG CHAR(1)49
HOME_B_CODE CHAR(1)50
HOME_B_ADD_SQFTG_FLAG CHAR(1)51
HOME_B_VALUE INTEGER55
HOME_B_ITEMS DECIMAL(6,2)59
HOME_B_SPECIAL DECIMAL(8,3)63
HOME_B_TOTAL_SQFTG INTEGER67
HOME_B_PTS_GRADE SMALLINT69
HOME_B_GRADE SMALLINT71
HOME_B_ADDITION VARCHAR(10)81
HOMES_X_DISTRICT BYTEINT83
HOME_B_NC_FLAG CHAR(1)84
HOME_B_NC_NEW INTEGER88
HOME_B_NC_ADD INTEGER92
HOME_B_NC_DEMO INTEGER96
HOME_B_REAPPRAISAL INTEGER100

32 columns are defined.

To Top - Print

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