app_ml_recommender_users

0 rows


Description

Suggested content for users

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_ml_recommender_users_id_seq'::regclass)
user_id int8 19 null
app_user.id Defined in XMLR
unique_id varchar 100 ''::character varying
item_id int8 19 null
component varchar 100 ''::character varying
area varchar 100 null
score numeric 20,12 null
seen int8 19 0
time_created int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_mlrecouser_id_pk Primary key Asc id
app_mlrecouser_are_ix Performance Asc area
app_mlrecouser_com_ix Performance Asc component
app_mlrecouser_sco_ix Performance Asc score
app_mlrecouser_use_ix Performance Asc user_id
app_mlrecouser_useseesco_ix Performance Asc/Asc/Asc user_id + seen + score

Relationships