Forj Community

Explore the interactive ERD

Table & Field Reference

user_activity_sms_reply

Column	Type	Keys
`id`	Unknown	PK
`member_id`	Unknown	FK
`receiver_id`	Unknown	FK
`comment_type`	Unknown
`content`	Unknown
`created_at`	Unknown
`deleted`	Unknown
`feed_type`	Unknown
`post_id`	Unknown
`post_name`	Unknown
`post_type`	Unknown
`target_id`	Unknown
`target_type`	Unknown

group_field_option

Column	Type	Keys
`option`	Unknown	PK
`group_field_id`	Unknown	PKFK
`group_id`	Unknown	PKFK

group_field

Column	Type	Keys
`id`	Unknown	PK
`group_id`	Unknown	PKFK
`editable`	Unknown
`name`	Unknown
`other_option_flag`	Unknown
`placeholder`	Unknown
`required`	Unknown
`type`	Unknown
`unique_name`	Unknown

group_member_posting_permission

Column	Type	Keys
`permission`	Unknown	PK
`group_id`	Unknown	PKFK

groups

Column	Type	Keys
`id`	Unknown	PK
`parent_group`	Unknown	FK
`primary_admin_user_id`	Unknown	FK
`created_at`	Unknown
`default_emails_frequency`	Unknown
`email`	Unknown
`email_comments_to_all`	Unknown
`hidden_email`	Unknown
`logo_url`	Unknown
`members_count`	Unknown
`members_visible`	Unknown
`mini_thumb_url`	Unknown
`name`	Unknown
`posts_moderation`	Unknown
`privacy`	Unknown
`requires_approval`	Unknown
`small_thumb_url`	Unknown
`thumb_url`	Unknown
`updated_at`	Unknown
`url`	Unknown

user_activity_view

Column	Type	Keys
`id`	Unknown	PK
`group_id`	Unknown	FK
`member_id`	Unknown	FK
`receiver_id`	Unknown	FK
`created_at`	Unknown
`deleted`	Unknown
`feed_type`	Unknown
`post_id`	Unknown
`post_name`	Unknown
`post_type`	Unknown
`target_id`	Unknown
`target_type`	Unknown

user_activity_pending_post

Column	Type	Keys
`id`	Unknown	PK
`group_id`	Unknown	FK
`receiver_id`	Unknown	FK
`created_at`	Unknown
`feed_type`	Unknown
`post_id`	Unknown
`post_name`	Unknown
`post_type`	Unknown
`target_id`	Unknown
`target_name`	Unknown
`target_type`	Unknown

user_activity_vote

Column	Type	Keys
`id`	Unknown	PK
`group_id`	Unknown	FK
`member_id`	Unknown	FK
`receiver_id`	Unknown	FK
`created_at`	Unknown
`deleted`	Unknown
`feed_type`	Unknown
`poll_name`	Unknown
`post_id`	Unknown
`post_type`	Unknown

user_activity_rsvp

Column	Type	Keys
`id`	Unknown	PK
`group_id`	Unknown	FK
`member_id`	Unknown	FK
`created_at`	Unknown
`deleted`	Unknown
`event_id`	Unknown
`event_name`	Unknown
`feed_type`	Unknown
`post_id`	Unknown
`post_type`	Unknown
`status`	Unknown
`target_id`	Unknown
`target_type`	Unknown

user_activity_reaction

Column	Type	Keys
`id`	Unknown	PK
`group_id`	Unknown	FK
`member_id`	Unknown	FK
`receiver_id`	Unknown	FK
`content`	Unknown
`created_at`	Unknown
`deleted`	Unknown
`feed_type`	Unknown
`item_id`	Unknown
`item_type`	Unknown
`post_id`	Unknown
`post_name`	Unknown
`post_type`	Unknown

user_activity_comment

Column	Type	Keys
`id`	Unknown	PK
`group_id`	Unknown	FK
`member_id`	Unknown	FK
`receiver_id`	Unknown	FK
`comment_type`	Unknown
`content`	Unknown
`created_at`	Unknown
`deleted`	Unknown
`feed_type`	Unknown
`post_id`	Unknown
`post_name`	Unknown
`post_type`	Unknown

user_activity

