Status codes

Status ID Color
Draft 0 green
Feedback required 1 orange
In revision 2 green
Awaiting approval 3 orange
Final 4 black
Obsolete 5 black


Column Type Size Nulls Auto Default Children Parents Comments
ID int4 10 null

Note ID

owneruser int4 10 null
users.ID fk_notes_owneruser C

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)

ownergroup int4 10 null
groups.ID fk_notes_ownergroup C

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)

creator int4 10 null
users.ID fk_notes_creator N

Creator user ID (defaults to authenticated user on creation)

assigneduser int4 10 null
users.ID fk_notes_assigneduser N

Assigned user ID

creationdate int8 19 date_part('epoch'::text, now())

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)

binfile int4 10 null
visibility int2 5 0


name text 2147483647 null


status int2 5 0
contenttype text 2147483647 ''::text

Content MIME type (RFC 2045)

size int4 10 0

Size in bytes

text text 2147483647 ''::text

Plain text version of content

description text 2147483647 ''::text

Detailed general description

Table contained 0 rows


Constraint Name Type Sort Column(s)
pk_notes Primary key Asc ID
i_notes_noowner Performance Asc ownergroup
i_notes_owner Performance Asc/Asc/Asc owneruser + ownergroup + assigneduser
s_notes Performance Asc name