Tables : alf_activity_post


Columns

10

Keys

1

Triggers

0

Comment:

Description:

Indexes

2

Contraints

0


Columns :

Name Caption Primary Key type
sequence_id sequence_id true BIGINT
post_date post_date TIMESTAMP(6)
status status CHARACTER VARYING(10)
activity_data activity_data CHARACTER VARYING(1024)
post_user_id post_user_id CHARACTER VARYING(255)
job_task_node job_task_node INTEGER
site_network site_network CHARACTER VARYING(255)
app_tool app_tool CHARACTER VARYING(36)
activity_type activity_type CHARACTER VARYING(255)
last_modified last_modified TIMESTAMP(6)

Keys :

Name Primary Key Description
alf_activity_post_pkey true

Indexes

Name UNIQUE Type Description
post_status_idx Ascending
post_jobtasknode_idx Ascending

Columns Detail :

Name sequence_id
Table alf_activity_post
Type BIGINT
Domain
Primary Key true
Not null true

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

Name status
Table alf_activity_post
Type CHARACTER VARYING(10)
Domain
Not null true

Name activity_data
Table alf_activity_post
Type CHARACTER VARYING(1024)
Domain
Not null true

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

Name job_task_node
Table alf_activity_post
Type INTEGER
Domain
Not null true

Name site_network
Table alf_activity_post
Type CHARACTER VARYING(255)
Domain

Name app_tool
Table alf_activity_post
Type CHARACTER VARYING(36)
Domain

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

Name last_modified
Table alf_activity_post
Type TIMESTAMP(6)
Domain
Not null true

Project

Alfresco Data model

Company

Author

Version

Copyright

Comment

Description