search_simpledb_index

0 rows


Description

search_simpledb table containing the index data.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
docid VARCHAR 255
itemid BIGINT 19 null
title LONGTEXT 2147483647 √ null
content LONGTEXT 2147483647 √ null
contextid BIGINT 19 null
context.id Implied ConstraintR
areaid VARCHAR 255
type BIT 1 null
courseid BIGINT 19 null
course.id Implied ConstraintR
owneruserid BIGINT 19 √ null
modified BIGINT 19 null
userid BIGINT 19 √ null
user.id Implied ConstraintR
description1 LONGTEXT 2147483647 √ null
description2 LONGTEXT 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
searsimpinde_doc2_uix Must be unique Asc docid
searsimpinde_owncon2_ix Performance Asc/Asc owneruserid + contextid

Relationships

Close relationships within degrees of separation