Database ERD (2.0.1)

Bricolage 2.0.1 Database Entity Relation Diagram (3576×2318 PNG)

Table action
id	serial NOT NULL
ord	int2 NOT NULL
server_type__id	int4 NOT NULL
action_type__id	int4 NOT NULL
active	bool NOT NULL DEFO true
Indexes
pk_action__id primary key	( id)
fkx_action_type__action	( action_type__id)
fkx_server_type__action	( server_type__id)
Foreign Keys
fk_action_type__action	( action_type__id ) ref action_type ( id )
fk_server_type__action	( server_type__id ) ref server_type ( id )

Table action_type
id	serial NOT NULL
name	varchar( 64 ) NOT NULL
description	varchar( 256 )
active	bool NOT NULL DEFO ‘false’
Indexes
pk_action_type__id primary key	( id)

Table action_type__media_type
action_type__id	int4 NOT NULL
media_type__id	int4 NOT NULL
Indexes
pk_action__media_type primary key	( action_type__id, media_type__id)
fkx_action_type__at_mt	( action_type__id)
fkx_media_type__at_mt	( media_type__id)
Foreign Keys
fk_action_type__at_mt	( action_type__id ) ref action_type ( id )
fk_media_type__at_mt	( media_type__id ) ref media_type ( id )

Table addr
id	serial NOT NULL
org__id	int4 NOT NULL
type	varchar( 64 )
active	bool NOT NULL DEFO ‘true’
Indexes
pk_addr__id primary key	( id)
fkx_org__addr	( org__id)
Foreign Keys
fk_org__addr	( org__id ) ref org ( id )

Table addr_part
id	serial NOT NULL
addr__id	int4 NOT NULL
addr_part_type__id	int4 NOT NULL
value	varchar( 256 ) NOT NULL
Indexes
pk_addr_part__id primary key	( id)
fkx_addr__addr_part	( addr__id)
fkx_addr_part_type__addr_part	( addr_part_type__id)
Foreign Keys
fk_addr__addr_part	( addr__id ) ref addr ( id )
fk_addr_part_type__addr_part	( addr_part_type__id ) ref addr_part_type ( id )

Table addr_part_type
id	serial NOT NULL
name	varchar( 64 ) NOT NULL
active	bool NOT NULL DEFO ‘true’
Indexes
pk_addr_part_type__id primary key	( id)

Table alert
id	serial NOT NULL
alert_type__id	int4 NOT NULL
event__id	int4 NOT NULL
subject	varchar( 128 )
message	varchar( 512 )
timestamp	timestamp NOT NULL DEFO ‘now()’
Indexes
pk_alert__id primary key	( id)
fkx_alert_type__alert	( alert_type__id)
fkx_event__alert	( event__id)
idx_alert__timestamp	( timestamp)
Foreign Keys
fk_alert_type__alert	( alert_type__id ) ref alert_type ( id )
fk_event__alert	( event__id ) ref event ( id )

Table alert_type
id	serial NOT NULL
event_type__id	int4 NOT NULL
usr__id	int4 NOT NULL
name	varchar( 64 ) NOT NULL
subject	varchar( 128 )
message	varchar( 512 )
active	bool NOT NULL DEFO ‘true’
del	bool NOT NULL DEFO false
Indexes
pk_alert_type__id primary key	( id)
fkx_event_type__alert_type	( event_type__id)
fkx_usr__alert_type	( usr__id)
Foreign Keys
fk_event_type__alert_type	( event_type__id ) ref event_type ( id )
fk_usr__alert_type	( usr__id ) ref usr ( id )

Table alert_type__grp__contact
alert_type__id	int4 NOT NULL
contact__id	int4 NOT NULL
grp__id	int4 NOT NULL
Indexes
pk_alert_type__grp__contact primary key	( alert_type__id, contact__id, grp__id)
fkx_alert_type__grp__contact	( alert_type__id)
fkx_contact__grp__contact	( contact__id)
fkx_grp__grp__contact	( grp__id)
Foreign Keys
fk_alert_type__grp__contact	( alert_type__id ) ref alert_type ( id )
fk_contact__grp__contact	( contact__id ) ref contact ( id )
fk_grp__grp__contact	( grp__id ) ref grp ( id )

Table alert_type__usr__contact
alert_type__id	int4 NOT NULL
usr__id	int4 NOT NULL
contact__id	int4 NOT NULL
Indexes
pk_alert_type__usr__contact primary key	( alert_type__id, usr__id, contact__id)
fkx_alert_type__at_user__cont	( alert_type__id)
fkx_contact__at_usr__contact	( contact__id)
fkx_usr__at_usr__contact	( usr__id)
Foreign Keys
fk_alert_type__at_user__cont	( alert_type__id ) ref alert_type ( id )
fk_contact__at_usr__contact	( contact__id ) ref contact ( id )
fk_usr__at_usr__contact	( usr__id ) ref usr ( id )

Table alert_type_member
id	serial NOT NULL
object_id	int4 NOT NULL
member__id	int4 NOT NULL
Indexes
pk_alert_type_member__id primary key	( id)
fkx_alert_type__alert_type_member	( object_id)
fkx_member__alert_type_member	( member__id)
Foreign Keys
fk_alert_type__alert_type_member	( object_id ) ref alert_type ( id )
fk_member__alert_type_member	( member__id ) ref member ( id )

Table alert_type_rule
id	serial NOT NULL
alert_type__id	int4 NOT NULL
attr	varchar( 64 ) NOT NULL
operator	bpchar NOT NULL
value	varchar( 256 ) NOT NULL
Indexes
pk_alert_type_rule__id primary key	( id)
fkx_alert_type__at_rule	( alert_type__id)
Foreign Keys
fk_alert_type__at_rule	( alert_type__id ) ref alert_type ( id )

Table alerted
id	serial NOT NULL
usr__id	int4 NOT NULL
alert__id	int4 NOT NULL
ack_time	timestamp
Indexes
pk_alerted__id primary key	( id)
fkx_alert__alerted	( alert__id)
fkx_usr__alerted	( usr__id)
idx_alerted__ack_time	( ack_time)
Foreign Keys
fk_alert__alerted	( alert__id ) ref alert ( id )
fk_usr__alerted	( usr__id ) ref usr ( id )

Table alerted__contact_value
alerted__id	int4 NOT NULL
contact__id	int4 NOT NULL
contact_value__value	varchar( 256 ) NOT NULL
sent_time	timestamp
Indexes
pk_alerted__contact_value primary key	( alerted__id, contact__id, contact_value__value)
fkx_alerted__alerted__contact	( alerted__id)
fkx_contact__alerted__cont	( contact__id)
idx_ac_value__cv__value	( contact_value__value)
idx_ac_value__sent_time	( sent_time)
Foreign Keys
fk_alerted__alerted__contact	( alerted__id ) ref alerted ( id )
fk_contact__alerted__cont	( contact__id ) ref contact ( id )

Table at_type
id	serial NOT NULL
name	varchar( 64 ) NOT NULL
description	varchar( 256 )
top_level	bool NOT NULL DEFO ‘false’
paginated	bool NOT NULL DEFO false
fixed_url	bool NOT NULL DEFO false
related_story	bool NOT NULL DEFO false
related_media	bool NOT NULL DEFO false
media	bool NOT NULL DEFO false
biz_class__id	int4 NOT NULL
active	bool NOT NULL DEFO true
Indexes
pk_at_type__id primary key	( id)
fkx_class__at_type	( biz_class__id)
Foreign Keys
fk_class__at_type	( biz_class__id ) ref class ( id )

Table at_type_member
id	serial NOT NULL
object_id	int4 NOT NULL
member__id	int4 NOT NULL
Indexes
pk_at_type_member__id primary key	( id)
fkx_at_type__at_type_member	( object_id)
fkx_member__at_type_member	( member__id)
Foreign Keys
fk_at_type__at_type_member	( object_id ) ref at_type ( id )
fk_member__at_type_member	( member__id ) ref member ( id )

