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

Column NameData TypeBytes Used
OWNER_PROP_KEY BIGINT8
OWNER_PROP_OWNER_NAME VARCHAR(33)41
OWNER_PROP_ADDRESS_MAILING1 VARCHAR(33)74
OWNER_PROP_ADDRESS_MAILING2 VARCHAR(33)107
OWNER_PROP_ADDRESS_MAILING3 VARCHAR(33)140
OWNER_PROP_ADDRESS_MAILING4 VARCHAR(33)173
OWNER_PROP_ADDRESS_PROPERTY VARCHAR(33)206
OWNER_SUBDIVISION_NAME VARCHAR(50)256
OWNER_PROP_MILLAGE SMALLINT258
OWNER_PROP_INSPECT_DATE_MONTH TINYINT259
OWNER_PROP_INSPECT_DATE_YEAR INT263
OWNER_PROP_CLUC_CODE VARCHAR(4)267
OWNER_PROP_SLUC_CODE VARCHAR(4)271
OWNER_PROP_YEAR_BUILT SMALLINT273
OWNER_PROP_CONDO_UNIT VARCHAR(6)279
OWNER_PROP_LOT_SIZE VARCHAR(15)294
OWNER_PROP_CHANGE_DATE INT298
OWNER_PROP_ASSMT_YEAR SMALLINT300
OWNER_PROP_LAND_VALUE BIGINT308
OWNER_PROP_BLDG_VALUE BIGINT316
OWNER_PROP_TOTAL_VALUE BIGINT324
OWNER_PROP_HEX_VALUE INT328
OWNER_PROP_WIDOW_AMOUNT INT332
OWNER_PROP_VETERAN_AMOUNT INT336
OWNER_PROP_DISABLED_AMOUNT INT340
OWNER_PROP_TOTAL_EXEMPT BIGINT348
OWNER_PROP_TOTAL_NONEXEMPT BIGINT356
OWNER_PROP_SENIOR_AMOUNT INT360
OWNER_PROP_COUNTY_NONEXEMPT BIGINT368
OWNER_PROP_SCHOOL_EXEMPT BIGINT376
OWNER_PROP_SCHOOL_NONEXEMPT BIGINT384
OWNER_PROP_LAST_ASSMT_YEAR SMALLINT386
OWNER_PROP_LAST_LAND_VALUE BIGINT394
OWNER_PROP_LAST_BLDG_VALUE BIGINT402
OWNER_PROP_LAST_TOTAL_VALUE BIGINT410
OWNER_PROP_LAST_HEX_VALUE INT414
OWNER_PROP_LAST_WIDOW_AMOUNT INT418
OWNER_PROP_LAST_VETERAN_AMOUNT INT422
OWNER_PROP_LAST_DISABLE_AMOUNT INT426
OWNER_PROP_LAST_TOTAL_EXEMPT BIGINT434
OWNER_PROP_LAST_TOTAL_NONEX BIGINT442
OWNER_PROP_LAST_SENIOR_AMOUNT INT446
OWNER_PROP_LAST_COUNTY_NONEX BIGINT454
OWNER_PROP_LAST_SCHOOL_EXEMPT BIGINT462
OWNER_PROP_LAST_SCHOOL_NONEX BIGINT470
OWNER_PROP_PREV_ASSMT_YEAR SMALLINT472
OWNER_PROP_PREV_LAND_VALUE BIGINT480
OWNER_PROP_PREV_BLDG_VALUE BIGINT488
OWNER_PROP_PREV_TOTAL_VALUE BIGINT496
OWNER_PROP_PREV_HEX_VALUE INT500
OWNER_PROP_PREV_WIDOW_AMOUNT INT504
OWNER_PROP_PREV_VETERAN_AMOUNT INT508
OWNER_PROP_PREV_DISABLE_AMOUNT INT512
OWNER_PROP_PREV_TOTAL_EXEMPT BIGINT520
OWNER_PROP_PREV_TOTAL_NONEX BIGINT528
OWNER_PROP_PREV_SENIOR_AMOUNT INT532
OWNER_PROP_PREV_COUNTY_NONEX BIGINT540
OWNER_PROP_PREV_SCHOOL_EXEMPT BIGINT548
OWNER_PROP_PREV_SCHOOL_NONEX BIGINT556
OWNER_PROP_PRI_ZONE VARCHAR(4)560
OWNER_PROP_BLDG_SQFTG INT564
OWNER_PROP_XFEATURES TINYINT565
OWNER_PROP_BEDROOM INT569
OWNER_PROP_BATH INT573
OWNER_WATER_NUMBER SMALLINT575
OWNER_ROAD_NUMBER SMALLINT577
OWNER_SEWER_NUMBER SMALLINT579
OWNER_LITE_NUMBER SMALLINT581
OWNER_LAST_SALES_DATE_MONTH TINYINT582
OWNER_LAST_SALES_DATE_YEAR INT586
OWNER_LAST_SALES_AMOUNT INT590
OWNER_LAST_SALES_TYPE TINYINT591
OWNER_PREV_SALES_DATE_MONTH TINYINT592
OWNER_PREV_SALES_DATE_YEAR INT596
OWNER_PREV_SALES_AMOUNT INT600
OWNER_PREV_SALES_TYPE TINYINT601
OWNER_SALES3_DATE_MONTH TINYINT602
OWNER_SALES3_DATE_YEAR INT606
OWNER_SALES3_AMOUNT INT610
OWNER_SALES3_TYPE TINYINT611
OWNER_PROP_RESIDENT_YEAR SMALLINT613
OWNER_CITY_TAX DECIMAL(16,2)617
OWNER_COUNTY_TAX DECIMAL(16,2)621
OWNER_WASTE_TAX DECIMAL(16,2)625
OWNER_WATER_TAX DECIMAL(16,2)629
OWNER_ROAD_TAX DECIMAL(16,2)633
OWNER_SEWER_TAX DECIMAL(16,2)637
OWNER_GROSS_TAX DECIMAL(16,2)641
OWNER_REFFOLIO_KEY BIGINT649
OWNER_LAKE_BELT_DISTRICT VARCHAR(1)650
OWNER_CTY_SENIOR_EXEMP INT654
OWNER_LAST_CTY_SENIOR_EXEMP INT658
OWNER_PREV_CTY_SENIOR_EXEMP INT662
OWNER_BLIND INT666
OWNER_LAST_BLIND INT670
OWNER_PREV_BLIND INT674
OWNER_NO_XFEA_LINES TINYINT675
OWNER_NO_LEGAL_LINES TINYINT676
OWNER_BLDG_NUMBER_1 TINYINT677
OWNER_XFEA_LINE_NO_1 TINYINT678
OWNER_XFEA_PRICE_CODE_1 SMALLINT680
OWNER_XFEA_UNIT_AREA_1 DECIMAL(10,2)684
OWNER_XFEA_ADDED_1 INT688
OWNER_XFEA_DESCR_1 VARCHAR(15)703
OWNER_FILLER1_1_001 VARCHAR(1)704
OWNER_BLDG_NUMBER_2 TINYINT705
OWNER_XFEA_LINE_NO_2 TINYINT706
OWNER_XFEA_PRICE_CODE_2 SMALLINT708
OWNER_XFEA_UNIT_AREA_2 DECIMAL(10,2)712
OWNER_XFEA_ADDED_2 INT716
OWNER_XFEA_DESCR_2 VARCHAR(15)731
OWNER_FILLER1_2_002 VARCHAR(1)732
OWNER_BLDG_NUMBER_3 TINYINT733
OWNER_XFEA_LINE_NO_3 TINYINT734
OWNER_XFEA_PRICE_CODE_3 SMALLINT736
OWNER_XFEA_UNIT_AREA_3 DECIMAL(10,2)740
OWNER_XFEA_ADDED_3 INT744
OWNER_XFEA_DESCR_3 VARCHAR(15)759
OWNER_FILLER1_3_003 VARCHAR(1)760
OWNER_BLDG_NUMBER_4 TINYINT761
OWNER_XFEA_LINE_NO_4 TINYINT762
OWNER_XFEA_PRICE_CODE_4 SMALLINT764
OWNER_XFEA_UNIT_AREA_4 DECIMAL(10,2)768
OWNER_XFEA_ADDED_4 INT772
OWNER_XFEA_DESCR_4 VARCHAR(15)787
OWNER_FILLER1_4_004 VARCHAR(1)788
OWNER_BLDG_NUMBER_5 TINYINT789
OWNER_XFEA_LINE_NO_5 TINYINT790
OWNER_XFEA_PRICE_CODE_5 SMALLINT792
OWNER_XFEA_UNIT_AREA_5 DECIMAL(10,2)796
OWNER_XFEA_ADDED_5 INT800
OWNER_XFEA_DESCR_5 VARCHAR(15)815
OWNER_FILLER1_5_005 VARCHAR(1)816
OWNER_LEGAL_DESCR_1 VARCHAR(33)849
OWNER_LEGAL_DESCR_2 VARCHAR(33)882
OWNER_LEGAL_DESCR_3 VARCHAR(33)915
OWNER_LEGAL_DESCR_4 VARCHAR(33)948
OWNER_LEGAL_DESCR_5 VARCHAR(33)981
OWNER_FILLER2_006 VARCHAR(1)982

139 columns are defined.

To Top - Print

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