Description
noneTable properties
Columns
| column | datatype | length | default | nulls | PK | FK | UQ | comment |
|---|
| OrderNo | Float | 8 | | no
| composite PK
| |
| |
| ItemNo | Float | 8 | | no
| composite PK
| |
| |
| PartNo | Float | 8 | | yes
|
| |
| |
| Qty | Int | 4 | | yes
|
| |
| |
| Discount | Float | 8 | | yes
|
| |
| |
Indexes
| name | description | column | comment |
|---|
| ByOrderNo | index on items | OrderNo |
|
| PartNo | index on items | PartNo |
|
| PRIMARY_KEY | primary key index on items | OrderNo, ItemNo |
|
Dependency graph
Sample rows
| OrderNo | ItemNo | PartNo | Qty | Discount |
|---|
| 1003
| 1
| 1313
| 5
| 0
|
| 1004
| 1
| 1313
| 10
| 50
|
| 1004
| 2
| 12310
| 10
| 0
|
| 1004
| 3
| 3316
| 8
| 0
|
| 1004
| 4
| 5324
| 5
| 0
|
| 1005
| 1
| 1320
| 1
| 0
|
| 1005
| 2
| 2367
| 2
| 0
|
| 1005
| 3
| 11564
| 5
| 0
|
| 1005
| 4
| 7612
| 9
| 0
|
| 1005
| 5
| 1946
| 4
| 0
|
Code
CREATE TABLE [items]
(
[OrderNo] FLOAT NOT NULL,
[ItemNo] FLOAT NOT NULL,
[PartNo] FLOAT,
[Qty] INT,
[Discount] FLOAT,
CONSTRAINT [PRIMARY_KEY] PRIMARY KEY ([OrderNo] ,[ItemNo])
);
CREATE INDEX [ByOrderNo] ON [items] ([OrderNo]);
CREATE INDEX [PartNo] ON [items] ([PartNo]);