Table attr_action
id	serial NOT NULL
subsys	varchar( 256 ) NOT NULL
name	varchar( 256 ) NOT NULL
sql_type	varchar( 30 ) NOT NULL
active	bool NOT NULL DEFO ‘true’
Indexes
pk_attr_action__id primary key	( id)
udx_attr_action__subsys__name unique	( subsys, name)

Table attr_action_meta
id	serial NOT NULL
attr__id	int4 NOT NULL
name	varchar( 256 ) NOT NULL
value	varchar( 2048 )
active	bool NOT NULL DEFO ‘true’
Indexes
pk_attr_action_meta__id primary key	( id)
udx_attr_action_meta__attr_name unique	( attr__id, name)
fkx_attr_action__attr_action_meta	( attr__id)
Foreign Keys
fk_attr_action__attr_action_meta	( attr__id ) ref attr_action ( id )

Table attr_action_val
id	serial NOT NULL
object__id	int4 NOT NULL
attr__id	int4 NOT NULL
date_val	timestamp
short_val	varchar( 1024 )
blob_val	text
serial	bool DEFO ‘false’
active	bool NOT NULL DEFO true
Indexes
pk_attr_action_val__id primary key	( id)
udx_attr_action_val__obj_attr unique	( object__id, attr__id)
fkx_action__attr_action_val	( object__id)
fkx_attr_action__attr_action_val	( attr__id)
Foreign Keys
fk_action__attr_action_val	( object__id ) ref action ( id )
fk_attr_action__attr_action_val	( attr__id ) ref attr_action ( id )

Table attr_category
id	serial NOT NULL
subsys	varchar( 256 ) NOT NULL
name	varchar( 256 ) NOT NULL
sql_type	varchar( 30 ) NOT NULL
active	bool NOT NULL DEFO ‘true’
Indexes
pk_attr_category__id primary key	( id)
udx_attr_cat__subsys__name unique	( subsys, name)

Table attr_category_meta
id	serial NOT NULL
attr__id	int4 NOT NULL
name	varchar( 256 ) NOT NULL
value	varchar( 2048 )
active	bool NOT NULL DEFO ‘true’
Indexes
pk_attr_category_meta__id primary key	( id)
udx_attr_cat_meta__attr_name unique	( attr__id, name)
fkx_attr_cat__attr_cat_meta	( attr__id)
Foreign Keys
fk_attr_cat__attr_cat_meta	( attr__id ) ref attr_category ( id )

Table attr_category_val
id	serial NOT NULL
object__id	int4 NOT NULL
attr__id	int4 NOT NULL
date_val	timestamp
short_val	varchar( 1024 )
blob_val	text
serial	bool DEFO ‘false’
active	bool NOT NULL DEFO true
Indexes
pk_attr_category_val__id primary key	( id)
udx_attr_cat_val__obj_attr unique	( object__id, attr__id)
fkx_attr_cat__attr_cat_val	( attr__id)
fkx_cat__attr_cat_val	( object__id)
Foreign Keys
fk_attr_cat__attr_cat_val	( attr__id ) ref attr_category ( id )
fk_cat__attr_cat_val	( object__id ) ref category ( id )

Table attr_element_type
id	serial NOT NULL
subsys	varchar( 256 ) NOT NULL
name	varchar( 256 ) NOT NULL
sql_type	varchar( 30 ) NOT NULL
active	bool NOT NULL DEFO ‘true’
Indexes
pk_attr_element_type__id primary key	( id)
udx_attr_et__subsys__name unique	( subsys, name)

Table attr_element_type_meta
id	serial NOT NULL
attr__id	int4 NOT NULL
name	varchar( 256 ) NOT NULL
value	varchar( 2048 )
active	bool NOT NULL DEFO ‘true’
Indexes
pk_attr_element_type_meta__id primary key	( id)
udx_attr_et_meta__attr_name unique	( attr__id, name)
fkx_attr_et__attr_et_meta	( attr__id)
Foreign Keys
fk_attr_et__attr_et_meta	( attr__id ) ref attr_element_type ( id )

Table attr_element_type_val
id	serial NOT NULL
object__id	int4 NOT NULL
attr__id	int4 NOT NULL
date_val	timestamp
short_val	varchar( 1024 )
blob_val	text
serial	bool DEFO ‘false’
active	bool NOT NULL DEFO true
Indexes
pk_attr_element_type_val__id primary key	( id)
udx_attr_et_val__obj_attr unique	( object__id, attr__id)
fkx_attr_et__attr_et_val	( attr__id)
fkx_et__attr_et_val	( object__id)
Foreign Keys
fk_attr_et__attr_et_val	( attr__id ) ref attr_element_type ( id )
fk_et__attr_et_val	( object__id ) ref element_type ( id )

Table attr_field_type
id	serial NOT NULL
subsys	varchar( 256 ) NOT NULL
name	varchar( 256 ) NOT NULL
sql_type	varchar( 30 ) NOT NULL
active	bool NOT NULL DEFO ‘true’
Indexes
pk_attr_field_type__id primary key	( id)
udx_attr_field_type__subsys__name unique	( subsys, name)

Table attr_field_type_meta
id	serial NOT NULL
attr__id	int4 NOT NULL
name	varchar( 256 ) NOT NULL
value	text
active	bool NOT NULL DEFO ‘true’
Indexes
pk_attr_field_type_meta__id primary key	( id)
udx_attr_field_type_meta__attr_name unique	( attr__id, name)
fkx_attr_field_type__attr_field_type_meta	( attr__id)
Foreign Keys
fk_attr_field_type__attr_field_type_meta	( attr__id ) ref attr_field_type ( id )

Table attr_field_type_val
id	serial NOT NULL
object__id	int4 NOT NULL
attr__id	int4 NOT NULL
date_val	timestamp
short_val	varchar( 1024 )
blob_val	text
serial	bool DEFO ‘false’
active	bool NOT NULL DEFO true
Indexes
pk_attr_field_type_val__id primary key	( id)
udx_attr_field_type_val__obj_attr unique	( object__id, attr__id)
fkx_attr_field_type__attr_field_type_val	( attr__id)
fkx_field_type__attr_field_type_val	( object__id)
Foreign Keys
fk_attr_field_type__attr_field_type_val	( attr__id ) ref attr_field_type ( id )
fk_field_type__attr_field_type_val	( object__id ) ref field_type ( id )

Table attr_grp
id	serial NOT NULL
subsys	varchar( 256 ) NOT NULL
name	varchar( 256 ) NOT NULL
sql_type	varchar( 30 ) NOT NULL
active	bool NOT NULL DEFO ‘true’
Indexes
pk_attr_grp__id primary key	( id)
udx_attr_grp__subsys__name unique	( subsys, name)

Table attr_grp_meta
id	serial NOT NULL
attr__id	int4 NOT NULL
name	varchar( 256 ) NOT NULL
value	varchar( 2048 )
active	bool NOT NULL DEFO ‘true’
Indexes
pk_attr_grp_meta__id primary key	( id)
udx_attr_grp_meta__attr_name unique	( attr__id, name)
fkx_attr_grp__attr_grp_meta	( attr__id)
Foreign Keys
fk_attr_grp__attr_grp_meta	( attr__id ) ref attr_grp ( id )

Table attr_grp_val
id	serial NOT NULL
object__id	int4 NOT NULL
attr__id	int4 NOT NULL
date_val	timestamp
short_val	varchar( 1024 )
blob_val	text
serial	bool DEFO ‘false’
active	bool NOT NULL DEFO true
Indexes
pk_attr_grp_val__id primary key	( id)
udx_attr_grp_val__obj_attr unique	( object__id, attr__id)
fkx_attr_grp__attr_grp_val	( attr__id)
fkx_grp__attr_grp_val	( object__id)
Foreign Keys
fk_attr_grp__attr_grp_val	( attr__id ) ref attr_grp ( id )
fk_grp__attr_grp_val	( object__id ) ref grp ( id )

