/ 
App-bif-0.1.5_5
++
/ bif-doc-table-projects

NAME

bif-doc-table-projects - project current meta data

VERSION

0.1.5_5 (2015-08-13)

DEFINITION

    CREATE TABLE projects (
        id integer NOT NULL PRIMARY KEY,
        parent_id integer,
        name varchar(40) NOT NULL,
        title varchar(1024) NOT NULL,
        path varchar collate nocase UNIQUE,
        status_id integer NOT NULL DEFAULT -1,
        FOREIGN KEY(id) REFERENCES nodes(id)
            ON DELETE CASCADE
        FOREIGN KEY(parent_id) REFERENCES projects(id)
            ON DELETE CASCADE,
        FOREIGN KEY(status_id,id) REFERENCES project_status(id,project_id)
            DEFERRABLE INITIALLY DEFERRED
    )

DESCRIPTION

Table projects contains the project-specific meta data for a node. Rows should only be inserted into this table by func_new_project() and only changed by triggers on the projects_tomerge table. Deleting directly from this table is fine.

AFFECTED TABLES

SEE ALSO

bif-doc-func-new-project, bif-doc-table-nodes, bif-doc-table-projects-tomerge, bif-doc-table-project-status, bif-doc-table-projects-tree, bif-doc-table-changes

AUTHOR

Mark Lawrence <nomad@null.net>

COPYRIGHT AND LICENSE

Copyright 2013-2015 Mark Lawrence <nomad@null.net>

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 3 of the License, or (at your option) any later version.