Difference between revisions of "Production.ScrapReason (table)"

From dbscript Online Help
Jump to: navigation, search
 
(3 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| Production.ScrapReason
 
| Production.ScrapReason
Line 8: Line 8:
 
| '''Description
 
| '''Description
 
| Manufacturing failure reasons lookup table.
 
| Manufacturing failure reasons lookup table.
−
|-
 
 
|}
 
|}
  
−
 
+
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 18: Line 17:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''Description / PK / Index
+
| '''Description
−
+
 
 
|- valign="top"
 
|- valign="top"
 
| ScrapReasonID
 
| ScrapReasonID
Line 25: Line 24:
 
| not null
 
| not null
 
|  
 
|  
−
| Primary key for ScrapReason records.<br />PK_ScrapReason_ScrapReasonID
+
| Primary key for ScrapReason records.
 
|- valign="top"
 
|- valign="top"
 
| Name
 
| Name
Line 31: Line 30:
 
| not null
 
| not null
 
|  
 
|  
−
| Failure description.<br />AK_ScrapReason_Name
+
| Failure description.
 
|- valign="top"
 
|- valign="top"
 
| ModifiedDate
 
| ModifiedDate
Line 37: Line 36:
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
−
| Date and time the record was last updated.<br />
+
| Date and time the record was last updated.
 
|}
 
|}
  
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| PK_ScrapReason_ScrapReasonID
 +
| ScrapReasonID
 +
|}
  
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
  
 +
|- valign="top"
 +
| AK_ScrapReason_Name
 +
| Unique
 +
| Name
 +
|}
 +
 +
=== Detail Tables ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 47: Line 68:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
−
+
 
−
|-
+
|- valign="top"
 
| [[Production.WorkOrder_(table)|Production.WorkOrder]]
 
| [[Production.WorkOrder_(table)|Production.WorkOrder]]
 
| ScrapReasonID
 
| ScrapReasonID
Line 54: Line 75:
 
|}
 
|}
  
−
 
+
=== References ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 61: Line 82:
 
| '''Referenced Object
 
| '''Referenced Object
  
−
|-
+
|- valign="top"
 
| Data Type
 
| Data Type
 
| Type
 
| Type
 
| [[dbo.Name_(type)|dbo.Name]]
 
| [[dbo.Name_(type)|dbo.Name]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Schema
 +
| [[Production_(schema)|Production]]
  
 
|}
 
|}
 +
 +
 
== wikivalues ==
 
== wikivalues ==
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''Table Values
 
| '''Table Values
 
| Production.ScrapReason
 
| Production.ScrapReason
−
|-
 
 
|}
 
|}
  
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
  
−
{| border="1" cellpadding="5" cellspacing="0"  style="border-collapse:collapse"
 
−
|- style="background:silver"
 
 
| '''ScrapReasonID
 
| '''ScrapReasonID
 
| '''Name
 
| '''Name
−
|-  
+
|- valign="top"
−
| 1
+
 
−
| Brake assembly not as ordered
+
| 1
−
|-  
+
| Brake assembly not as ordered
−
| 2
+
|- valign="top"
−
| Color incorrect
+
 
−
|-  
+
| 2
−
| 4
+
| Color incorrect
−
| Drill pattern incorrect
+
|- valign="top"
−
|-  
+
 
−
| 5
+
| 4
−
| Drill size too large
+
| Drill pattern incorrect
−
|-  
+
|- valign="top"
−
| 6
+
 
−
| Drill size too small
+
| 5
−
|-  
+
| Drill size too large
−
| 3
+
|- valign="top"
−
| Gouge in metal
+
 
−
|-  
+
| 6
−
| 7
+
| Drill size too small
−
| Handling damage
+
|- valign="top"
−
|-  
+
 
−
| 8
+
| 3
−
| Paint process failed
+
| Gouge in metal
−
|-  
+
|- valign="top"
−
| 9
+
 
−
| Primer process failed
+
| 7
−
|-  
+
| Handling damage
−
| 10
+
|- valign="top"
−
| Seat assembly not as ordered
+
 
−
|-  
+
| 8
−
| 11
+
| Paint process failed
−
| Stress test failed
+
|- valign="top"
−
|-  
+
 
−
| 12
+
| 9
−
| Thermoform temperature too high
+
| Primer process failed
−
|-  
+
|- valign="top"
−
| 13
+
 
−
| Thermoform temperature too low
+
| 10
−
|-  
+
| Seat assembly not as ordered
−
| 14
+
|- valign="top"
−
| Trim length too long
+
 
−
|-  
+
| 11
−
| 15
+
| Stress test failed
−
| Trim length too short
+
|- valign="top"
−
|-  
+
 
−
| 16
+
| 12
−
| Wheel misaligned
+
| Thermoform temperature too high
 +
|- valign="top"
 +
 
 +
| 13
 +
| Thermoform temperature too low
 +
|- valign="top"
 +
 
 +
| 14
 +
| Trim length too long
 +
|- valign="top"
 +
 
 +
| 15
 +
| Trim length too short
 +
|- valign="top"
 +
 
 +
| 16
 +
| Wheel misaligned
 
|}
 
|}
  

Latest revision as of 10:55, 27 August 2011

wikibot[edit]

Table Production.ScrapReason
Description Manufacturing failure reasons lookup table.

Columns[edit]

Column Data Type Nullable Default Description
ScrapReasonID smallint not null Primary key for ScrapReason records.
Name dbo.Name not null Failure description.
ModifiedDate datetime not null (getdate()) Date and time the record was last updated.

Primary Key[edit]

Primary Key Columns
PK_ScrapReason_ScrapReasonID ScrapReasonID

Indexes[edit]

Index Type Columns
AK_ScrapReason_Name Unique Name

Detail Tables[edit]

Detail Table Column Referencing Column
Production.WorkOrder ScrapReasonID ScrapReasonID

References[edit]

Dependency Type Object Type Referenced Object
Data Type Type dbo.Name
Schema Schema Production


wikivalues[edit]

Table Values Production.ScrapReason
ScrapReasonID Name
1 Brake assembly not as ordered
2 Color incorrect
4 Drill pattern incorrect
5 Drill size too large
6 Drill size too small
3 Gouge in metal
7 Handling damage
8 Paint process failed
9 Primer process failed
10 Seat assembly not as ordered
11 Stress test failed
12 Thermoform temperature too high
13 Thermoform temperature too low
14 Trim length too long
15 Trim length too short
16 Wheel misaligned

automatically generated[edit]

Table Production.ScrapReason
Description Manufacturing failure reasons lookup table.


Column Data Type Nullable Default Description / PK / Index
ScrapReasonID smallint not null Primary key for ScrapReason records.
PK_ScrapReason_ScrapReasonID
Name Name not null Failure description.
AK_ScrapReason_Name
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Detail Table Column Referencing Column
Production.WorkOrder ScrapReasonID ScrapReasonID


Dependency Type Object Type Referenced Object
Data Type Type dbo.Name
Schema Schema Production
Retrieved from "http://dbshelp.devio.at/index.php?title=Production.ScrapReason_(table)&oldid=2935"