| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| id |
int |
10 |
|
√ |
|
|
|
| createdBy |
int |
10 |
√ |
|
null |
|
|
| createdDate |
datetime |
19 |
√ |
|
null |
|
|
| modifiedBy |
int |
10 |
√ |
|
null |
|
|
| modifiedDate |
datetime |
19 |
√ |
|
null |
|
|
| category |
int |
10 |
√ |
|
null |
|
|
| customField |
char |
1 |
√ |
|
null |
|
|
| dataTypeId |
int |
10 |
√ |
|
null |
|
|
| description |
longtext |
2147483647 |
√ |
|
null |
|
|
| editxtype |
varchar |
255 |
√ |
|
null |
|
|
| fieldType |
int |
10 |
√ |
|
null |
|
|
| formxtype |
varchar |
255 |
√ |
|
null |
|
|
| gridxtype |
varchar |
255 |
√ |
|
null |
|
|
| isDerived |
char |
1 |
√ |
|
null |
|
|
| name |
varchar |
255 |
√ |
|
null |
|
|
| organizationId |
int |
10 |
√ |
|
null |
|
|
| readOnly |
char |
1 |
√ |
|
null |
|
|
| refId |
int |
10 |
√ |
|
null |
|
|
| scope |
int |
10 |
√ |
|
null |
|
|
| userConfigurable |
char |
1 |
√ |
|
null |
|
|
Table contained 90 rows at Wed Jan 18 17:22 PST 2012
|