Description
noneTable properties
Columns
| column | datatype | length | default | nulls | PK | FK | UQ | comment |
|---|
| PartNo | Float | 8 | | no
| yes
| |
| |
| VendorNo | Float | 8 | | yes
|
| |
| |
| Description | Char | 30 | | yes
|
| |
| |
| OnHand | Float | 8 | | yes
|
| |
| |
| OnOrder | Float | 8 | | yes
|
| |
| |
| Cost | Money | 8 | | yes
|
| |
| |
| ListPrice | Money | 8 | | yes
|
| |
| |
Indexes
Dependency graph
Sample rows
| PartNo | VendorNo | Description | OnHand | OnOrder | Cost | ListPrice |
|---|
| 900
| 3820
| Dive kayak
| 24
| 16
| 1356.75
| 3999.95
|
| 912
| 3820
| Underwater Diver Vehicle
| 5
| 3
| 504
| 1680
|
| 1313
| 3511
| Regulator System
| 165
| 216
| 117.5
| 250
|
| 1314
| 5641
| Second Stage Regulator
| 98
| 88
| 124.1
| 365
|
| 1316
| 3511
| Regulator System
| 75
| 70
| 119.35
| 341
|
| 1320
| 3511
| Second Stage Regulator
| 37
| 35
| 73.53
| 171
|
| 1328
| 3511
| Regulator System
| 166
| 100
| 154.8
| 430
|
| 1330
| 3511
| Alternate Inflation Regulator
| 47
| 43
| 85.8
| 260
|
| 1364
| 3511
| Second Stage Regulator
| 128
| 135
| 99.9
| 270
|
| 1390
| 3511
| First Stage Regulator
| 146
| 140
| 64.6
| 170
|
Code
CREATE TABLE [parts]
(
[PartNo] FLOAT NOT NULL,
[VendorNo] FLOAT,
[Description] CHAR (30) CODE PAGE 1252,
[OnHand] FLOAT,
[OnOrder] FLOAT,
[Cost] MONEY,
[ListPrice] MONEY,
CONSTRAINT [PRIMARY_KEY] PRIMARY KEY ([PartNo])
);
CREATE INDEX [ByDescription] ON [parts] ([Description]);
CREATE INDEX [VendorNo] ON [parts] ([VendorNo]);