Table attr_member
id	int4 NOT NULL
subsys	varchar( 256 ) NOT NULL
name	varchar( 256 ) NOT NULL
sql_type	varchar( 30 ) NOT NULL
active	bool NOT NULL DEFO ‘true’
Indexes
pk_attr_member__id primary key	( id)
udx_attr_member__subsys__name unique	( subsys, name)

Table attr_member_meta
id	int4 NOT NULL
attr__id	int4 NOT NULL
name	varchar( 256 ) NOT NULL
value	varchar( 2048 )
active	bool NOT NULL DEFO ‘true’
Indexes
pk_attr_member_meta__id primary key	( id)
udx_attr_member_meta__attr_name unique	( attr__id, name)
fkx_attr_member__attr_member_meta	( attr__id)
Foreign Keys
fk_attr_member__attr_member_meta	( attr__id ) ref attr_member ( id )

Table attr_member_val
id	int4 NOT NULL
object__id	int4 NOT NULL
attr__id	int4 NOT NULL
date_val	timestamp
short_val	varchar( 1024 )
blob_val	text
serial	bool DEFO ‘false’
active	bool NOT NULL DEFO true
Indexes
pk_attr_member_val__id primary key	( id)
udx_attr_member_val__obj_attr unique	( object__id, attr__id)
fkx_attr_member__attr_member_val	( attr__id)
fkx_member__attr_member_val	( object__id)
Foreign Keys
fk_attr_member__attr_member_val	( attr__id ) ref attr_member ( id )
fk_member__attr_member_val	( object__id ) ref member ( id )

Table category
id	serial NOT NULL
site__id	int4 NOT NULL
directory	varchar( 128 ) NOT NULL
uri	varchar( 256 ) NOT NULL
name	varchar( 128 )
description	varchar( 256 )
parent_id	int4 NOT NULL
asset_grp_id	int4 NOT NULL
active	bool NOT NULL DEFO true
Indexes
pk_category__id primary key	( id)
udx_category__site_uri unique	( site__id, uri)
fkx_asset_grp__category	( asset_grp_id)
fkx_category__site	( site__id)
idx_category__parent_id	( parent_id)
idx_category__uri	( uri)
Foreign Keys
fk_asset_grp__category	( asset_grp_id ) ref grp ( id )
fk_category__site	( site__id ) ref site ( id )

Table category_keyword
category_id	int4 NOT NULL
keyword_id	int4 NOT NULL
Indexes
pk_category_keyword primary key	( category_id, keyword_id)
fkx_category__category_keyword	( category_id)
fkx_keyword__category_keyword	( keyword_id)
Foreign Keys
fk_category__category_keyword	( category_id ) ref category ( id )
fk_keyword__category_keyword	( keyword_id ) ref keyword ( id )

Table category_member
id	serial NOT NULL
object_id	int4 NOT NULL
member__id	int4 NOT NULL
Indexes
pk_category_member__id primary key	( id)
fkx_category__category_member	( object_id)
fkx_member__category_member	( member__id)
Foreign Keys
fk_category__category_member	( object_id ) ref category ( id )
fk_member__category_member	( member__id ) ref member ( id )

Table class
id	serial NOT NULL
key_name	varchar( 32 ) NOT NULL
pkg_name	varchar( 128 ) NOT NULL
disp_name	varchar( 128 ) NOT NULL
plural_name	varchar( 128 ) NOT NULL
description	varchar( 256 )
distributor	bool NOT NULL DEFO ‘false’
Indexes
pk_class__id primary key	( id)

Table contact
id	serial NOT NULL
type	varchar( 64 ) NOT NULL
description	varchar( 256 )
active	bool NOT NULL DEFO ‘true’
alertable	bool NOT NULL DEFO false
Indexes
pk_contact__id primary key	( id)

Table contact_value
id	serial NOT NULL
contact__id	int4 NOT NULL
value	varchar( 256 ) NOT NULL
active	bool NOT NULL DEFO ‘true’
Indexes
pk_contact_value__id primary key	( id)
fkx_contact__contact_value	( contact__id)
Foreign Keys
fk_contact__contact_value	( contact__id ) ref contact ( id )

Table contrib_type_member
id	serial NOT NULL
object_id	int4 NOT NULL
member__id	int4 NOT NULL
Indexes
pk_contrib_type_member__id primary key	( id)
fkx_contrib_type__ctype_member	( object_id)
fkx_member__ctype_member	( member__id)
Foreign Keys
fk_contrib_type__ctype_member	( object_id ) ref grp ( id )
fk_member__ctype_member	( member__id ) ref member ( id )

Table desk
id	serial NOT NULL
name	varchar( 64 ) NOT NULL
description	varchar( 256 )
pre_chk_rules	int4
post_chk_rules	int4
asset_grp	int4
publish	bool NOT NULL DEFO false
active	bool NOT NULL DEFO true
Indexes
pk_desk__id primary key	( id)
fkx_asset_grp__desk	( asset_grp)
fkx_post_grp__desk	( post_chk_rules)
fkx_pre_grp__desk	( pre_chk_rules)
Foreign Keys
fk_pre_grp__desk	( pre_chk_rules ) ref grp ( id )
fk_post_grp__desk	( post_chk_rules ) ref grp ( id )
fk_asset_grp__desk	( asset_grp ) ref grp ( id )

Table desk_member
id	serial NOT NULL
object_id	int4 NOT NULL
member__id	int4 NOT NULL
Indexes
pk_desk_member__id primary key	( id)
fkx_desk__desk_member	( object_id)
fkx_member__desk_member	( member__id)
Foreign Keys
fk_desk__desk_member	( object_id ) ref desk ( id )
fk_member__desk_member	( member__id ) ref member ( id )

Table dest_member
id	serial NOT NULL
object_id	int4 NOT NULL
member__id	int4 NOT NULL
Indexes
pk_dest_member__id primary key	( id)
fkx_dest__dest_member	( object_id)
fkx_member__dest_member	( member__id)
Foreign Keys
fk_member__dest_member	( member__id ) ref member ( id )
fk_dest__dest_member	( object_id ) ref server_type ( id )

Table element_type
id	serial NOT NULL
name	varchar( 64 ) NOT NULL
key_name	varchar( 64 ) NOT NULL
description	varchar( 256 )
top_level	bool NOT NULL DEFO ‘false’
paginated	bool NOT NULL DEFO false
fixed_uri	bool NOT NULL DEFO false
related_story	bool NOT NULL DEFO false
related_media	bool NOT NULL DEFO false
displayed	bool NOT NULL DEFO false
media	bool NOT NULL DEFO false
biz_class__id	int4 NOT NULL
type__id	int4
active	bool NOT NULL DEFO true
Indexes
pk_element_type__id primary key	( id)
fkx_class__element_type	( biz_class__id)
fkx_et_type__element_type	( type__id)
Foreign Keys
fk_at_type__element	( type__id ) ref at_type ( id )
fk_class__element_type	( biz_class__id ) ref class ( id )

Table element_type__output_channel
id	serial NOT NULL
element_type__id	int4 NOT NULL
output_channel__id	int4 NOT NULL
enabled	bool NOT NULL DEFO true
active	bool NOT NULL DEFO true
Indexes
pk_element_type__output_channel__id primary key	( id)
udx_et_oc_id__et__oc_id unique	( element_type__id, output_channel__id)
fkx_element__et_oc	( element_type__id)
fkx_output_channel__et_oc	( output_channel__id)
Foreign Keys
fk_element_type__et_oc	( element_type__id ) ref element_type ( id )
fk_output_channel__et_oc	( output_channel__id ) ref output_channel ( id )

Table element_type__site
id	serial NOT NULL
element_type__id	int4 NOT NULL
site__id	int4 NOT NULL
active	bool NOT NULL DEFO true
primary_oc__id	int4 NOT NULL
Indexes
pk_element_type__site__id primary key	( id)
udx_element_type__site unique	( element_type__id, site__id)
fkx_et__et__site__element_type__id	( element_type__id)
fkx_output_channel__et__site	( primary_oc__id)
fkx_site__et__site__site__id	( site__id)
Foreign Keys
fk_element_type__et__site__et__id	( element_type__id ) ref element_type ( id )
fk_output_channel__et__site	( primary_oc__id ) ref output_channel ( id )
fk_site__et__site__site__id	( site__id ) ref site ( id )

