MIXERP-Table core.flags

#	Column Name	Nullable	Data Type	Max Length	Description
1	flag_id		bigint	0	The primary key of this table, which is also a serial field.
2	user_id		integer	0	Foreign key to the table office.users.
3	flag_type_id		integer	0	Foreign key to the table core.flag_types.
4	resource		text	0
5	resource_key		text	0
6	resource_id		text	0
7	flagged_on		timestamp with time zone	0

Foreign Keys

#	Column Name	Key Name	References
2	user_id	flags_user_id_fkey	office.users.user_id
3	flag_type_id	flags_flag_type_id_fkey	core.flag_types.flag_type_id

Indices

Index Name	Owner	Access Method	Definition	Description
flags_pkey	postgres	btree	flag_id
flags_user_id_resource_resource_id_uix	postgres	btree	user_id upper(resource) upper(resource_key) upper(resource_id)

Check Constraints

Constraint Name	Description

Default Values

#	Column Name	Default
1	flag_id	nextval('core.flags_flag_id_seq'::regclass)
7	flagged_on	now()

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description