Production.Location

Columns

• //

  ${escapify(column.description)}
  LocationID
  [smallint] IDENTITY (1,1) NOT NULL
• //

  ${escapify(column.description)}
  Name
  [Name] NOT NULL

  //

  USER-DEFINED DATA TYPE

  [nvarchar](50) NULL
• //

  ${escapify(column.description)}
  CostRate
  [smallmoney] NOT NULL DEFAULT ((0.00))

  //

  CONSTRAINT: Check constraint [CostRate] >= (0.00)

  ([CostRate]>=(0.00))
• //

  ${escapify(column.description)}
  Availability
  [decimal](8, 2) NOT NULL DEFAULT ((0.00))

  //

  CONSTRAINT: Check constraint [Availability] >= (0.00)

  ([Availability]>=(0.00))
• //

  ${escapify(column.description)}
  ModifiedDate
  [datetime] NOT NULL DEFAULT (getdate())

Indexes

• //

  Clustered index created by a primary key constraint.
  PK_Location_LocationID
  UNIQUE CLUSTERED
  LocationID
• //

  Unique nonclustered index.
  AK_Location_Name
  UNIQUE NONCLUSTERED
  Name

Sample Data