Table element_type_member
id	serial NOT NULL
object_id	int4 NOT NULL
member__id	int4 NOT NULL
Indexes
pk_element_type_member__id primary key	( id)
fkx_element_type__et_member	( object_id)
fkx_member__et_member	( member__id)
Foreign Keys
fk_element__et_member	( object_id ) ref element_type ( id )
fk_member__et_member	( member__id ) ref member ( id )

Table event
id	serial NOT NULL
event_type__id	int4 NOT NULL
usr__id	int4 NOT NULL
obj_id	int4 NOT NULL
timestamp	timestamp NOT NULL DEFO (timeofday())::timestamp with time zone
Indexes
pk_event__id primary key	( id)
fkx_event_type__event	( event_type__id)
fkx_usr__event	( usr__id)
idx_event__obj_id	( obj_id)
idx_event__timestamp	( timestamp)
Foreign Keys
fk_event_type__event	( event_type__id ) ref event_type ( id )
fk_usr__event	( usr__id ) ref usr ( id )

Table event_attr
id	serial NOT NULL
event__id	int4 NOT NULL
event_type_attr__id	int4 NOT NULL
value	varchar( 128 )
Indexes
pk_event_attr__id primary key	( id)
fkx_event__event_attr	( event__id)
fkx_event_type_attr__event_attr	( event_type_attr__id)
Foreign Keys
fk_event__event_attr	( event__id ) ref event ( id )
fk_event_type_attr__event_attr	( event_type_attr__id ) ref event_type_attr ( id )

Table event_type
id	serial NOT NULL
key_name	varchar( 64 ) NOT NULL
name	varchar( 64 ) NOT NULL
description	varchar( 256 ) NOT NULL
class__id	int4 NOT NULL
active	bool NOT NULL DEFO true
Indexes
pk_event_type__id primary key	( id)
udx_event_type__class_id__name unique	( class__id, name)
fkx_class__event_type	( class__id)
Foreign Keys
fk_class__event_type	( class__id ) ref class ( id )

Table event_type_attr
id	serial NOT NULL
event_type__id	int4 NOT NULL
name	varchar( 64 ) NOT NULL
Indexes
pk_event_type_attr__id primary key	( id)
fkx_event_type__event_type_attr	( event_type__id)
Foreign Keys
fk_event_type__event_type_attr	( event_type__id ) ref event_type ( id )

Table field_type
id	serial NOT NULL
element_type__id	int4 NOT NULL
name	text NOT NULL
key_name	text NOT NULL
description	text
place	int4 NOT NULL
min_occurrence	int4 NOT NULL DEFO 0
max_occurrence	int4 NOT NULL DEFO 0
autopopulated	bool NOT NULL DEFO false
max_length	int4 NOT NULL DEFO 0
sql_type	varchar( 30 ) NOT NULL DEFO ‘short’::character varying
widget_type	varchar( 30 ) NOT NULL DEFO ‘’text’::character varying’
precision	int2
cols	int4 NOT NULL
rows	int4 NOT NULL
length	int4 NOT NULL
vals	text
multiple	bool NOT NULL DEFO ‘false’
default_val	text
active	bool NOT NULL DEFO ‘true’
Indexes
pk_field_type__id primary key	( id)
fkx_element_type__field_type	( element_type__id)
Foreign Keys
fk_element_type__field_type	( element_type__id ) ref element_type ( id )

Table grp
id	serial NOT NULL
parent_id	int4
class__id	int4 NOT NULL
name	varchar( 64 )
description	varchar( 256 )
secret	bool NOT NULL DEFO ‘true’
permanent	bool NOT NULL DEFO false
active	bool NOT NULL DEFO true
Indexes
pk_grp__id primary key	( id)
fkx_class__grp	( class__id)
fkx_grp__grp	( parent_id)
Foreign Keys
fk_class__grp	( class__id ) ref class ( id )
fk_grp__grp	( parent_id ) ref grp ( id )

Table grp_member
id	serial NOT NULL
object_id	int4 NOT NULL
member__id	int4 NOT NULL
Indexes
pk_grp_member__id primary key	( id)
fkx_grp__grp_member	( object_id)
fkx_member__grp_member	( member__id)
Foreign Keys
fk_grp__grp_member	( object_id ) ref grp ( id )
fk_member__grp_member	( member__id ) ref member ( id )

Table grp_priv
id	serial NOT NULL
grp__id	int4 NOT NULL
value	int2 NOT NULL
mtime	timestamp NOT NULL DEFO now()
Indexes
pk_grp_priv__id primary key	( id)
fkx_grp__grp_priv	( grp__id)
Foreign Keys
fk_grp__grp_priv	( grp__id ) ref grp ( id )

Table grp_priv__grp_member
grp_priv__id	int4 NOT NULL
grp__id	int4 NOT NULL
Indexes
pk_grp_priv__grp_member primary key	( grp_priv__id, grp__id)
fkx_grp__grp_priv__grp_member	( grp__id)
fkx_grp_priv__grp_priv__grp_member	( grp_priv__id)
Foreign Keys
fk_grp__grp_priv__grp_member	( grp__id ) ref grp ( id )
fk_grp_priv__grp_priv__grp_mem	( grp_priv__id ) ref grp_priv ( id )

Table job
id	serial NOT NULL
name	text NOT NULL
usr__id	int4 NOT NULL
sched_time	timestamp NOT NULL DEFO now()
priority	int2 NOT NULL DEFO 3
comp_time	timestamp
expire	bool NOT NULL DEFO false
failed	bool NOT NULL DEFO false
tries	int2 NOT NULL DEFO 0
executing	bool NOT NULL DEFO false
class__id	int4 NOT NULL
story_instance__id	int4
media_instance__id	int4
error_message	text
Indexes
pk_job__id primary key	( id)
fkx_media_instance__job	( media_instance__id)
fkx_story_instance__job	( story_instance__id)
fkx_usr__job	( usr__id)
idx_job__executing	( executing)
idx_job__sched_time	( sched_time)
Foreign Keys
fk_job__class	( class__id ) ref class ( id )
fk_job__media_instance	( media_instance__id ) ref media_instance ( id )
fk_job__story_instance	( story_instance__id ) ref story_instance ( id )
fk_job__usr	( usr__id ) ref usr ( id )

Table job__resource
job__id	int4 NOT NULL
resource__id	int4 NOT NULL
Indexes
pk_job__resource primary key	( job__id, resource__id)
fkx_job__job__resource	( job__id)
fkx_resource__job__resource	( resource__id)
Foreign Keys
fk_job__job__resource	( job__id ) ref job ( id )
fk_resource__job__resource	( resource__id ) ref resource ( id )

Table job__server_type
job__id	int4 NOT NULL
server_type__id	int4 NOT NULL
Indexes
pk_job__server_type primary key	( job__id, server_type__id)
fkx_job__job__server_type	( job__id)
fkx_srvr_type__job__srvr_type	( server_type__id)
Foreign Keys
fk_job__job__server_type	( job__id ) ref job ( id )
fk_srvr_type__job__srvr_type	( server_type__id ) ref server_type ( id )

Table job_member
id	serial NOT NULL
object_id	int4 NOT NULL
member__id	int4 NOT NULL
Indexes
pk_job_member__id primary key	( id)
fkx_job__job_member	( object_id)
fkx_member__job_member	( member__id)
Foreign Keys
fk_job__job_member	( object_id ) ref job ( id )
fk_member__job_member	( member__id ) ref member ( id )

Table keyword
id	serial NOT NULL
name	varchar( 256 ) NOT NULL
screen_name	varchar( 256 ) NOT NULL
sort_name	varchar( 256 ) NOT NULL
active	bool NOT NULL DEFO ‘true’
Indexes
pk_keyword__id primary key	( id)

