app_totara_reportedcontent

0 rows


Description

Inappropriate content reported by users

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_totara_reportedcontent_id_seq'::regclass)
target_user_id int8 19 null
app_user.id Defined in XMLR
complainer_id int8 19 null
app_user.id Defined in XMLR
reviewer_id int8 19 null
app_user.id Defined in XMLR
content text 2147483647 null
format int2 5 null
url varchar 1333 ''::character varying
time_content int8 19 null
status int2 5 null
time_created int8 19 null
time_reviewed int8 19 null
item_id int8 19 null
context_id int8 19 null
app_context.id Defined in XMLR
component varchar 100 ''::character varying
area varchar 100 ''::character varying

Indexes

Constraint Name Type Sort Column(s)
app_totarepo_id_pk Primary key Asc id
app_totarepo_com_ix Performance Asc complainer_id
app_totarepo_con_ix Performance Asc context_id
app_totarepo_rev_ix Performance Asc reviewer_id
app_totarepo_sta_ix Performance Asc status
app_totarepo_tar_ix Performance Asc target_user_id
app_totarepo_tim2_ix Performance Asc time_reviewed
app_totarepo_tim_ix Performance Asc time_created

Relationships