Table: BinaryFile

Database schema and system attributes for BinaryFile.

AdditionalInformation

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

BinaryFileTypeId

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

ContentLastModified

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: datetime
  • Property Values:
    • MaxLength = 8

CreatedByPersonAliasId

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

CreatedDateTime

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: datetime
  • Property Values:
    • MaxLength = 8

Description

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

FileName

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

FileSize

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: bigint
  • Property Values:
    • MaxLength = 8

ForeignGuid

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: uniqueidentifier
  • Property Values:
    • MaxLength = 16

ForeignId

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

ForeignKey

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

Guid

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: uniqueidentifier
  • Property Values:
    • MaxLength = 16

Height

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

Id

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

IsSystem

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: bit
  • Property Values:
    • MaxLength = 1

IsTemporary

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: bit
  • Property Values:
    • MaxLength = 1

MimeType

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

ModifiedByPersonAliasId

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

ModifiedDateTime

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: datetime
  • Property Values:
    • MaxLength = 8

ParentEntityId

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

ParentEntityTypeId

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

Path

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

StorageEntitySettings

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

StorageEntityTypeId

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

Width

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

core_LabelType

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Single-Select
  • Description: When a family checks in, should this label be printed once per family, person, or location. Note: this only applies if check-in is configured to use Family check-in vs Individual check-in.
  • Property Values:
    • fieldtype = ddl
    • values = 0^Family,1^Person,2^Location,3^Check-Out

MergeCodes

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Key Value List
  • Description: The merge codes used by the label. The Key (left column) is the field found in the label file. The Value (right column) is the Check-in data that should be displayed in that location.
  • Property Values:
    • definedtype = 19