id |
char |
36 |
|
|
|
calls.parent_id
|
Defined in XML R |
meetings.parent_id
|
Defined in XML R |
notes.parent_id
|
Defined in XML R |
tasks.parent_id
|
Defined in XML R |
|
|
name |
varchar |
255 |
√ |
|
null |
|
|
date_entered |
datetime |
19 |
√ |
|
null |
|
|
date_modified |
datetime |
19 |
√ |
|
null |
|
|
modified_user_id |
char |
36 |
√ |
|
null |
|
users.id
|
Defined in XML R |
|
created_by |
char |
36 |
√ |
|
null |
|
users.id
|
Defined in XML R |
|
description |
text |
65535 |
√ |
|
null |
|
|
deleted |
bit |
1 |
√ |
|
0 |
|
|
kbdocument_body |
longtext |
2147483647 |
√ |
|
null |
|
|
language |
varchar |
2 |
√ |
|
null |
|
|
active_date |
date |
10 |
√ |
|
null |
|
|
exp_date |
date |
10 |
√ |
|
null |
|
|
approved |
bit |
1 |
√ |
|
0 |
|
|
status |
varchar |
100 |
√ |
|
draft |
|
|
viewcount |
int |
11 |
√ |
|
0 |
|
|
revision |
int |
11 |
√ |
|
0 |
|
|
useful |
int |
11 |
√ |
|
0 |
|
|
notuseful |
int |
11 |
√ |
|
0 |
|
|
kbdocument_id |
char |
36 |
√ |
|
null |
|
|
active_rev |
tinyint |
4 |
√ |
|
0 |
|
|
is_external |
bit |
1 |
√ |
|
0 |
|
|
kbarticle_id |
char |
36 |
√ |
|
null |
|
|
kbsapprover_id |
char |
36 |
√ |
|
null |
|
users.id
|
Defined in XML R |
|
kbscase_id |
char |
36 |
√ |
|
null |
|
cases.id
|
Defined in XML R |
|
category_id |
char |
36 |
√ |
|
null |
|
|
team_id |
char |
36 |
√ |
|
null |
|
teams.id
|
Defined in XML R |
|
team_set_id |
char |
36 |
√ |
|
null |
|
|
acl_team_set_id |
char |
36 |
√ |
|
null |
|
|
assigned_user_id |
char |
36 |
√ |
|
null |
|
users.id
|
Defined in XML R |
|