Table ptms..SchedulingCapacityPerHour

  Column Name Type Length Nullable Description Relationships
Identity ID int identity   No    
  ScheduleHour varchar 5 Yes    
  DefaultAmbCapacity numeric   Yes    
  DefaultWCCapacity numeric   Yes    
  DateRestrictedAmbCapacity numeric   Yes    
  DateRestrictedWCCapacity numeric   Yes    
  DateRestrictionStartDate datetime   Yes    
  DateRestrictionStopDate datetime   Yes    
  starjdate numeric   Yes    
  stopjdate numeric   Yes    
  Timestamp datetime   Yes    

Indexes on this table

Index Name Index Description Index Keys
PK_SchedulingCapacityPerHour clustered, unique, primary key located on PRIMARY ID
U_ScheduleHour nonclustered, unique located on PRIMARY ScheduleHour