Warehouse.PackageTypes

Columns

• //

  ${escapify(column.description)}
  PackageTypeID
  [int] NOT NULL DEFAULT (NEXT VALUE FOR [Sequences].[PackageTypeID])
• //

  ${escapify(column.description)}
  PackageTypeName
  [nvarchar](50) NOT NULL
• LastEditedBy
  [int] NOT NULL
• ValidFrom
  [datetime2](8) NOT NULL
• ValidTo
  [datetime2](8) NOT NULL

Indexes

• PK_Warehouse_PackageTypes
  UNIQUE CLUSTERED
  PackageTypeID
• UQ_Warehouse_PackageTypes_PackageTypeName
  UNIQUE NONCLUSTERED
  PackageTypeName

Foreign Keys

• FK_Warehouse_PackageTypes_Application_People
  Application.People
  LastEditedBy ⥱ PersonID

Sample Data