photo.sql.dot

图片管理程序

digraph g {
size="10,7.5"
;ratio="auto"
;page="8.5,11";
graph [
rankdir = "LR"
];
node [fontsize = "16"
shape = "ellipse"
];
edge [
];
"cat" [
label = "<f0> cat| <f1> id| <f2> name"
shape = "record"
];
"wwwusers" [
label = "<f0> wwwusers| <f1> id| <f2> username| <f3> password| <f4> email| <f5> realname| <f6> canadd"
shape = "record"
];
"keywords" [
label = "<f0> keywords| <f1> word_id| <f2> word"
shape = "record"
];
"album" [
label = "<f0> album| <f1> keywords| <f2> descr| <f3> cat| <f4> taken| <f5> size| <f6> addedby| <f7> width| <f8> height| <f9> ts| <f10> id"
shape = "record"
];
"album_keywords_map" [
label = "<f0> album_keywords_map| <f1> album_id| <f2> word_id"
shape = "record"
];
"commentary" [
label = "<f0> commentary| <f1> comment_id| <f2> wwwuser_id| <f3> photo_id| <f4> note| <f5> remote_addr| <f6> ts"
shape = "record"
];
"votes" [
label = "<f0> votes| <f1> vote_id| <f2> wwwuser_id| <f3> photo_id| <f4> vote| <f5> remote_addr| <f6> ts"
shape = "record"
];
"wwwacl" [
label = "<f0> wwwacl| <f1> userid| <f2> cat| <f3> canview| <f4> canadd"
shape = "record"
];
"wwwgroup" [
label = "<f0> wwwgroup| <f1> userid| <f2> groupname"
shape = "record"
];
"searches" [
label = "<f0> searches| <f1> searches_id| <f2> name| <f3> addedby| <f4> search| <f5> ts"
shape = "record"
];
"image_store" [
label = "<f0> image_store| <f1> id| <f2> line| <f3> data"
shape = "record"
];
"user_agent" [
label = "<f0> user_agent| <f1> user_agent_id| <f2> user_agent"
shape = "record"
];
"log_types" [
label = "<f0> log_types| <f1> log_type_id| <f2> log_type"
shape = "record"
];
"photo_logs" [
label = "<f0> photo_logs| <f1> log_id| <f2> log_type| <f3> wwwuser_id| <f4> photo_id| <f5> remote_addr| <f6> user_agent| <f7> extra_info| <f8> ts"
shape = "record"
];
"user_profiles" [
label = "<f0> user_profiles| <f1> profile_id| <f2> name| <f3> description| <f4> expires"
shape = "record"
];
"user_profile_acls" [
label = "<f0> user_profile_acls| <f1> profile_id| <f2> cat_id"
shape = "record"
];
"user_profile_log" [
label = "<f0> user_profile_log| <f1> log_id| <f2> profile_id| <f3> wwwuser_id| <f4> ts| <f5> remote_addr"
shape = "record"
];
"galleries" [
label = "<f0> galleries| <f1> gallery_id| <f2> gallery_name| <f3> wwwuser_id| <f4> ispublic| <f5> ts"
shape = "record"
];
"galleries_map" [
label = "<f0> galleries_map| <f1> gallery_id| <f2> album_id"
shape = "record"
];
"album":f3 -> "cat":f1 [
id = 1
];
"album":f6 -> "wwwusers":f1 [
id = 2
];
"album_keywords_map":f1 -> "album":f10 [
id = 3
];
"album_keywords_map":f2 -> "keywords":f1 [
id = 4
];
"commentary":f2 -> "wwwusers":f1 [
id = 5
];
"commentary":f3 -> "album":f10 [
id = 6
];
"votes":f2 -> "wwwusers":f1 [
id = 7
];
"votes":f3 -> "album":f10 [
id = 8
];
"wwwacl":f1 -> "wwwusers":f1 [
id = 9
];
"wwwacl":f2 -> "cat":f1 [
id = 10
];
"wwwgroup":f1 -> "wwwusers":f1 [
id = 11
];
"searches":f3 -> "wwwusers":f1 [
id = 12
];
"image_store":f1 -> "album":f10 [
id = 13
];
"photo_logs":f2 -> "log_types":f1 [
id = 14
];
"photo_logs":f3 -> "wwwusers":f1 [
id = 15
];
"photo_logs":f6 -> "user_agent":f1 [
id = 16
];
"user_profile_acls":f1 -> "user_profiles":f1 [
id = 17
];
"user_profile_acls":f2 -> "cat":f1 [
id = 18
];
"user_profile_log":f2 -> "user_profiles":f1 [
id = 19
];
"user_profile_log":f3 -> "wwwusers":f1 [
id = 20
];
"galleries":f3 -> "wwwusers":f1 [
id = 21
];
"galleries_map":f1 -> "galleries":f1 [
id = 22
];
"galleries_map":f2 -> "album":f10 [
id = 23
];
}