| DB | Areas | X-idx | Tables | Sequences | <- _Connect | _Constraint-Keys -> | HtmlDict 11 |
This table holds information about foreign table constraint definitions.
| Area | Schema Area |
|---|---|
| Dumpname | ? |
| Label | ? |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 13 | _C-Res1 | X | C-RES1 | integer [8] | >>>9 | ? | ||
| 14 | _C-Res2 | X | C-RES2 | character [8] | x(12) | ? | ||
| 2 | _Con-Active | X | Constraint Active | logical | yes/no | yes | ||
| 7 | _Con-Desc | X | Constraint Description | character | x(256) | ? | ||
| 18 | _Con-Expr | X | Constraint expression | character | x(256) | ? | ||
| 11 | _Con-Misc1 | X | Constraint Misc1 | integer [8] | >>>9 | ? | ||
| 12 | _Con-Misc2 | X | Constraint Misc2 | character [8] | x(12) | ? | ||
| 6 | _Con-Name | X | Constraint Name | character | x(32) | ? | ||
| 5 | _Con-num | X | Con-num | int64 | >>>>>>9 | ? | ||
| 4 | _Con-Status | X | Constraint Type | character | X | N | ||
| 3 | _Con-Type | X | Constraint Type | character | X | ? | ||
| 9 | _Db-recid | X | Constraint Db RecId | recid | >>>>>>>9 | ? | ||
| 15 | _Field-Recid | X | Constraint Field RecId | recid | >>>>>>>9 | 0 | ||
| 8 | _File-recid | X | Constraint File RecId | recid | >>>>>>>9 | ? | ||
| 10 | _For-Name | X | Constraint For Name | character | x(32) | ? | ||
| 17 | _Index-parent-recid | X | Constraint Index Parent RecId | recid | >>>>>>>9 | 0 | ||
| 16 | _Index-recid | X | Constraint Index RecId | recid | >>>>>>>9 | 0 |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| _Con-Num | P U | _Db-recid (+) | recid |
| _Con-num (+) | int64 | ||
| _Con-dependency | _Db-recid (+) | recid | |
| _Con-Type (+) | character | ||
| _Index-recid (+) | recid | ||
| _Index-parent-recid (+) | recid | ||
| _Con-Migrate | U | _Db-recid (+) | recid |
| _Con-Active (+) | logical | ||
| _Con-Status (+) | character | ||
| _Con-num (+) | int64 | ||
| _Con-Migration-Seq | U | _Db-recid (+) | recid |
| _Con-Active (+) | logical | ||
| _Con-Status (+) | character | ||
| _Con-Type (+) | character | ||
| _Con-num (+) | int64 | ||
| _Con-Present | U | _Db-recid (+) | recid |
| _Con-Type (+) | character | ||
| _Con-Name (+) | character | ||
| _Con-num (+) | int64 |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| generated 3-3-2025 10:54 |