Description
noneTable properties
Columns
| column | datatype | length | default | nulls | PK | FK | UQ | comment |
|---|
| OrderNo | Float | 8 | | no
| yes
| |
| |
| CustNo | Float | 8 | | no
|
| |
| |
| SaleDate | DateTime | 8 | | yes
|
| |
| |
| ShipDate | DateTime | 8 | | yes
|
| |
| |
| EmpNo | Int | 4 | | no
|
| |
| |
| ShipToContact | Char | 20 | | yes
|
| |
| |
| ShipToAddr1 | Char | 30 | | yes
|
| |
| |
| ShipToAddr2 | Char | 30 | | yes
|
| |
| |
| ShipToCity | Char | 15 | | yes
|
| |
| |
| ShipToState | Char | 20 | | yes
|
| |
| |
| ShipToZip | Char | 10 | | yes
|
| |
| |
| ShipToCountry | Char | 20 | | yes
|
| |
| |
| ShipToPhone | Char | 15 | | yes
|
| |
| |
| ShipVIA | Char | 7 | | yes
|
| |
| |
| PO | Char | 15 | | yes
|
| |
| |
| Terms | Char | 6 | | yes
|
| |
| |
| PaymentMethod | Char | 7 | | yes
|
| |
| |
| ItemsTotal | Money | 8 | | yes
|
| |
| |
| TaxRate | Float | 8 | | yes
|
| |
| |
| Freight | Money | 8 | | yes
|
| |
| |
| AmountPaid | Money | 8 | | yes
|
| |
| |
Indexes
| name | description | column | comment |
|---|
| CustNo | index on orders | CustNo |
|
| PRIMARY_KEY | primary key index on orders | OrderNo |
|
Dependency graph
Sample rows
| OrderNo | CustNo | SaleDate | ShipDate | EmpNo | ShipToContact | ShipToAddr1 | ShipToAddr2 | ShipToCity | ShipToState | ShipToZip | ShipToCountry | ShipToPhone | ShipVIA | PO | Terms | PaymentMethod | ItemsTotal | TaxRate | Freight | AmountPaid |
|---|
| 1003
| 1351
| 4/12/1988 12:00:00 AM
| 5/3/1988 12:00:00 PM
| 114
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| UPS
| NULL
| FOB
| Credit
| 1250
| 4.5
| 0
| 0
|
| 1004
| 2156
| 4/17/1988 12:00:00 AM
| 4/18/1988 12:00:00 AM
| 145
| Maria Eventosh
| PO Box 737
| NULL
| Johannesburg
| NULL
| 2042
| Republic So. Africa
| 27-11-4432458
| DHL
| NULL
| FOB
| Check
| 7885
| 0
| 0
| 7885
|
| 1005
| 1356
| 4/20/1988 12:00:00 AM
| 1/21/1988 12:00:00 PM
| 110
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| UPS
| NULL
| FOB
| Visa
| 4807
| 0
| 0
| 4807
|
| 1006
| 1380
| 11/6/1994 12:00:00 AM
| 11/7/1988 12:00:00 PM
| 46
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| Emery
| P101324
| FOB
| Visa
| 31987
| 0
| 0
| 0
|
| 1007
| 1384
| 5/1/1988 12:00:00 AM
| 5/2/1988 12:00:00 AM
| 45
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| US Mail
| NULL
| FOB
| Visa
| 6500
| 0
| 0
| 6500
|
| 1008
| 1510
| 5/3/1988 12:00:00 AM
| 5/4/1988 12:00:00 AM
| 12
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| US Mail
| NULL
| Net 30
| Visa
| 1449.5
| 0
| 0
| 0
|
| 1009
| 1513
| 5/11/1988 12:00:00 AM
| 5/12/1988 12:00:00 AM
| 71
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| US Mail
| NULL
| Net 30
| COD
| 5587
| 0
| 0
| 0
|
| 1010
| 1551
| 5/11/1988 12:00:00 AM
| 5/12/1988 12:00:00 AM
| 46
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| UPS
| NULL
| Net 30
| COD
| 4996
| 0
| 0
| 4996
|
| 1011
| 1560
| 5/18/1988 12:00:00 AM
| 5/19/1988 12:00:00 AM
| 5
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| UPS
| NULL
| Net 30
| COD
| 2679.85
| 0
| 0
| 2679.85
|
| 1012
| 1563
| 5/19/1988 12:00:00 AM
| 5/20/1988 12:00:00 AM
| 118
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| NULL
| UPS
| NULL
| Net 30
| Credit
| 5201
| 0
| 0
| 5201
|
Code
CREATE TABLE [orders]
(
[OrderNo] FLOAT NOT NULL,
[CustNo] FLOAT NOT NULL,
[SaleDate] DATETIME,
[ShipDate] DATETIME,
[EmpNo] INT NOT NULL,
[ShipToContact] CHAR (20) CODE PAGE 1252,
[ShipToAddr1] CHAR (30) CODE PAGE 1252,
[ShipToAddr2] CHAR (30) CODE PAGE 1252,
[ShipToCity] CHAR (15) CODE PAGE 1252,
[ShipToState] CHAR (20) CODE PAGE 1252,
[ShipToZip] CHAR (10) CODE PAGE 1252,
[ShipToCountry] CHAR (20) CODE PAGE 1252,
[ShipToPhone] CHAR (15) CODE PAGE 1252,
[ShipVIA] CHAR (7) CODE PAGE 1252,
[PO] CHAR (15) CODE PAGE 1252,
[Terms] CHAR (6) CODE PAGE 1252,
[PaymentMethod] CHAR (7) CODE PAGE 1252,
[ItemsTotal] MONEY,
[TaxRate] FLOAT,
[Freight] MONEY,
[AmountPaid] MONEY,
CONSTRAINT [PRIMARY_KEY] PRIMARY KEY ([OrderNo])
);
CREATE INDEX [CustNo] ON [orders] ([CustNo]);