Table keyword_member
id	serial NOT NULL
object_id	int4 NOT NULL
member__id	int4 NOT NULL
Indexes
pk_keyword_member__id primary key	( id)
fkx_keyword__keyword_member	( object_id)
fkx_member__keyword_member	( member__id)
Foreign Keys
fk_keyword__keyword_member	( object_id ) ref keyword ( id )
fk_member__keyword_member	( member__id ) ref member ( id )

Table media
id	serial NOT NULL
uuid	text NOT NULL
element_type__id	int4 NOT NULL
priority	int2 NOT NULL DEFO 3
source__id	int4 NOT NULL
current_version	int4
published_version	int4
usr__id	int4
first_publish_date	timestamp
publish_date	timestamp
expire_date	timestamp
workflow__id	int4 NOT NULL
desk__id	int4 NOT NULL
publish_status	bool NOT NULL DEFO false
active	bool NOT NULL DEFO true
site__id	int4 NOT NULL
alias_id	int4
Indexes
pk_media__id primary key	( id)
fkx_alias_id__media	( alias_id)
fkx_element_type__media	( element_type__id)
fkx_media__desk__id	( desk__id)
fkx_media__workflow__id	( workflow__id)
fkx_site_id__media	( site__id)
fkx_source__media	( source__id)
fkx_usr__media	( usr__id)
idx_media__first_publish_date	( first_publish_date)
idx_media__publish_date	( publish_date)
idx_media__uuid	( uuid)
Foreign Keys
fk_desk__media	( desk__id ) ref desk ( id )
fk_element_type__media	( element_type__id ) ref element_type ( id )
fk_media__media_id	( alias_id ) ref media ( id )
fk_site__media	( site__id ) ref site ( id )
fk_source__media	( source__id ) ref source ( id )
fk_usr__media	( usr__id ) ref usr ( id )
fk_workflow__media	( workflow__id ) ref workflow ( id )

Table media__contributor
id	serial NOT NULL
media_instance__id	int4 NOT NULL
member__id	int4 NOT NULL
place	int2 NOT NULL
role	varchar( 256 )
Indexes
pk_media_category_id primary key	( id)
fkx_media__media__contributor	( media_instance__id)
fkx_member__media__contributor	( member__id)
Foreign Keys
fk_media__media__contributor	( media_instance__id ) ref media_instance ( id )
fk_member__media__contributor	( member__id ) ref member ( id )

Table media__output_channel
media_instance__id	int4 NOT NULL
output_channel__id	int4 NOT NULL
Indexes
pk_media_output_channel primary key	( media_instance__id, output_channel__id)
fkx_media__oc__media	( media_instance__id)
fkx_media__oc__oc	( output_channel__id)
Foreign Keys
fk_media__oc__media	( media_instance__id ) ref media_instance ( id )
fk_media__oc__oc	( output_channel__id ) ref output_channel ( id )

Table media__resource
media__id	int4 NOT NULL
resource__id	int4 NOT NULL
Indexes
pk_media__resource primary key	( media__id, resource__id)
fkx_media__media__resource	( media__id)
fkx_resource__media__resource	( resource__id)
Foreign Keys
fk_media__media__resource	( media__id ) ref media ( id )
fk_resource__media__resource	( resource__id ) ref resource ( id )

Table media_element
id	serial NOT NULL
element_type__id	int4 NOT NULL
object_instance_id	int4 NOT NULL
parent_id	int4
place	int4 NOT NULL
object_order	int4 NOT NULL
displayed	bool NOT NULL DEFO false
related_story__id	int4
related_media__id	int4
active	bool NOT NULL DEFO true
Indexes
pk_media_element__id primary key	( id)
fkx_media__media_element	( object_instance_id)
fkx_media_element__element_type	( element_type__id)
fkx_media_element__media_element	( parent_id)
fkx_media_element__related_media	( related_media__id)
fkx_media_element__related_story	( related_story__id)
Foreign Keys
fk_media_element__element_type	( element_type__id ) ref element_type ( id )
fk_media_element__related_media	( related_media__id ) ref media ( id )
fk_media_element__media_element	( parent_id ) ref media_element ( id )
fk_media__media_element	( object_instance_id ) ref media_instance ( id )
fk_media_element__related_story	( related_story__id ) ref story ( id )

Table media_field
id	serial NOT NULL
field_type__id	int4 NOT NULL
object_instance_id	int4 NOT NULL
parent_id	int4 NOT NULL
place	int4 NOT NULL
hold_val	bool NOT NULL DEFO false
object_order	int4 NOT NULL
date_val	timestamp
short_val	varchar( 1024 )
blob_val	text
active	bool NOT NULL DEFO ‘true’
Indexes
pk_media_field__id primary key	( id)
fkx_field_type__media_field	( field_type__id)
fkx_media_field__media_field	( parent_id)
fkx_media_instance__media_field	( object_instance_id)
Foreign Keys
fk_field_type__media_field	( field_type__id ) ref field_type ( id )
fk_media_element__media_field	( parent_id ) ref media_element ( id )
fk_media_instance__media_field	( object_instance_id ) ref media_instance ( id )

Table media_fields
id	serial NOT NULL
biz_pkg	int4 NOT NULL
name	varchar( 32 ) NOT NULL
function_name	varchar( 256 ) NOT NULL
active	bool NOT NULL DEFO ‘true’
Indexes
pk_media_fields__id primary key	( id)

Table media_instance
id	serial NOT NULL
name	varchar( 256 )
description	varchar( 1024 )
media__id	int4 NOT NULL
usr__id	int4 NOT NULL
version	int4
category__id	int4 NOT NULL
media_type__id	int4 NOT NULL
primary_oc__id	int4 NOT NULL
file_size	int4
file_name	varchar( 256 )
location	varchar( 256 )
uri	varchar( 256 )
cover_date	timestamp NOT NULL DEFO ‘now()’
note	text
checked_out	bool NOT NULL DEFO ‘false’
Indexes
pk_media_instance__id primary key	( id)
udx_media__media_instance unique	( media__id, version, checked_out)
fkx_category__media_instance	( category__id)
fkx_media_type__media_instance	( media_type__id)
fkx_primary_oc__media_instance	( primary_oc__id)
fkx_usr__media_instance	( usr__id)
idx_media_instance__cover_date	( cover_date)
idx_media_instance__note	( note)
Foreign Keys
fk_category__media_instance	( category__id ) ref category ( id )
fk_media__media_instance	( media__id ) ref media ( id )
fk_media_type__media_instance	( media_type__id ) ref media_type ( id )
fk_primary_oc__media_instance	( primary_oc__id ) ref output_channel ( id )
fk_usr__media_instance	( usr__id ) ref usr ( id )

Table media_keyword
media_id	int4 NOT NULL
keyword_id	int4 NOT NULL
Indexes
pk_media_keyword primary key	( media_id, keyword_id)
fkx_keyword__media_keyword	( keyword_id)
fkx_media__media_keyword	( media_id)
Foreign Keys
fk_keyword__media_keyword	( keyword_id ) ref keyword ( id )
fk_media__media_keyword	( media_id ) ref media ( id )

Table media_member
id	serial NOT NULL
object_id	int4 NOT NULL
member__id	int4 NOT NULL
Indexes
pk_media_member__id primary key	( id)
fkx_media__media_member	( object_id)
fkx_member__media_member	( member__id)
Foreign Keys
fk_media__media_member	( object_id ) ref media ( id )
fk_member__media_member	( member__id ) ref member ( id )

Table media_type
id	serial NOT NULL
name	varchar( 128 ) NOT NULL
description	varchar( 256 )
active	bool NOT NULL DEFO ‘true’
Indexes
pk_media_type__id primary key	( id)

Table media_type_ext
id	serial NOT NULL
media_type__id	int4 NOT NULL
extension	varchar( 10 ) NOT NULL
Indexes
pk_media_type_ext__id primary key	( id)
fkx_media_type__media_type_ext	( media_type__id)
Foreign Keys
fk_media_type__media_type_ext	( media_type__id ) ref media_type ( id )

