notes


Details

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID serial 10 nextval('"notes_ID_seq"'::regclass)
owneruser int4 10 null
users.ID FK_notes_owneruser C

The owner user

ownergroup int4 10 null
groups.ID FK_notes_ownergroup C

The owner group (if owneruser and ownergroup are NULL, the element is public)

creator int4 10 null
users.ID FK_notes_creator N

The object creator

assigneduser int4 10 null
users.ID FK_notes_assigneduser N

The assigned user

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

Last modification date/time (Unix timestamp in seconds)

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

Last modification date/time (Unix timestamp in seconds)

visibility int2 5 0

0: Visible, 1: Archived, 2: Deleted

name text 2147483647 null
status int2 5 0

0: Draft, 1: Feedback required, 2: In revision, 3: Awaiting approval, 4: Final, 5: Obsolete

contenttype text 2147483647 ''::text

MIME type for the note content, e.g. "text/plain"

size int4 10 0
text text 2147483647 ''::text
description text 2147483647 ''::text

The general description field

binfile int4 10 null

Underlying binary file for the note content

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PK_notes_ID Primary key Asc ID

Relationships