Description
Shipping company lookup table.
Table properties
| name | value |
|---|
| name | [Purchasing].[ShipMethod] |
| created | Mar 19 2009 9:08PM |
| modified | Mar 19 2009 9:08PM
|
| ansi nulls | on
|
| quoted identifier | on
|
| row count | 5 |
| Size of data | 8 kb |
| Size of indexes | 40 kb |
| Maximum size of a single row | 244 bytes |
Columns
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|
| ShipMethodID | int identity(1,1) | 10 | 4 | | no
| yes
| |
| no
| Primary key for ShipMethod records.
|
| Name | Name | 50 | 200 | | no
|
| |
| no
| Shipping company name.
|
| ShipBase | money | 19 | 8 | ((0.00)) | no
|
| |
| no
| Minimum shipping charge.
|
| ShipRate | money | 19 | 8 | ((0.00)) | no
|
| |
| no
| Shipping charge per pound.
|
| rowguid | uniqueidentifier | 36 | 16 | (newid()) | no
|
| |
| no
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
| ModifiedDate | datetime | 23 | 8 | (getdate()) | no
|
| |
| no
| Date and time the record was last updated.
|
Indexes
| name | description | column | comment |
|---|
| AK_ShipMethod_Name | nonclustered, unique located on PRIMARY | Name | Unique nonclustered index.
|
| AK_ShipMethod_rowguid | nonclustered, unique located on PRIMARY | rowguid | Unique nonclustered index. Used to support replication samples.
|
| PK_ShipMethod_ShipMethodID | clustered, unique, primary key located on PRIMARY | ShipMethodID | Clustered index created by a primary key constraint.
|
Referenced by
Foreign key graph
Check constraints
Defaults
Dependency graph
Objects that [Purchasing].[ShipMethod] depends on
| name | object type | level |
|---|
| Name | type | 1 |
Sample rows
| ShipMethodID | Name | ShipBase | ShipRate | rowguid | ModifiedDate |
|---|
| 1
| XRQ - TRUCK GROUND
| 3.9500
| 0.9900
| 6be756d9-d7be-4463-8f2c-ae60c710d606
| 6/1/1998 12:00:00 AM
|
| 2
| ZY - EXPRESS
| 9.9500
| 1.9900
| 3455079b-f773-4dc6-8f1e-2a58649c4ab8
| 6/1/1998 12:00:00 AM
|
| 3
| OVERSEAS - DELUXE
| 29.9500
| 2.9900
| 22f4e461-28cf-4ace-a980-f686cf112ec8
| 6/1/1998 12:00:00 AM
|
| 4
| OVERNIGHT J-FAST
| 21.9500
| 1.2900
| 107e8356-e7a8-463d-b60c-079fff467f3f
| 6/1/1998 12:00:00 AM
|
| 5
| CARGO TRANSPORT 5
| 8.9900
| 1.4900
| b166019a-b134-4e76-b957-2b0490c610ed
| 6/1/1998 12:00:00 AM
|
Code
CREATE TABLE [Purchasing].[ShipMethod](
[ShipMethodID] [int] IDENTITY(1,1) NOT NULL,
[Name] [dbo].[Name] NOT NULL,
[ShipMethodID] [int] IDENTITY(1,1) NOT NULL,
[ShipBase] [money] NOT NULL,
[ShipRate] [money] NOT NULL,
[rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL,
[ModifiedDate] [datetime] NOT NULL,
CONSTRAINT [PK_ShipMethod_ShipMethodID] PRIMARY KEY CLUSTERED
(
[ShipMethodID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE [Purchasing].[ShipMethod] WITH CHECK ADD CONSTRAINT [CK_ShipMethod_ShipBase] CHECK (([ShipBase]>(0.00)))
ALTER TABLE [Purchasing].[ShipMethod] CHECK CONSTRAINT [CK_ShipMethod_ShipBase]
ALTER TABLE [Purchasing].[ShipMethod] WITH CHECK ADD CONSTRAINT [CK_ShipMethod_ShipRate] CHECK (([ShipRate]>(0.00)))
ALTER TABLE [Purchasing].[ShipMethod] CHECK CONSTRAINT [CK_ShipMethod_ShipRate]
ALTER TABLE [Purchasing].[ShipMethod] ADD CONSTRAINT [DF_ShipMethod_ShipBase] DEFAULT ((0.00)) FOR [ShipBase]
ALTER TABLE [Purchasing].[ShipMethod] ADD CONSTRAINT [DF_ShipMethod_ShipRate] DEFAULT ((0.00)) FOR [ShipRate]
ALTER TABLE [Purchasing].[ShipMethod] ADD CONSTRAINT [DF_ShipMethod_rowguid] DEFAULT (newid()) FOR [rowguid]
ALTER TABLE [Purchasing].[ShipMethod] ADD CONSTRAINT [DF_ShipMethod_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]