Table media_type_member
id	serial NOT NULL
object_id	int4 NOT NULL
member__id	int4 NOT NULL
Indexes
pk_media_type_member__id primary key	( id)
fkx_media_type__media_type_member	( object_id)
fkx_member__media_type_member	( member__id)
Foreign Keys
fk_media_type__media_type_member	( object_id ) ref media_type ( id )
fk_member__media_type_member	( member__id ) ref member ( id )

Table media_uri
id	serial NOT NULL
media__id	int4 NOT NULL
site__id	int4 NOT NULL
uri	text NOT NULL
Indexes
pk_media_uri__id primary key	( id)
fkx_media__media_uri	( media__id)
Foreign Keys
fk_media__media_uri	( media__id ) ref media ( id )
fk_media__site__id	( site__id ) ref site ( id )

Table member
id	serial NOT NULL
grp__id	int4 NOT NULL
class__id	int4 NOT NULL
active	bool NOT NULL DEFO true
Indexes
pk_member__id primary key	( id)
fkx_grp__class	( class__id)
fkx_grp__member	( grp__id)
Foreign Keys
fk_class__member	( class__id ) ref class ( id )
fk_grp__member	( grp__id ) ref grp ( id )

Table org
id	serial NOT NULL
name	varchar( 64 ) NOT NULL
long_name	varchar( 128 )
personal	bool NOT NULL DEFO ‘false’
active	bool NOT NULL DEFO true
Indexes
pk_org__id primary key	( id)

Table org_member
id	serial NOT NULL
object_id	int4 NOT NULL
member__id	int4 NOT NULL
Indexes
pk_org_member__id primary key	( id)
fkx_member__org_member	( member__id)
fkx_org__org_member	( object_id)
Foreign Keys
fk_member__org_member	( member__id ) ref member ( id )
fk_org__org_member	( object_id ) ref org ( id )

Table output_channel
id	serial NOT NULL
name	varchar( 64 ) NOT NULL
description	varchar( 256 )
site__id	int4 NOT NULL
protocol	varchar( 16 )
filename	varchar( 32 ) NOT NULL
file_ext	varchar( 32 )
primary_ce	bool
uri_format	varchar( 64 ) NOT NULL
fixed_uri_format	varchar( 64 ) NOT NULL
uri_case	int2 NOT NULL DEFO ‘1’
use_slug	bool NOT NULL DEFO false
burner	int2 NOT NULL DEFO 1
active	bool NOT NULL DEFO true
Indexes
pk_output_channel__id primary key	( id)
fkx_site__output_channel	( site__id)
Foreign Keys
fk_site__output_channel	( site__id ) ref site ( id )

Table output_channel_include
id	serial NOT NULL
output_channel__id	int4 NOT NULL
include_oc_id	int4 NOT NULL
Indexes
pk_output_channel_include__id primary key	( id)
udx_output_channel_include unique	( output_channel__id, include_oc_id)
fkx_oc__oc_include_inc	( include_oc_id)
fkx_output_channel__oc_include	( output_channel__id)
Foreign Keys
fk_output_channel__oc_include	( output_channel__id ) ref output_channel ( id )
fk_oc__oc_include_inc	( include_oc_id ) ref output_channel ( id )

Table output_channel_member
id	serial NOT NULL
object_id	int4 NOT NULL
member__id	int4 NOT NULL
Indexes
pk_output_channel_member__id primary key	( id)
fkx_member__oc_member	( member__id)
fkx_output_channel__oc_member	( object_id)
Foreign Keys
fk_member__oc_member	( member__id ) ref member ( id )
fk_output_channel__oc_member	( object_id ) ref output_channel ( id )

Table person
id	serial NOT NULL
prefix	varchar( 32 )
lname	varchar( 64 )
fname	varchar( 64 )
mname	varchar( 64 )
suffix	varchar( 32 )
active	bool NOT NULL DEFO ‘true’
Indexes
pk_person__id primary key	( id)

Table person__contact_value
person__id	int4 NOT NULL
contact_value__id	int4 NOT NULL
Indexes
pk_person__contact_value primary key	( person__id, contact_value__id)
fkx_contact_value__p_c_val	( contact_value__id)
fkx_person__p_c_val	( person__id)
Foreign Keys
fk_contact_value__p_c_val	( contact_value__id ) ref contact_value ( id )
fk_person__p_c_val	( person__id ) ref person ( id )

Table person_member
id	serial NOT NULL
object_id	int4 NOT NULL
member__id	int4 NOT NULL
Indexes
pk_person_member__id primary key	( id)
fkx_member__person_member	( member__id)
fkx_person__person_member	( object_id)
Foreign Keys
fk_member__person_member	( member__id ) ref member ( id )
fk_person__person_member	( object_id ) ref person ( id )

Table person_org
id	serial NOT NULL
person__id	int4 NOT NULL
org__id	int4 NOT NULL
role	varchar( 64 )
department	varchar( 64 )
title	varchar( 64 )
active	bool NOT NULL DEFO ‘true’
Indexes
pk_person_org__id primary key	( id)
udx_person_org__person__org unique	( person__id, org__id, role)
fkx_org__person_org	( org__id)
fkx_person__person_org	( person__id)
Foreign Keys
fk_org__person_org	( org__id ) ref org ( id )
fk_person__person_org	( person__id ) ref person ( id )

Table person_org__addr
addr__id	int4 NOT NULL
person_org__id	int4 NOT NULL
Indexes
pk_person_org__addr__all primary key	( addr__id, person_org__id)
fk_person_org__pers_org_addr	( person_org__id)
fkx_addr__person_org_addr	( addr__id)
Foreign Keys
fk_addr__person_org_addr	( addr__id ) ref addr ( id )
fk_person_org__pers_org_addr	( person_org__id ) ref person_org ( id )

Table pref
id	serial NOT NULL
name	varchar( 64 ) NOT NULL
description	varchar( 256 )
value	varchar( 256 )
def	varchar( 256 )
manual	bool NOT NULL DEFO ‘false’
opt_type	varchar( 16 ) NOT NULL
can_be_overridden	bool NOT NULL DEFO ‘false’
Indexes
pk_pref__id primary key	( id)

Table pref_member
id	serial NOT NULL
object_id	int4 NOT NULL
member__id	int4 NOT NULL
Indexes
pk_pref_member__id primary key	( id)
fkx_member__pref_member	( member__id)
fkx_pref__pref_member	( object_id)
Foreign Keys
fk_member__pref_member	( member__id ) ref member ( id )
fk_pref__pref_member	( object_id ) ref pref ( id )

Table pref_opt
pref__id	int4 NOT NULL
value	varchar( 256 ) NOT NULL
description	varchar( 256 )
Indexes
pk_pref_opt__pref__id__value primary key	( pref__id, value)
fkx_pref__pref__opt	( pref__id)
Foreign Keys
fk_pref__pref_opt	( pref__id ) ref pref ( id )

Table resource
id	serial NOT NULL
parent_id	int4
media_type__id	int4 NOT NULL
path	varchar( 256 ) NOT NULL
uri	varchar( 256 ) NOT NULL
size	int4 NOT NULL
mod_time	timestamp NOT NULL
is_dir	bool NOT NULL
Indexes
pk_resource__id primary key	( id)
udx_resource__path__uri unique	( path, uri)
fkx_media_type__resource	( media_type__id)
fkx_resource__resource	( parent_id)
idx_resource__mod_time	( mod_time)
idx_resource__path	( path)
idx_resource__uri	( uri)
Foreign Keys
fk_media_type__resource	( media_type__id ) ref media_type ( id )
fk_resource__resource	( parent_id ) ref resource ( id )

Table server
id	serial NOT NULL
server_type__id	int4 NOT NULL
host_name	varchar( 128 ) NOT NULL
os	bpchar NOT NULL
doc_root	varchar( 128 ) NOT NULL
login	varchar( 64 )
password	varchar( 64 )
cookie	varchar( 512 )
active	bool NOT NULL DEFO ‘true’
Indexes
pk_server__id primary key	( id)
udx_server__name__st_id unique	( host_name, server_type__id)
fkx_server_type__server	( server_type__id)
idx_server__os	( os)
Foreign Keys
fk_server_type__server	( server_type__id ) ref server_type ( id )

