| 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 |
|
|
| active |
char |
1 |
√ |
|
null |
|
|
| description |
longtext |
2147483647 |
√ |
|
null |
|
|
| image |
varchar |
255 |
√ |
|
null |
|
|
| isDefault |
char |
1 |
√ |
|
null |
|
|
| name |
varchar |
255 |
√ |
|
null |
|
|
| organizationId |
int |
10 |
√ |
|
null |
|
|
| refId |
int |
10 |
√ |
|
null |
|
|
| scope |
int |
10 |
√ |
|
null |
|
|
| showNote |
char |
1 |
√ |
|
null |
|
|
| showStatus |
char |
1 |
√ |
|
null |
|
|
| sortOrder |
int |
10 |
√ |
|
null |
|
|
Table contained 4 rows at Wed Jan 18 17:22 PST 2012
|
