| name | value |
|---|---|
| name | Shippers |
| created | 9/13/1995 10:51:41 AM |
| modified | 8/16/2008 9:43:29 PM |
| row count | 3 |
| column | datatype | length | default | nulls | PK | FK | UQ | comment |
|---|---|---|---|---|---|---|---|---|
| ShipperID | long | 4 | yes | yes | Orders.ShipVia | Number automatically assigned to new shipper. | ||
| CompanyName | text | 40 | no | Name of shipping company. | ||||
| Phone | text | 24 | yes | Phone number includes country code or area code. |
| name | description | column | comment |
|---|---|---|---|
| PrimaryKey | non-clustered, unique primary key on Shippers | ShipperID |
| name |
|---|
| Orders |
| name | columns | foreign columns | type | comment |
|---|---|---|---|---|
| ShippersOrders | ShipperID | Orders.ShipVia |
| name | object type | level |
|---|---|---|
| Invoices | view | 1 |
| Invoices Filter | view | 2 |
| ShipperID | CompanyName | Phone |
|---|---|---|
| 1 | Speedy Express | (503) 555-9831 |
| 2 | United Package | (503) 555-3199 |
| 3 | Federal Shipping | (503) 555-9931 |