oc_reactions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('oc_reactions_id_seq'::regclass)
parent_id int8 19 null
message_id int8 19 null
actor_type varchar 64 ''::character varying
actor_id varchar 64 ''::character varying
reaction varchar 32 null

Indexes

Constraint Name Type Sort Column(s)
oc_reactions_pkey Primary key Asc id
comment_reaction Performance Asc reaction
comment_reaction_parent_id Performance Asc parent_id
comment_reaction_unique Must be unique Asc/Asc/Asc/Asc parent_id + actor_type + actor_id + reaction

Relationships