Column	Type	Keys
`id`	Unknown	PK
`group_id`	Unknown	FK
`member_id`	Unknown	FK
`receiver_id`	Unknown	FK
`conversation_id`	Unknown
`created_at`	Unknown
`deleted`	Unknown
`feed_type`	Unknown
`post_id`	Unknown
`post_name`	Unknown
`post_type`	Unknown
`target_id`	Unknown
`target_name`	Unknown
`target_type`	Unknown
`type`	Unknown

user_activity_mention

Column	Type	Keys
`id`	Unknown	PK
`group_id`	Unknown	FK
`member_id`	Unknown	FK
`receiver_id`	Unknown	FK
`content`	Unknown
`created_at`	Unknown
`deleted`	Unknown
`feed_type`	Unknown
`mention_object`	Unknown
`mentioned`	Unknown
`post_id`	Unknown
`post_name`	Unknown
`post_type`	Unknown

user_activity_add_member

Column	Type	Keys
`id`	Unknown	PK
`group_id`	Unknown	FK
`member_id`	Unknown	FK
`created_at`	Unknown
`deleted`	Unknown
`members_count`	Unknown

user_activity_post_approved

Column	Type	Keys
`id`	Unknown	PK
`group_id`	Unknown	FK
`receiver_id`	Unknown	FK
`created_at`	Unknown
`deleted`	Unknown
`feed_type`	Unknown
`post_id`	Unknown
`post_name`	Unknown
`post_type`	Unknown
`target_id`	Unknown
`target_name`	Unknown
`target_type`	Unknown

user_activity_join_group

Column	Type	Keys
`id`	Unknown	PK
`group_id`	Unknown	FK
`member_id`	Unknown	FK
`created_at`	Unknown
`deleted`	Unknown

user_activity_conversation

Column	Type	Keys
`id`	Unknown	PK
`initiator_id`	Unknown	FK
`member_id`	Unknown	FK
`participant_id`	Unknown	FK
`conversation_id`	Unknown
`created_at`	Unknown
`deleted`	Unknown

user_activity_pending_applicant

Column	Type	Keys
`id`	Unknown	PK
`group_id`	Unknown	FK
`member_id`	Unknown	FK
`created_at`	Unknown
`deleted`	Unknown

user_activity_post_message

Column	Type	Keys
`id`	Unknown	PK
`group_id`	Unknown	FK
`member_id`	Unknown	FK
`receiver_id`	Unknown	FK
`comment_type`	Unknown
`content`	Unknown
`created_at`	Unknown
`deleted`	Unknown
`feed_type`	Unknown
`post_id`	Unknown
`post_name`	Unknown
`post_type`	Unknown
`target_id`	Unknown
`target_type`	Unknown

user_activity_post

Column	Type	Keys
`id`	Unknown	PK
`group_id`	Unknown	FK
`member_id`	Unknown	FK
`receiver_id`	Unknown	FK
`content`	Unknown
`created_at`	Unknown
`deleted`	Unknown
`feed_type`	Unknown
`post_id`	Unknown
`post_name`	Unknown
`post_type`	Unknown
`target_id`	Unknown
`target_name`	Unknown
`target_type`	Unknown

user_activity_comment_reply

Column	Type	Keys
`id`	Unknown	PK
`group_id`	Unknown	FK
`member_id`	Unknown	FK
`comment_type`	Unknown
`content`	Unknown
`created_at`	Unknown
`deleted`	Unknown
`feed_type`	Unknown
`post_id`	Unknown
`post_name`	Unknown
`post_type`	Unknown
`target_id`	Unknown
`target_type`	Unknown

user_group

Column	Type	Keys
`id`	Unknown	PKFK
`user_id`	Unknown	PKFK
`is_admin`	Unknown
`last_invited_in`	Unknown
`status`	Unknown

user_custom_field

Column	Type	Keys
`name`	Unknown	PK
`users_id`	Unknown	PKFK
`value`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`avatar_mini_thumb_url`	Unknown
`avatar_small_thumb_url`	Unknown
`avatar_thumb_url`	Unknown
`avatar_url`	Unknown
`created_at`	Unknown
`email`	Unknown
`first_name`	Unknown
`is_registered`	Unknown
`last_name`	Unknown
`name`	Unknown
`updated_at`	Unknown