aurora_standard.cgsifldd
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| module | varchar(8) | YES | MUL | |||
| prog | varchar(8) | YES | ||||
| scrid | varchar(7) | YES | ||||
| cust_key | varchar(12) | YES | ||||
| input_num | smallint(6) | YES | ||||
| seqno | smallint(6) | YES | ||||
| field_tag | varchar(6) | YES | ||||
| tabname | varchar(18) | YES | MUL | |||
| fldname | varchar(18) | YES | ||||
| fldtype | varchar(42) | YES | ||||
| fldlength | smallint(6) | YES | ||||
| f_autonext | varchar(1) | YES | ||||
| f_comments | varchar(74) | YES | ||||
| f_default | varchar(30) | YES | ||||
| f_display_like | varchar(42) | YES | ||||
| f_downshift | varchar(1) | YES | ||||
| f_format | varchar(50) | YES | ||||
| f_include | varchar(100) | YES | ||||
| f_picture | varchar(50) | YES | ||||
| f_noentry | varchar(1) | YES | ||||
| f_required | varchar(1) | YES | ||||
| f_upshift | varchar(1) | YES | ||||
| f_valid_like | varchar(42) | YES | ||||
| f_verify | varchar(1) | YES | ||||
| f_trans | varchar(10) | YES | ||||
| f_skip | varchar(1) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |
References
| Local Column | References | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| module |
| ||||||||||||||||||
| scrid |
| ||||||||||||||||||
| prog |
|