diff -r 9f7da8dc8df8 -r 7dce6c0f06fb doc/images/db-schema.svg --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/doc/images/db-schema.svg Sun Dec 18 11:49:46 2011 +0100 @@ -0,0 +1,96 @@ + + + + + + +G + + +message + +message + +- id : INTEGER +- recipient : VARCHAR +- isBilled : BOOLEAN +- date : DATETIME +- price : NUMERIC(8, 2) +- job : INTEGER +- offer : VARCHAR + + +job + +job + +- hash : VARCHAR +- info : VARCHAR +- status : VARCHAR(7) +- user : VARCHAR + + +message->job + + ++ hash ++ job + + +offer + +offer + +- name : VARCHAR +- provider : VARCHAR +- route : VARCHAR +- typ : VARCHAR + + +message->offer + + ++ name ++ offer + + +userright + +userright + +- user : VARCHAR +- offer : VARCHAR +- isDefault : BOOLEAN + + +apiuser + +apiuser + +- name : VARCHAR +- apikey : VARCHAR + + +job->apiuser + + ++ name ++ user + + +apiuser->userright + ++ name ++ user + + +offer->userright + ++ name ++ offer + + +