Tables : act_evt_log


Columns

12

Keys

1

Triggers

0

Comment:

Description:

Indexes

0

Contraints

0


Columns :

Name Caption Primary Key type
log_nr_ log_nr_ true INTEGER
is_processed_ is_processed_ SMALLINT
type_ type_ CHARACTER VARYING(64)
proc_def_id_ proc_def_id_ CHARACTER VARYING(64)
proc_inst_id_ proc_inst_id_ CHARACTER VARYING(64)
execution_id_ execution_id_ CHARACTER VARYING(64)
task_id_ task_id_ CHARACTER VARYING(64)
time_stamp_ time_stamp_ TIMESTAMP(6)
user_id_ user_id_ CHARACTER VARYING(255)
data_ data_ BYTEA
lock_owner_ lock_owner_ CHARACTER VARYING(255)
lock_time_ lock_time_ TIMESTAMP(6)

Keys :

Name Primary Key Description
act_evt_log_pkey true

Columns Detail :

Name log_nr_
Table act_evt_log
Type INTEGER
Domain
Primary Key true
Not null true
Default Value nextval('act_evt_log_log_nr__seq'::regclass)

Name is_processed_
Table act_evt_log
Type SMALLINT
Domain
Default Value 0

Name type_
Table act_evt_log
Type CHARACTER VARYING(64)
Domain

Name proc_def_id_
Table act_evt_log
Type CHARACTER VARYING(64)
Domain

Name proc_inst_id_
Table act_evt_log
Type CHARACTER VARYING(64)
Domain

Name execution_id_
Table act_evt_log
Type CHARACTER VARYING(64)
Domain

Name task_id_
Table act_evt_log
Type CHARACTER VARYING(64)
Domain

Name time_stamp_
Table act_evt_log
Type TIMESTAMP(6)
Domain
Not null true

Name user_id_
Table act_evt_log
Type CHARACTER VARYING(255)
Domain

Name data_
Table act_evt_log
Type BYTEA
Domain

Name lock_owner_
Table act_evt_log
Type CHARACTER VARYING(255)
Domain

Name lock_time_
Table act_evt_log
Type TIMESTAMP(6)
Domain

Project

Alfresco Data model

Company

Author

Version

Copyright

Comment

Description