Description
noneTable properties
| name | value |
|---|
| name | orders |
| created | 5/3/2009 12:00:00 AM |
| row count | 23 |
| Maximum size of a single row | 3,659 bytes |
Columns
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|
| order_num | serial | | 4 | | no
| yes
| |
|
| |
| order_date | date | | 4 | | yes
|
| |
|
| |
| customer_num | integer | | 4 | | no
|
| customer.customer_num
|
|
| |
| ship_instruct | char | | 40 | | yes
|
| |
|
| |
| backlog | char | | 1 | | yes
|
| |
|
| |
| po_num | char | | 10 | | yes
|
| |
|
| |
| ship_date | date | | 4 | | yes
|
| |
|
| |
| ship_weight | decimal | | 2050 | | yes
|
| |
|
| |
| ship_charge | money | | 1538 | | yes
|
| |
|
| |
| paid_date | date | | 4 | | yes
|
| |
|
| |
Indexes
| name | description | column | comment |
|---|
| 101_3 | non-clustered index | order_num |
|
| 101_4 | non-clustered index | customer_num |
|
References
Referenced by
Foreign key graph
Foreign keys
| name | column | comment |
|---|
| r101_4 | customer_num | |
Sample rows
| order_num | order_date | customer_num | ship_instruct | backlog | po_num | ship_date | ship_weight | ship_charge | paid_date |
|---|
| 1001
| 5/20/1998 12:00:00 AM
| 104
| express
| n
| B77836
| 6/1/1998 12:00:00 AM
| 20.40
| 10
| 7/22/1998 12:00:00 AM
|
| 1002
| 5/21/1998 12:00:00 AM
| 101
| PO on box; deliver to back door only
| n
| 9270
| 5/26/1998 12:00:00 AM
| 50.60
| 15.3
| 6/3/1998 12:00:00 AM
|
| 1003
| 5/22/1998 12:00:00 AM
| 104
| express
| n
| B77890
| 5/23/1998 12:00:00 AM
| 35.60
| 10.8
| 6/14/1998 12:00:00 AM
|
| 1004
| 5/22/1998 12:00:00 AM
| 106
| ring bell twice
| y
| 8006
| 5/30/1998 12:00:00 AM
| 95.80
| 19.2
|
|
| 1005
| 5/24/1998 12:00:00 AM
| 116
| call before delivery
| n
| 2865
| 6/9/1998 12:00:00 AM
| 80.80
| 16.2
| 6/21/1998 12:00:00 AM
|
| 1006
| 5/30/1998 12:00:00 AM
| 112
| after 10 am
| y
| Q13557
|
| 70.80
| 14.2
|
|
| 1007
| 5/31/1998 12:00:00 AM
| 117
|
| n
| 278693
| 6/5/1998 12:00:00 AM
| 125.90
| 25.2
|
|
| 1008
| 6/7/1998 12:00:00 AM
| 110
| closed Monday
| y
| LZ230
| 7/6/1998 12:00:00 AM
| 45.60
| 13.8
| 7/21/1998 12:00:00 AM
|
| 1009
| 6/14/1998 12:00:00 AM
| 111
| next door to grocery
| n
| 4745
| 6/21/1998 12:00:00 AM
| 20.40
| 10
| 8/21/1998 12:00:00 AM
|
| 1010
| 6/17/1998 12:00:00 AM
| 115
| deliver 776 King St. if no answer
| n
| 429Q
| 6/29/1998 12:00:00 AM
| 40.60
| 12.3
| 8/22/1998 12:00:00 AM
|
Code
create table "informix".orders
(
order_num serial not null ,
order_date date,
customer_num integer not null ,
ship_instruct char(40),
backlog char(1),
po_num char(10),
ship_date date,
ship_weight decimal(8,2),
ship_charge money(6,2),
paid_date date,
primary key (order_num)
);
revoke all on "informix".orders from "public" as "informix";
alter table "informix".orders add constraint (foreign key (customer_num)
references "informix".customer );