| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| id |
char |
36 |
|
|
|
|
|
| name |
varchar |
36 |
√ |
|
null |
|
|
| parent_id |
char |
36 |
√ |
|
null |
|
|
| start_date |
date |
10 |
√ |
|
null |
|
|
| start_date_timestamp |
int |
11 |
√ |
|
null |
|
|
| end_date |
date |
10 |
√ |
|
null |
|
|
| end_date_timestamp |
int |
11 |
√ |
|
null |
|
|
| created_by |
char |
36 |
√ |
|
null |
|
|
| date_entered |
datetime |
19 |
√ |
|
null |
|
|
| date_modified |
datetime |
19 |
√ |
|
null |
|
|
| deleted |
bit |
1 |
√ |
|
0 |
|
|
| is_fiscal |
bit |
1 |
√ |
|
0 |
|
|
| is_fiscal_year |
bit |
1 |
√ |
|
0 |
|
|
| leaf_cycle |
int |
2 |
√ |
|
null |
|
|
| type |
varchar |
255 |
√ |
|
|
|
|
Analyzed at Fri Oct 08 00:17 UTC 2021
|
