config.kpac_topics :: EVG Database

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('config.kpac_topics_id_seq'::regclass)
active	`boolean`	No	true
parent	`integer`	Yes
img	`text`	Yes
name	`text`	No
description	`text`	Yes
content_type FK	`integer`	No		→ config.kpac_content_types(id)
content_list	`integer`	Yes
content_link	`text`	Yes
content_search	`text`	Yes
topic_order	`integer`	Yes

id PK

integer

No

nextval('config.kpac_topics_id_seq'::regclass)

active

boolean

No

true

parent

integer

Yes

img

text

Yes

name

text

No

description

text

Yes

content_type FK

integer

No

→ config.kpac_content_types(id)

content_list

integer

Yes

content_link

text

Yes

content_search

text

Yes

topic_order

integer

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`content_type`	config.kpac_content_types(id)	NO ACTION	NO ACTION	No	`kpac_topics_content_type_fkey`

content_type

config.kpac_content_types(id)

NO ACTION

No

kpac_topics_content_type_fkey

Indexes

Index Method Definition

Index	Method	Definition
`kpac_topics_pkey` PK	btree	`CREATE UNIQUE INDEX kpac_topics_pkey ON config.kpac_topics USING btree (id)`

kpac_topics_pkey PK

btree

CREATE UNIQUE INDEX kpac_topics_pkey ON config.kpac_topics USING btree (id)