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 3 null
courseid BIGINT 19 null
course.id Implied ConstraintR
owneruserid BIGINT 19 √ NULL
modified BIGINT 19 null
userid BIGINT 19 √ NULL
description1 LONGTEXT 2147483647 √ NULL
description2 LONGTEXT 2147483647 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
searsimpinde_are_ix Performance Asc areaid
searsimpinde_con_ix Performance Asc contextid
searsimpinde_cou_ix Performance Asc courseid
searsimpinde_doc_uix Must be unique Asc docid
searsimpinde_owncon_ix Performance Asc/Asc owneruserid + contextid

Relationships