public.knowledgebasecategorydata
Columns
| Name |
Type |
Default |
Nullable |
Children |
Parents |
Comment |
| id |
varchar(50) |
|
false |
|
|
|
| name |
varchar(100) |
|
true |
|
|
|
| description |
varchar(255) |
|
true |
|
|
|
| externalid |
varchar(100) |
|
true |
|
|
|
| datecreated |
timestamp without time zone |
|
true |
|
|
|
| datemodified |
timestamp without time zone |
|
true |
|
|
|
| documentcount |
integer |
|
true |
|
|
|
| knowledgebaseid |
varchar(100) |
|
true |
|
|
|
| parentcategoryid |
varchar(100) |
|
true |
|
|
|
| parentcategoryname |
varchar(100) |
|
true |
|
|
|
| updated |
timestamp without time zone |
|
true |
|
|
|
Constraints
| Name |
Type |
Definition |
| knowledgebasecategorydata_pkey |
PRIMARY KEY |
PRIMARY KEY (id) |
Indexes
| Name |
Definition |
| knowledgebasecategorydata_pkey |
CREATE UNIQUE INDEX knowledgebasecategorydata_pkey ON
public.knowledgebasecategorydata USING btree (id) |