Description
noneTable properties
| name | value |
|---|
| name | manufact |
| created | 5/3/2009 12:00:00 AM |
| row count | 9 |
| Maximum size of a single row | 854 bytes |
Columns
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|
| manu_code | char | | 3 | | yes
| yes
| |
|
| |
| manu_name | char | | 15 | | yes
|
| |
|
| |
| lead_time | interval | | 836 | | yes
|
| |
|
| |
Indexes
| name | description | column | comment |
|---|
| 102_7 | non-clustered index | manu_code |
|
Referenced by
Foreign key graph
Sample rows
| manu_code | manu_name | lead_time |
|---|
| SMT
| Smith
| 3
|
| ANZ
| Anza
| 5
|
| NRG
| Norge
| 7
|
| HSK
| Husky
| 5
|
| HRO
| Hero
| 4
|
| SHM
| Shimara
| 30
|
| KAR
| Karsten
| 21
|
| NKL
| Nikolus
| 8
|
| PRC
| ProCycle
| 9
|
Code
create table "informix".manufact
(
manu_code char(3),
manu_name char(15),
lead_time interval day(3) to day,
primary key (manu_code)
);
revoke all on "informix".manufact from "public" as "informix";