Latest revision |
Your text |
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.Location | | | Production.Location |
− | |- valign="top" | + | |- |
− | | '''Description
| |
− | | Product inventory and manufacturing locations.
| |
| |} | | |} |
| | | |
− | === 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 17: |
Line 15: |
| | '''Nullable | | | '''Nullable |
| | '''Default | | | '''Default |
− | | '''Description | + | | '''PK |
− | | + | | '''Index |
− | |- valign="top" | + | |
| + | |- |
| | LocationID | | | LocationID |
| | smallint | | | smallint |
| | not null | | | not null |
| | | | | |
− | | Primary key for Location records. | + | | PK_Location_LocationID |
− | |- valign="top" | + | | |
| + | |- |
| | Name | | | Name |
| | dbo.Name | | | dbo.Name |
| | not null | | | not null |
| | | | | |
− | | Location description. | + | | |
− | |- valign="top" | + | | AK_Location_Name |
| + | |- |
| | CostRate | | | CostRate |
| | smallmoney | | | smallmoney |
| | not null | | | not null |
| | ((0.00)) | | | ((0.00)) |
− | | Standard hourly cost of the manufacturing location. | + | | |
− | |- valign="top" | + | | |
| + | |- |
| | Availability | | | Availability |
| | decimal(8, 2) | | | decimal(8, 2) |
| | not null | | | not null |
| | ((0.00)) | | | ((0.00)) |
− | | Work capacity (in hours) of the manufacturing location. | + | | |
− | |- valign="top" | + | | |
| + | |- |
| | ModifiedDate | | | ModifiedDate |
| | datetime | | | datetime |
| | not null | | | not null |
| | (getdate()) | | | (getdate()) |
− | | 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_Location_LocationID
| |
− | | LocationID
| |
− | |}
| |
− |
| |
− | === Indexes ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Index
| |
− | | '''Type
| |
− | | '''Columns
| |
− |
| |
− | |- valign="top"
| |
− | | AK_Location_Name
| |
− | | Unique
| |
− | | Name
| |
− | |}
| |
− |
| |
− | === Check Constraints ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Check Constraint
| |
− | | '''Expression
| |
− | | '''Description
| |
− |
| |
− | |- valign="top"
| |
− | | CK_Location_Availability
| |
− | | ([Availability]>=(0.00))
| |
− | | Check constraint [Availability] >= (0.00)
| |
− | |- valign="top"
| |
− | | CK_Location_CostRate
| |
− | | ([CostRate]>=(0.00))
| |
− | | Check constraint [CostRate] >= (0.00)
| |
− | |}
| |
− |
| |
− | === Detail Tables ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Detail Table
| |
− | | '''Column
| |
− | | '''Referencing Column
| |
− |
| |
− | |- valign="top"
| |
− | | [[Production.ProductInventory_(table)|Production.ProductInventory]]
| |
− | | LocationID
| |
− | | LocationID
| |
− | |- valign="top"
| |
− | | [[Production.WorkOrderRouting_(table)|Production.WorkOrderRouting]]
| |
− | | LocationID
| |
− | | LocationID
| |
− | |}
| |
− |
| |
− | === References ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Dependency Type
| |
− | | '''Object Type
| |
− | | '''Referenced Object
| |
− |
| |
− | |- valign="top"
| |
− | | Data Type
| |
− | | Type
| |
− | | [[dbo.Name_(type)|dbo.Name]]
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Schema
| |
− | | [[Production_(schema)|Production]]
| |
− |
| |
− | |}
| |
− |
| |
− |
| |
− | == wikivalues ==
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- valign="top"
| |
− | | '''Table Values
| |
− | | Production.Location
| |
− | |}
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− |
| |
− | | '''LocationID
| |
− | | '''Name
| |
− | | '''CostRate
| |
− | | '''Availability
| |
− | |- valign="top"
| |
− |
| |
− | | 1
| |
− | | Tool Crib
| |
− | | 0.00
| |
− | | 0.00
| |
− | |- valign="top"
| |
− |
| |
− | | 2
| |
− | | Sheet Metal Racks
| |
− | | 0.00
| |
− | | 0.00
| |
− | |- valign="top"
| |
− |
| |
− | | 3
| |
− | | Paint Shop
| |
− | | 0.00
| |
− | | 0.00
| |
− | |- valign="top"
| |
− |
| |
− | | 4
| |
− | | Paint Storage
| |
− | | 0.00
| |
− | | 0.00
| |
− | |- valign="top"
| |
− |
| |
− | | 5
| |
− | | Metal Storage
| |
− | | 0.00
| |
− | | 0.00
| |
− | |- valign="top"
| |
− |
| |
− | | 6
| |
− | | Miscellaneous Storage
| |
− | | 0.00
| |
− | | 0.00
| |
− | |- valign="top"
| |
− |
| |
− | | 7
| |
− | | Finished Goods Storage
| |
− | | 0.00
| |
− | | 0.00
| |
− | |- valign="top"
| |
− |
| |
− | | 10
| |
− | | Frame Forming
| |
− | | 22.50
| |
− | | 96.00
| |
− | |- valign="top"
| |
− |
| |
− | | 20
| |
− | | Frame Welding
| |
− | | 25.00
| |
− | | 108.00
| |
− | |- valign="top"
| |
− |
| |
− | | 30
| |
− | | Debur and Polish
| |
− | | 14.50
| |
− | | 120.00
| |
− | |- valign="top"
| |
− |
| |
− | | 40
| |
− | | Paint
| |
− | | 15.75
| |
− | | 120.00
| |
− | |- valign="top"
| |
− |
| |
− | | 45
| |
− | | Specialized Paint
| |
− | | 18.00
| |
− | | 80.00
| |
− | |- valign="top"
| |
− |
| |
− | | 50
| |
− | | Subassembly
| |
− | | 12.25
| |
− | | 120.00
| |
− | |- valign="top"
| |
− |
| |
− | | 60
| |
− | | Final Assembly
| |
− | | 12.25
| |
− | | 120.00
| |
− | |}
| |
− |
| |
− | == automatically generated ==
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |-
| |
− | | '''Table
| |
− | | Production.Location
| |
− | |- valign="top"
| |
− | | '''Description
| |
− | | Product inventory and manufacturing locations.
| |
− | |-
| |
− | |}
| |
− |
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Column
| |
− | | '''Data Type
| |
− | | '''Nullable
| |
− | | '''Default
| |
− | | '''Description / PK / Index
| |
− |
| |
− | |- valign="top"
| |
− | | LocationID
| |
− | | smallint
| |
− | | not null
| |
| | | | | |
− | | Primary key for Location records.<br />PK_Location_LocationID
| |
− | |- valign="top"
| |
− | | Name
| |
− | | Name
| |
− | | not null
| |
| | | | | |
− | | Location description.<br />AK_Location_Name
| |
− | |- valign="top"
| |
− | | CostRate
| |
− | | smallmoney
| |
− | | not null
| |
− | | (0.00)
| |
− | | Standard hourly cost of the manufacturing location.<br />
| |
− | |- valign="top"
| |
− | | Availability
| |
− | | decimal(8, 2)
| |
− | | not null
| |
− | | (0.00)
| |
− | | Work capacity (in hours) of the manufacturing location.<br />
| |
− | |- valign="top"
| |
− | | ModifiedDate
| |
− | | datetime
| |
− | | not null
| |
− | | (GETDATE())
| |
− | | Date and time the record was last updated.<br />
| |
| |} | | |} |
| | | |
Line 298: |
Line 71: |
| | LocationID | | | LocationID |
| | LocationID | | | LocationID |
− | |}
| |
− |
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Dependency Type
| |
− | | '''Object Type
| |
− | | '''Referenced Object
| |
− |
| |
− | |-
| |
− | | Data Type
| |
− | | Type
| |
− | | [[dbo.Name_(type)|dbo.Name]]
| |
− |
| |
− | |-
| |
− | | Schema
| |
− | | Schema
| |
− | | [[Production_(schema)|Production]]
| |
− |
| |
| |} | | |} |