SchemaSpy - Table ss675co.kbcontents

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

team_id

char

36

√

null

teams.id

Defined in XML R

team_set_id

char

36

√

null

team_sets_teams.team_set_id	Defined in XML R
team_sets.id	Defined in XML R

id

char

36

kbcontents_audit.parent_id

Defined in XML R

kbdocument_body

longtext

2147483647

√

null

document_revision_id

char

36

√

null

date_entered

datetime

19

√

null

date_modified

datetime

19

√

null

deleted

bit

1

√

0

modified_user_id

char

36

√

null

kb_index

int

11

√

Analyzed at Wed Mar 12 08:02 UTC 2014

Indexes:

Column(s)	Type	Sort	Constraint Name
id	Primary key	Asc	PRIMARY
kb_index	Must be unique	Asc	fts_unique_idx
team_set_id	Performance	Asc	idx_kbcontents_tmst_id
kbdocument_body	Performance	Asc	kbdocument_body