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

Column NameData TypeBytes Used
OWNER_PROP_KEY DECIMAL(15)4
OWNER_PROP_OWNER_NAME VARCHAR(33)37
OWNER_PROP_ADDRESS_MAILING1 VARCHAR(33)70
OWNER_PROP_ADDRESS_MAILING2 VARCHAR(33)103
OWNER_PROP_ADDRESS_MAILING3 VARCHAR(33)136
OWNER_PROP_ADDRESS_MAILING4 VARCHAR(33)169
OWNER_PROP_ADDRESS_PROPERTY VARCHAR(33)202
OWNER_SUBDIVISION_NAME VARCHAR(50)252
OWNER_PROP_MILLAGE SMALLINT254
OWNER_PROP_INSPECT_DATE_MONTH BYTEINT256
OWNER_PROP_INSPECT_DATE_YEAR SMALLINT258
OWNER_PROP_CLUC_CODE CHAR(4)262
OWNER_PROP_SLUC_CODE CHAR(4)266
OWNER_PROP_YEAR_BUILT SMALLINT268
OWNER_PROP_CONDO_UNIT VARCHAR(6)274
OWNER_PROP_LOT_SIZE VARCHAR(15)289
OWNER_PROP_CHANGE_DATE INTEGER293
OWNER_PROP_ASSMT_YEAR SMALLINT295
OWNER_PROP_LAND_VALUE BIGINT303
OWNER_PROP_BLDG_VALUE BIGINT311
OWNER_PROP_TOTAL_VALUE BIGINT319
OWNER_PROP_HEX_VALUE INTEGER323
OWNER_PROP_WIDOW_AMOUNT SMALLINT325
OWNER_PROP_VETERAN_AMOUNT SMALLINT327
OWNER_PROP_DISABLED_AMOUNT SMALLINT329
OWNER_PROP_TOTAL_EXEMPT BIGINT337
OWNER_PROP_TOTAL_NONEXEMPT BIGINT345
OWNER_PROP_SENIOR_AMOUNT SMALLINT347
OWNER_PROP_COUNTY_NONEXEMPT BIGINT355
OWNER_PROP_SCHOOL_EXEMPT BIGINT363
OWNER_PROP_SCHOOL_NONEXEMPT BIGINT371
OWNER_PROP_LAST_ASSMT_YEAR SMALLINT373
OWNER_PROP_LAST_LAND_VALUE BIGINT381
OWNER_PROP_LAST_BLDG_VALUE BIGINT389
OWNER_PROP_LAST_TOTAL_VALUE BIGINT397
OWNER_PROP_LAST_HEX_VALUE INTEGER401
OWNER_PROP_LAST_WIDOW_AMOUNT SMALLINT403
OWNER_PROP_LAST_VETERAN_AMOUNT SMALLINT405
OWNER_PROP_LAST_DISABLE_AMOUNT SMALLINT407
OWNER_PROP_LAST_TOTAL_EXEMPT BIGINT415
OWNER_PROP_LAST_TOTAL_NONEX BIGINT423
OWNER_PROP_LAST_SENIOR_AMOUNT SMALLINT425
OWNER_PROP_LAST_COUNTY_NONEX BIGINT433
OWNER_PROP_LAST_SCHOOL_EXEMPT BIGINT441
OWNER_PROP_LAST_SCHOOL_NONEX BIGINT449
OWNER_PROP_PREV_ASSMT_YEAR SMALLINT451
OWNER_PROP_PREV_LAND_VALUE BIGINT459
OWNER_PROP_PREV_BLDG_VALUE BIGINT467
OWNER_PROP_PREV_TOTAL_VALUE BIGINT475
OWNER_PROP_PREV_HEX_VALUE INTEGER479
OWNER_PROP_PREV_WIDOW_AMOUNT SMALLINT481
OWNER_PROP_PREV_VETERAN_AMOUNT SMALLINT483
OWNER_PROP_PREV_DISABLE_AMOUNT SMALLINT485
OWNER_PROP_PREV_TOTAL_EXEMPT BIGINT493
OWNER_PROP_PREV_TOTAL_NONEX BIGINT501
OWNER_PROP_PREV_SENIOR_AMOUNT SMALLINT503
OWNER_PROP_PREV_COUNTY_NONEX BIGINT511
OWNER_PROP_PREV_SCHOOL_EXEMPT BIGINT519
OWNER_PROP_PREV_SCHOOL_NONEX BIGINT527
OWNER_PROP_PRI_ZONE CHAR(4)531
OWNER_PROP_BLDG_SQFTG INTEGER535
OWNER_PROP_XFEATURES BYTEINT537
OWNER_PROP_BEDROOM INTEGER541
OWNER_PROP_BATH SMALLINT543
OWNER_WATER_NUMBER SMALLINT545
OWNER_ROAD_NUMBER SMALLINT547
OWNER_SEWER_NUMBER SMALLINT549
OWNER_LITE_NUMBER SMALLINT551
OWNER_LAST_SALES_DATE_MONTH BYTEINT553
OWNER_LAST_SALES_DATE_YEAR SMALLINT555
OWNER_LAST_SALES_AMOUNT INTEGER559
OWNER_LAST_SALES_TYPE BYTEINT561
OWNER_PREV_SALES_DATE_MONTH BYTEINT563
OWNER_PREV_SALES_DATE_YEAR SMALLINT565
OWNER_PREV_SALES_AMOUNT INTEGER569
OWNER_PREV_SALES_TYPE BYTEINT571
OWNER_SALES3_DATE_MONTH BYTEINT573
OWNER_SALES3_DATE_YEAR SMALLINT575
OWNER_SALES3_AMOUNT INTEGER579
OWNER_SALES3_TYPE BYTEINT581
OWNER_PROP_RESIDENT_YEAR SMALLINT583
OWNER_CITY_TAX DECIMAL(16,2)587
OWNER_COUNTY_TAX DECIMAL(16,2)591
OWNER_WASTE_TAX DECIMAL(16,2)595
OWNER_WATER_TAX DECIMAL(16,2)599
OWNER_ROAD_TAX DECIMAL(16,2)603
OWNER_SEWER_TAX DECIMAL(16,2)607
OWNER_GROSS_TAX DECIMAL(16,2)611
OWNER_REFFOLIO_KEY DECIMAL(15)615
OWNER_LAKE_BELT_DISTRICT CHAR(1)616
OWNER_CTY_SENIOR_EXEMP SMALLINT618
OWNER_LAST_CTY_SENIOR_EXEMP SMALLINT620
OWNER_PREV_CTY_SENIOR_EXEMP SMALLINT622
OWNER_BLIND SMALLINT624
OWNER_LAST_BLIND SMALLINT626
OWNER_PREV_BLIND SMALLINT628
OWNER_NO_XFEA_LINES BYTEINT630
OWNER_NO_LEGAL_LINES BYTEINT632
OWNER_BLDG_NUMBER_1 BYTEINT634
OWNER_XFEA_LINE_NO_1 BYTEINT636
OWNER_XFEA_PRICE_CODE_1 SMALLINT638
OWNER_XFEA_UNIT_AREA_1 DECIMAL(10,2)642
OWNER_XFEA_ADDED_1 INTEGER646
OWNER_XFEA_DESCR_1 VARCHAR(15)661
OWNER_FILLER1_1_001 CHAR(1)662
OWNER_BLDG_NUMBER_2 BYTEINT664
OWNER_XFEA_LINE_NO_2 BYTEINT666
OWNER_XFEA_PRICE_CODE_2 SMALLINT668
OWNER_XFEA_UNIT_AREA_2 DECIMAL(10,2)672
OWNER_XFEA_ADDED_2 INTEGER676
OWNER_XFEA_DESCR_2 VARCHAR(15)691
OWNER_FILLER1_2_002 CHAR(1)692
OWNER_BLDG_NUMBER_3 BYTEINT694
OWNER_XFEA_LINE_NO_3 BYTEINT696
OWNER_XFEA_PRICE_CODE_3 SMALLINT698
OWNER_XFEA_UNIT_AREA_3 DECIMAL(10,2)702
OWNER_XFEA_ADDED_3 INTEGER706
OWNER_XFEA_DESCR_3 VARCHAR(15)721
OWNER_FILLER1_3_003 CHAR(1)722
OWNER_BLDG_NUMBER_4 BYTEINT724
OWNER_XFEA_LINE_NO_4 BYTEINT726
OWNER_XFEA_PRICE_CODE_4 SMALLINT728
OWNER_XFEA_UNIT_AREA_4 DECIMAL(10,2)732
OWNER_XFEA_ADDED_4 INTEGER736
OWNER_XFEA_DESCR_4 VARCHAR(15)751
OWNER_FILLER1_4_004 CHAR(1)752
OWNER_BLDG_NUMBER_5 BYTEINT754
OWNER_XFEA_LINE_NO_5 BYTEINT756
OWNER_XFEA_PRICE_CODE_5 SMALLINT758
OWNER_XFEA_UNIT_AREA_5 DECIMAL(10,2)762
OWNER_XFEA_ADDED_5 INTEGER766
OWNER_XFEA_DESCR_5 VARCHAR(15)781
OWNER_FILLER1_5_005 CHAR(1)782
OWNER_LEGAL_DESCR_1 VARCHAR(33)815
OWNER_LEGAL_DESCR_2 VARCHAR(33)848
OWNER_LEGAL_DESCR_3 VARCHAR(33)881
OWNER_LEGAL_DESCR_4 VARCHAR(33)914
OWNER_LEGAL_DESCR_5 VARCHAR(33)947
OWNER_FILLER2_006 CHAR(1)948

139 columns are defined.

To Top - Print

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