Tables : alf_activity_feed


Columns

10

Keys

1

Triggers

0

Comment:

Description:

Indexes

4

Contraints

0


Columns :

Name Caption Primary Key type
id id true BIGINT
post_id post_id BIGINT
post_date post_date TIMESTAMP(6)
activity_summary activity_summary CHARACTER VARYING(1024)
feed_user_id feed_user_id CHARACTER VARYING(255)
activity_type activity_type CHARACTER VARYING(255)
site_network site_network CHARACTER VARYING(255)
app_tool app_tool CHARACTER VARYING(36)
post_user_id post_user_id CHARACTER VARYING(255)
feed_date feed_date TIMESTAMP(6)

Keys :

Name Primary Key Description
alf_activity_feed_pkey true

Indexes

Name UNIQUE Type Description
feed_sitenetwork_idx Ascending
feed_feeduserid_idx Ascending
feed_postuserid_idx Ascending
feed_postdate_idx Ascending

Columns Detail :

Name id
Table alf_activity_feed
Type BIGINT
Domain
Primary Key true
Not null true

Name post_id
Table alf_activity_feed
Type BIGINT
Domain

Name post_date
Table alf_activity_feed
Type TIMESTAMP(6)
Domain
Not null true

Name activity_summary
Table alf_activity_feed
Type CHARACTER VARYING(1024)
Domain

Name feed_user_id
Table alf_activity_feed
Type CHARACTER VARYING(255)
Domain

Name activity_type
Table alf_activity_feed
Type CHARACTER VARYING(255)
Domain
Not null true

Name site_network
Table alf_activity_feed
Type CHARACTER VARYING(255)
Domain

Name app_tool
Table alf_activity_feed
Type CHARACTER VARYING(36)
Domain

Name post_user_id
Table alf_activity_feed
Type CHARACTER VARYING(255)
Domain
Not null true

Name feed_date
Table alf_activity_feed
Type TIMESTAMP(6)
Domain
Not null true

Project

Alfresco Data model

Company

Author

Version

Copyright

Comment

Description