Table server_type
id	serial NOT NULL
class__id	int4 NOT NULL
name	varchar( 64 ) NOT NULL
description	varchar( 256 )
site__id	int4 NOT NULL
copyable	bool NOT NULL DEFO false
publish	bool NOT NULL DEFO true
preview	bool NOT NULL DEFO false
active	bool NOT NULL DEFO true
Indexes
pk_server_type__id primary key	( id)
fkx_class__server_type	( class__id)
fkx_site__server_type	( site__id)
Foreign Keys
fk_class__server_type	( class__id ) ref class ( id )
fk_site__server_type	( site__id ) ref site ( id )

Table server_type__output_channel
server_type__id	int4 NOT NULL
output_channel__id	int4 NOT NULL
Indexes
pk_server_type__output_channel primary key	( server_type__id, output_channel__id)
fk_output_channel__st_oc	( output_channel__id)
fkx_server_type__st_oc	( server_type__id)
Foreign Keys
fk_output_channel__st_oc	( output_channel__id ) ref output_channel ( id )
fk_server_type__st_oc	( server_type__id ) ref server_type ( id )

Table site
id	int4 NOT NULL
name	text
description	text
domain_name	text
active	bool NOT NULL DEFO ‘true’
Indexes
pk_site__id primary key	( id)
Foreign Keys
fk_grp__site	( id ) ref grp ( id )

Table site_member
id	serial NOT NULL
object_id	int4 NOT NULL
member__id	int4 NOT NULL
Indexes
pk_site_member__id primary key	( id)
fkx_member__site_member	( member__id)
fkx_site__site_member	( object_id)
Foreign Keys
fk_member__site_member	( member__id ) ref member ( id )
fk_site__site_member	( object_id ) ref site ( id )

Table source
id	serial NOT NULL
org__id	int4 NOT NULL
name	varchar( 64 ) NOT NULL
description	varchar( 256 )
expire	int2 NOT NULL DEFO ‘0’
active	bool DEFO true
Indexes
pk_source__id primary key	( id)
udx_source_name unique	( name)
fkx_source__org	( org__id)
Foreign Keys
fk_org__source	( org__id ) ref org ( id )

Table source_member
id	serial NOT NULL
object_id	int4 NOT NULL
member__id	int4 NOT NULL
Indexes
pk_source_member__id primary key	( id)
fkx_member__source_member	( member__id)
fkx_source__source_member	( object_id)
Foreign Keys
fk_member__source_member	( member__id ) ref member ( id )
fk_source__source_member	( object_id ) ref source ( id )

Table story
id	serial NOT NULL
uuid	text NOT NULL
priority	int2 NOT NULL DEFO ‘3’
source__id	int4 NOT NULL
usr__id	int4
element_type__id	int4 NOT NULL
primary_uri	varchar( 128 )
first_publish_date	timestamp
publish_date	timestamp
expire_date	timestamp
current_version	int4 NOT NULL
published_version	int4
workflow__id	int4 NOT NULL
desk__id	int4 NOT NULL
publish_status	bool NOT NULL DEFO false
active	bool NOT NULL DEFO true
site__id	int4 NOT NULL
alias_id	int4
Indexes
pk_story__id primary key	( id)
fkx_alias_id__story	( alias_id)
fkx_element_type__story	( element_type__id)
fkx_site_id__story	( site__id)
fkx_source__story	( source__id)
fkx_story__desk__id	( desk__id)
fkx_story__workflow__id	( workflow__id)
fkx_usr__story	( usr__id)
idx_story__first_publish_date	( first_publish_date)
idx_story__publish_date	( publish_date)
idx_story__uuid	( uuid)
Foreign Keys
fk_desk__story	( desk__id ) ref desk ( id )
fk_element_type__story	( element_type__id ) ref element_type ( id )
fk_site__story	( site__id ) ref site ( id )
fk_source__story	( source__id ) ref source ( id )
fk_story__story_id	( alias_id ) ref story ( id )
fk_usr__story	( usr__id ) ref usr ( id )
fk_workflow__story	( workflow__id ) ref workflow ( id )

Table story__category
id	serial NOT NULL
story_instance__id	int4 NOT NULL
category__id	int4 NOT NULL
main	bool NOT NULL DEFO false
Indexes
pk_story_category__id primary key	( id)
udx_story_category__story__cat unique	( story_instance__id, category__id)
fkx_category__story__category	( category__id)
fkx_story__story__category	( story_instance__id)
Foreign Keys
fk_category__story__category	( category__id ) ref category ( id )
fk_story__story__category	( story_instance__id ) ref story_instance ( id )

Table story__contributor
id	serial NOT NULL
story_instance__id	int4 NOT NULL
member__id	int4 NOT NULL
place	int2 NOT NULL
role	varchar( 256 )
Indexes
pk_story_category_id primary key	( id)
fkx_member__story__contributor	( member__id)
fkx_story__story__contributor	( story_instance__id)
Foreign Keys
fk_member__story__contributor	( member__id ) ref member ( id )
fk_story__story__contributor	( story_instance__id ) ref story_instance ( id )

Table story__output_channel
story_instance__id	int4 NOT NULL
output_channel__id	int4 NOT NULL
Indexes
pk_story_output_channel primary key	( story_instance__id, output_channel__id)
fkx_story__oc__oc	( output_channel__id)
fkx_story__oc__story	( story_instance__id)
Foreign Keys
fk_story__oc__oc	( output_channel__id ) ref output_channel ( id )
fk_story__oc__story	( story_instance__id ) ref story_instance ( id )

Table story__resource
story__id	int4 NOT NULL
resource__id	int4 NOT NULL
Indexes
pk_story__resource primary key	( story__id, resource__id)
fkx_resource__story__resource	( resource__id)
fkx_story__story__resource	( story__id)
Foreign Keys
fk_resource__story__resource	( resource__id ) ref resource ( id )
fk_story__story__resource	( story__id ) ref story ( id )

Table story_element
id	serial NOT NULL
element_type__id	int4 NOT NULL
object_instance_id	int4 NOT NULL
parent_id	int4
place	int4 NOT NULL
object_order	int4 NOT NULL
displayed	bool NOT NULL DEFO false
related_story__id	int4
related_media__id	int4
active	bool NOT NULL DEFO true
Indexes
pk_story_element__id primary key	( id)
fkx_story__story_element	( object_instance_id)
fkx_story_element__element_type	( element_type__id)
fkx_story_element__related_media	( related_media__id)
fkx_story_element__related_story	( related_story__id)
fkx_story_element__story_element	( parent_id)
Foreign Keys
fk_story_element__element_type	( element_type__id ) ref element_type ( id )
fk_story_element__related_media	( related_media__id ) ref media ( id )
fk_story_element__related_story	( related_story__id ) ref story ( id )
fk_story_element__story_element	( parent_id ) ref story_element ( id )
fk_story__story_element	( object_instance_id ) ref story_instance ( id )

Table story_field
id	serial NOT NULL
field_type__id	int4 NOT NULL
object_instance_id	int4 NOT NULL
parent_id	int4 NOT NULL
hold_val	bool NOT NULL DEFO false
place	int4 NOT NULL
object_order	int4 NOT NULL
date_val	timestamp
short_val	text
blob_val	text
active	bool NOT NULL DEFO ‘true’
Indexes
pk_story_field__id primary key	( id)
fkx_field_type__story_field	( field_type__id)
fkx_story_field__story_field	( parent_id)
fkx_story_instance__story_field	( object_instance_id)
Foreign Keys
fk_field_type__story_field	( field_type__id ) ref field_type ( id )
fk_story_element__story_field	( parent_id ) ref story_element ( id )
fk_story_instance__story_field	( object_instance_id ) ref story_instance ( id )

