Table: AnalyticsSourcePostalCode

Database schema and system attributes for AnalyticsSourcePostalCode.

City

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 100

CountryCode

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 6

Families100kTo149kPercent

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: decimal
  • Property Values:
    • MaxLength = 9

Families10kTo14kPercent

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: decimal
  • Property Values:
    • MaxLength = 9

Families150kTo199kPercent

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: decimal
  • Property Values:
    • MaxLength = 9

Families15kTo24kPercent

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: decimal
  • Property Values:
    • MaxLength = 9

Families25kTo34kPercent

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: decimal
  • Property Values:
    • MaxLength = 9

Families35kTo49kPercent

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: decimal
  • Property Values:
    • MaxLength = 9

Families50kTo74kPercent

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: decimal
  • Property Values:
    • MaxLength = 9

Families75kTo99kPercent

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: decimal
  • Property Values:
    • MaxLength = 9

FamiliesMeanIncome

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: decimal
  • Property Values:
    • MaxLength = 9

FamiliesMeanIncomeMarginOfError

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: decimal
  • Property Values:
    • MaxLength = 9

FamiliesMedianIncome

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: decimal
  • Property Values:
    • MaxLength = 9

FamiliesMedianIncomeMarginOfError

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: decimal
  • Property Values:
    • MaxLength = 9

FamiliesMore200kPercent

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: decimal
  • Property Values:
    • MaxLength = 9

FamiliesTotal

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

FamiliesUnder10kPercent

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: decimal
  • Property Values:
    • MaxLength = 9

GeoFence

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: geography
  • Property Values:
    • MaxLength = -1

HouseholdsTotal

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

LastUpdate

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

MarriedCouplesTotal

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

NonFamilyHouseholdsTotal

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

PostalCode

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 100

SquareMiles

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: decimal
  • Property Values:
    • MaxLength = 9

State

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 4