OWNER Table Row Storage Size
Table - Sorted Table - Copybook - Create Table - Load File - 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 SMALLINT260
OWNER_PROP_INSPECT_DATE_YEAR INT264
OWNER_PROP_CLUC_CODE VARCHAR(4)268
OWNER_PROP_SLUC_CODE VARCHAR(4)272
OWNER_PROP_YEAR_BUILT SMALLINT274
OWNER_PROP_CONDO_UNIT VARCHAR(6)280
OWNER_PROP_LOT_SIZE VARCHAR(15)295
OWNER_PROP_CHANGE_DATE INT299
OWNER_PROP_ASSMT_YEAR SMALLINT301
OWNER_PROP_LAND_VALUE BIGINT309
OWNER_PROP_BLDG_VALUE BIGINT317
OWNER_PROP_TOTAL_VALUE BIGINT325
OWNER_PROP_HEX_VALUE INT329
OWNER_PROP_WIDOW_AMOUNT INT333
OWNER_PROP_VETERAN_AMOUNT INT337
OWNER_PROP_DISABLED_AMOUNT INT341
OWNER_PROP_TOTAL_EXEMPT BIGINT349
OWNER_PROP_TOTAL_NONEXEMPT BIGINT357
OWNER_PROP_SENIOR_AMOUNT INT361
OWNER_PROP_COUNTY_NONEXEMPT BIGINT369
OWNER_PROP_SCHOOL_EXEMPT BIGINT377
OWNER_PROP_SCHOOL_NONEXEMPT BIGINT385
OWNER_PROP_LAST_ASSMT_YEAR SMALLINT387
OWNER_PROP_LAST_LAND_VALUE BIGINT395
OWNER_PROP_LAST_BLDG_VALUE BIGINT403
OWNER_PROP_LAST_TOTAL_VALUE BIGINT411
OWNER_PROP_LAST_HEX_VALUE INT415
OWNER_PROP_LAST_WIDOW_AMOUNT INT419
OWNER_PROP_LAST_VETERAN_AMOUNT INT423
OWNER_PROP_LAST_DISABLE_AMOUNT INT427
OWNER_PROP_LAST_TOTAL_EXEMPT BIGINT435
OWNER_PROP_LAST_TOTAL_NONEX BIGINT443
OWNER_PROP_LAST_SENIOR_AMOUNT INT447
OWNER_PROP_LAST_COUNTY_NONEX BIGINT455
OWNER_PROP_LAST_SCHOOL_EXEMPT BIGINT463
OWNER_PROP_LAST_SCHOOL_NONEX BIGINT471
OWNER_PROP_PREV_ASSMT_YEAR SMALLINT473
OWNER_PROP_PREV_LAND_VALUE BIGINT481
OWNER_PROP_PREV_BLDG_VALUE BIGINT489
OWNER_PROP_PREV_TOTAL_VALUE BIGINT497
OWNER_PROP_PREV_HEX_VALUE INT501
OWNER_PROP_PREV_WIDOW_AMOUNT INT505
OWNER_PROP_PREV_VETERAN_AMOUNT INT509
OWNER_PROP_PREV_DISABLE_AMOUNT INT513
OWNER_PROP_PREV_TOTAL_EXEMPT BIGINT521
OWNER_PROP_PREV_TOTAL_NONEX BIGINT529
OWNER_PROP_PREV_SENIOR_AMOUNT INT533
OWNER_PROP_PREV_COUNTY_NONEX BIGINT541
OWNER_PROP_PREV_SCHOOL_EXEMPT BIGINT549
OWNER_PROP_PREV_SCHOOL_NONEX BIGINT557
OWNER_PROP_PRI_ZONE VARCHAR(4)561
OWNER_PROP_BLDG_SQFTG INT565
OWNER_PROP_XFEATURES SMALLINT567
OWNER_PROP_BEDROOM INT571
OWNER_PROP_BATH INT575
OWNER_WATER_NUMBER SMALLINT577
OWNER_ROAD_NUMBER SMALLINT579
OWNER_SEWER_NUMBER SMALLINT581
OWNER_LITE_NUMBER SMALLINT583
OWNER_LAST_SALES_DATE_MONTH SMALLINT585
OWNER_LAST_SALES_DATE_YEAR INT589
OWNER_LAST_SALES_AMOUNT INT593
OWNER_LAST_SALES_TYPE SMALLINT595
OWNER_PREV_SALES_DATE_MONTH SMALLINT597
OWNER_PREV_SALES_DATE_YEAR INT601
OWNER_PREV_SALES_AMOUNT INT605
OWNER_PREV_SALES_TYPE SMALLINT607
OWNER_SALES3_DATE_MONTH SMALLINT609
OWNER_SALES3_DATE_YEAR INT613
OWNER_SALES3_AMOUNT INT617
OWNER_SALES3_TYPE SMALLINT619
OWNER_PROP_RESIDENT_YEAR SMALLINT621
OWNER_CITY_TAX DECIMAL(16,2)625
OWNER_COUNTY_TAX DECIMAL(16,2)629
OWNER_WASTE_TAX DECIMAL(16,2)633
OWNER_WATER_TAX DECIMAL(16,2)637
OWNER_ROAD_TAX DECIMAL(16,2)641
OWNER_SEWER_TAX DECIMAL(16,2)645
OWNER_GROSS_TAX DECIMAL(16,2)649
OWNER_REFFOLIO_KEY BIGINT657
OWNER_LAKE_BELT_DISTRICT VARCHAR(1)658
OWNER_CTY_SENIOR_EXEMP INT662
OWNER_LAST_CTY_SENIOR_EXEMP INT666
OWNER_PREV_CTY_SENIOR_EXEMP INT670
OWNER_BLIND INT674
OWNER_LAST_BLIND INT678
OWNER_PREV_BLIND INT682
OWNER_NO_XFEA_LINES SMALLINT684
OWNER_NO_LEGAL_LINES SMALLINT686
OWNER_BLDG_NUMBER_1 SMALLINT688
OWNER_XFEA_LINE_NO_1 SMALLINT690
OWNER_XFEA_PRICE_CODE_1 SMALLINT692
OWNER_XFEA_UNIT_AREA_1 DECIMAL(10,2)696
OWNER_XFEA_ADDED_1 INT700
OWNER_XFEA_DESCR_1 VARCHAR(15)715
OWNER_FILLER1_1_001 VARCHAR(1)716
OWNER_BLDG_NUMBER_2 SMALLINT718
OWNER_XFEA_LINE_NO_2 SMALLINT720
OWNER_XFEA_PRICE_CODE_2 SMALLINT722
OWNER_XFEA_UNIT_AREA_2 DECIMAL(10,2)726
OWNER_XFEA_ADDED_2 INT730
OWNER_XFEA_DESCR_2 VARCHAR(15)745
OWNER_FILLER1_2_002 VARCHAR(1)746
OWNER_BLDG_NUMBER_3 SMALLINT748
OWNER_XFEA_LINE_NO_3 SMALLINT750
OWNER_XFEA_PRICE_CODE_3 SMALLINT752
OWNER_XFEA_UNIT_AREA_3 DECIMAL(10,2)756
OWNER_XFEA_ADDED_3 INT760
OWNER_XFEA_DESCR_3 VARCHAR(15)775
OWNER_FILLER1_3_003 VARCHAR(1)776
OWNER_BLDG_NUMBER_4 SMALLINT778
OWNER_XFEA_LINE_NO_4 SMALLINT780
OWNER_XFEA_PRICE_CODE_4 SMALLINT782
OWNER_XFEA_UNIT_AREA_4 DECIMAL(10,2)786
OWNER_XFEA_ADDED_4 INT790
OWNER_XFEA_DESCR_4 VARCHAR(15)805
OWNER_FILLER1_4_004 VARCHAR(1)806
OWNER_BLDG_NUMBER_5 SMALLINT808
OWNER_XFEA_LINE_NO_5 SMALLINT810
OWNER_XFEA_PRICE_CODE_5 SMALLINT812
OWNER_XFEA_UNIT_AREA_5 DECIMAL(10,2)816
OWNER_XFEA_ADDED_5 INT820
OWNER_XFEA_DESCR_5 VARCHAR(15)835
OWNER_FILLER1_5_005 VARCHAR(1)836
OWNER_LEGAL_DESCR_1 VARCHAR(33)869
OWNER_LEGAL_DESCR_2 VARCHAR(33)902
OWNER_LEGAL_DESCR_3 VARCHAR(33)935
OWNER_LEGAL_DESCR_4 VARCHAR(33)968
OWNER_LEGAL_DESCR_5 VARCHAR(33)1001
OWNER_FILLER2_006 VARCHAR(1)1002

139 columns are defined.

To Top - Print

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