Table story_instance
id	serial NOT NULL
name	varchar( 256 )
description	varchar( 1024 )
story__id	int4 NOT NULL
version	int4
usr__id	int4 NOT NULL
slug	varchar( 64 )
primary_oc__id	int4 NOT NULL
cover_date	timestamp NOT NULL DEFO now()
note	text
checked_out	bool NOT NULL DEFO ‘false’
Indexes
pk_story_instance__id primary key	( id)
udx_story__story_instance unique	( story__id, version, checked_out)
fkx_primary_oc__story_instance	( primary_oc__id)
fkx_usr__story_instance	( usr__id)
idx_story_instance__cover_date	( cover_date)
idx_story_instance__note	( note)
Foreign Keys
fk_primary_oc__story_instance	( primary_oc__id ) ref output_channel ( id )
fk_story__story_instance	( story__id ) ref story ( id )
fk_usr__story_instance	( usr__id ) ref usr ( id )

Table story_keyword
story_id	int4 NOT NULL
keyword_id	int4 NOT NULL
Indexes
pk_story_keyword primary key	( story_id, keyword_id)
fkx_keyword__story_keyword	( keyword_id)
fkx_story__story_keyword	( story_id)
Foreign Keys
fk_keyword__story_keyword	( keyword_id ) ref keyword ( id )
fk_story__story_keyword	( story_id ) ref story ( id )

Table story_member
id	serial NOT NULL
object_id	int4 NOT NULL
member__id	int4 NOT NULL
Indexes
pk_story_member__id primary key	( id)
fkx_member__story_member	( member__id)
fkx_story__story_member	( object_id)
Foreign Keys
fk_member__story_member	( member__id ) ref member ( id )
fk_story__story_member	( object_id ) ref story ( id )

Table story_uri
id	serial NOT NULL
story__id	int4 NOT NULL
site__id	int4 NOT NULL
uri	text NOT NULL
Indexes
pk_story_uri__id primary key	( id)
fkx_story__story_uri	( story__id)
Foreign Keys
fk_story__site__id	( site__id ) ref site ( id )
fk_story__story_uri	( story__id ) ref story ( id )

Table subelement_type
id	serial NOT NULL
parent_id	int4 NOT NULL
child_id	int4 NOT NULL
place	int4 NOT NULL DEFO 1
min_occurrence	int4 NOT NULL DEFO 0
max_occurrence	int4 NOT NULL DEFO 0
Indexes
pk_subelement_type__id primary key	( id)
udx_subelement_type__parent__child unique	( parent_id, child_id)
fkx_element_type__subelement__child_id	( child_id)
fkx_element_type__subelement__parent_id	( parent_id)
Foreign Keys
fkx_element_type__subelement__parent_id	( parent_id ) ref element_type ( id )
fkx_element_type__subelement__child_id	( child_id ) ref element_type ( id )

Table template
id	serial NOT NULL
name	varchar( 256 )
description	varchar( 1024 )
priority	int2 NOT NULL DEFO ‘3’
usr__id	int4
output_channel__id	int4 NOT NULL
tplate_type	int2 NOT NULL DEFO 1
element_type__id	int4
category__id	int4
file_name	text
current_version	int4 NOT NULL
workflow__id	int4 NOT NULL
desk__id	int4 NOT NULL
published_version	int4
deploy_status	bool NOT NULL DEFO false
deploy_date	timestamp
expire_date	timestamp
active	bool NOT NULL DEFO true
site__id	int4 NOT NULL
Indexes
pk_template__id primary key	( id)
udx_template__file_name__oc unique	( file_name, output_channel__id)
fkx_category__template	( category__id)
fkx_element_type__template	( element_type__id)
fkx_output_channel__template	( output_channel__id)
fkx_site__template	( site__id)
fkx_template__desk__id	( desk__id)
fkx_template__workflow__id	( workflow__id)
fkx_usr__template	( usr__id)
Foreign Keys
fk_category__template	( category__id ) ref category ( id )
fk_desk__template	( desk__id ) ref desk ( id )
fk_element_type__template	( element_type__id ) ref element_type ( id )
fk_output_channel__template	( output_channel__id ) ref output_channel ( id )
fk_site__template	( site__id ) ref site ( id )
fk_usr__template	( usr__id ) ref usr ( id )
fk_workflow__template	( workflow__id ) ref workflow ( id )

Table template_instance
id	serial NOT NULL
template__id	int4 NOT NULL
version	int4
usr__id	int4 NOT NULL
file_name	text
data	text
note	text
checked_out	bool NOT NULL DEFO ‘false’
Indexes
pk_template_instance__id primary key	( id)
fkx_template__tmpl_instance	( template__id)
fkx_usr__template_instance	( usr__id)
idx_template_instance__note	( note)
Foreign Keys
fk_template__template_instance	( template__id ) ref template ( id )
fk_usr__template_instance	( usr__id ) ref usr ( id )

Table template_member
id	serial NOT NULL
object_id	int4 NOT NULL
member__id	int4 NOT NULL
Indexes
pk_template_member__id primary key	( id)
fkx_member__template_member	( member__id)
fkx_template__template_member	( object_id)
Foreign Keys
fk_member__template_member	( member__id ) ref member ( id )
fk_template__template_member	( object_id ) ref template ( id )

Table user_member
id	serial NOT NULL
object_id	int4 NOT NULL
member__id	int4 NOT NULL
Indexes
pk_user_member__id primary key	( id)
fkx_member__user_member	( member__id)
fkx_user__user_member	( object_id)
Foreign Keys
fk_member__user_member	( member__id ) ref member ( id )
fk_user__user_member	( object_id ) ref usr ( id )

Table usr
id	int4 NOT NULL
login	varchar( 128 ) NOT NULL
password	bpchar NOT NULL
active	bool NOT NULL DEFO ‘true’
Indexes
pk_usr__id primary key	( id)
Foreign Keys
fk_person__usr	( id ) ref person ( id )

Table usr_pref
id	serial NOT NULL
pref__id	int4 NOT NULL
usr__id	int4 NOT NULL
value	varchar( 256 ) NOT NULL
Indexes
pk_usr_pref__pref__id__value primary key	( id)
udx_usr_pref__pref__id__usr__id unique	( pref__id, usr__id)
idx_usr_pref__usr__id	( usr__id)
Foreign Keys
fk_pref__usr_pref	( pref__id ) ref pref ( id )
fk_usr__usr_pref	( usr__id ) ref usr ( id )

Table workflow
id	serial NOT NULL
name	varchar( 64 ) NOT NULL
description	varchar( 256 ) NOT NULL
all_desk_grp_id	int4 NOT NULL
req_desk_grp_id	int4 NOT NULL
asset_grp_id	int4 NOT NULL
head_desk_id	int4 NOT NULL
type	int2 NOT NULL DEFO 1
active	bool NOT NULL DEFO true
site__id	int4 NOT NULL
Indexes
pk_workflow__id primary key	( id)
fkx_grp__workflow__all_desk_grp_id	( all_desk_grp_id)
fkx_grp__workflow__asset_grp_id	( asset_grp_id)
fkx_grp__workflow__req_desk_grp_id	( req_desk_grp_id)
fkx_site__workflow__site__id	( site__id)
Foreign Keys
fk_grp__workflow__all_desk_grp_id	( all_desk_grp_id ) ref grp ( id )
fk_grp__workflow__req_desk_grp_id	( req_desk_grp_id ) ref grp ( id )
fk_grp__workflow__asset_grp_id	( asset_grp_id ) ref grp ( id )
fk_site__workflow__site__id	( site__id ) ref site ( id )

Table workflow_member
id	serial NOT NULL
object_id	int4 NOT NULL
member__id	int4 NOT NULL
Indexes
pk_workflow_member__id primary key	( id)
fkx_member__workflow_member	( member__id)
fkx_workflow__workflow_member	( object_id)
Foreign Keys
fk_member__workflow_member	( member__id ) ref member ( id )
fk_workflow__workflow_member	( object_id ) ref workflow ( id )