Description
noneTable properties
| name | value |
|---|
| name | call_type |
| created | 5/3/2009 12:00:00 AM |
| row count | 5 |
| Maximum size of a single row | 31 bytes |
Columns
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|
| call_code | char | | 1 | | yes
| yes
| |
|
| |
| code_descr | char | | 30 | | yes
|
| |
|
| |
Indexes
| name | description | column | comment |
|---|
| 106_17 | non-clustered index | call_code |
|
Referenced by
Foreign key graph
Sample rows
| call_code | code_descr |
|---|
| B
| billing error
|
| D
| damaged goods
|
| I
| incorrect merchandise sent
|
| L
| late shipment
|
| O
| other
|
Code
create table "informix".call_type
(
call_code char(1),
code_descr char(30),
primary key (call_code)
);
revoke all on "informix".call_type from "public" as "informix";