diff -r 4841b443f1fd -r f65edc0382cc web/images/db-schema.svg --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/web/images/db-schema.svg Wed Apr 25 15:06:28 2012 +0200 @@ -0,0 +1,99 @@ + + + + + + +G + + +message + +message + +- id : INTEGER +- recipient : VARCHAR(100) +- isBilled : BOOLEAN +- date : DATETIME +- price : NUMERIC(8, 4) +- count : INTEGER +- exID : VARCHAR(100) +- job : VARCHAR(40) +- offer : VARCHAR(100) + + +job + +job + +- id : INTEGER +- info : VARCHAR(100) +- status : VARCHAR(7) +- user : VARCHAR(100) + + +message->job + + ++ id ++ job + + +offer + +offer + +- name : VARCHAR(100) +- provider : VARCHAR(100) +- route : VARCHAR(100) +- typ : VARCHAR(100) + + +message->offer + + ++ name ++ offer + + +userright + +userright + +- user : VARCHAR(100) +- offer : VARCHAR(100) +- default : INTEGER + + +apiuser + +apiuser + +- name : VARCHAR(100) +- ng_kunde : INTEGER +- apikey : VARCHAR(50) + + +job->apiuser + + ++ name ++ user + + +apiuser->userright + ++ name ++ user + + +offer->userright + ++ name ++ offer + + +