public.knowledgebasecategorydata
Columns
| 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
| knowledgebasecategorydata_pkey |
PRIMARY KEY |
PRIMARY KEY (id) |
Indexes
| knowledgebasecategorydata_pkey |
CREATE UNIQUE INDEX knowledgebasecategorydata_pkey ON
public.knowledgebasecategorydata USING btree (id) |