digraph g {
graph [
rankdir = "LR",
concentrate = true,
ratio = auto
];
node [
fontsize = "10",
shape = record
];
edge [
];
"tags_linktags" [shape = plaintext, label = <
| \N | |
| link_id | integer | | | |
| tag_id | integer | | | |
| date_added | timestamp without time zone | | | |
> ];
"tags_sabrosus" [shape = plaintext, label = < | \N | |
| id_enlace | integer | | | |
| title | character varying | | | |
| enlace | character varying | | | |
| descripcion | character varying | | | |
| fecha | timestamp without time zone | | | |
| privado | integer | | | |
> ];
"tags_tags" [shape = plaintext, label = < | \N | |
| id | integer | | | |
| tag | character varying | | | |
| level | integer | | | |
| date_creation | timestamp without time zone | | | |
> ];
"vhffs_acl" [shape = plaintext, label = < | \N | |
| granted_oid | integer | PK | FK | |
| perm | integer | | | |
| target_oid | integer | PK | FK | |
> ];
"vhffs_boxes" [shape = plaintext, label = < | \N | |
| domain | character varying | PK | FK | |
| local_part | character varying | PK | | |
| domain_hash | character varying | | | |
| password | character varying | | | |
| mbox_name | character varying | | | |
| nospam | boolean | | | |
| novirus | boolean | | | |
| state | integer | | | |
| allowpop | boolean | | | |
| allowimap | boolean | | | |
> ];
"vhffs_cvs" [shape = plaintext, label = < | \N | |
| cvs_id | integer | PK | | |
| cvsroot | character varying | | | |
| public | boolean | | | |
| object_id | integer | | FK | |
> ];
"vhffs_dns" [shape = plaintext, label = < | \N | |
| dns_id | integer | PK | | |
| domain | character varying(255) | | | |
| object_id | integer | | FK | |
| ns | character varying(255) | | | |
| mbox | character varying(255) | | | |
| serial | integer | | | |
| refresh | integer | | | |
| retry | integer | | | |
| expire | integer | | | |
| minimum | integer | | | |
| ttl | integer | | | |
> ];
"vhffs_dns_rr" [shape = plaintext, label = < | \N | |
| id | serial | PK | | |
| zone | integer | | FK | |
| name | character varying(64) | | | |
| type | character varying(5) | | | |
| data | character varying(128) | | | |
| aux | integer | | | |
| ttl | integer | | | |
> ];
"vhffs_forward" [shape = plaintext, label = < | \N | |
| domain | character varying | PK | FK | |
| local_part | character varying | PK | | |
| remote_name | character varying | | | |
| password | character varying | | | |
> ];
"vhffs_git" [shape = plaintext, label = < | \N | |
| git_id | serial | PK | | |
| reponame | character varying | | | |
| public | integer | | | |
| ml_name | character varying | | | |
| object_id | integer | | FK | |
> ];
"vhffs_groups" [shape = plaintext, label = < | \N | |
| gid | serial | PK | | |
| groupname | character varying(50) | | | |
| passwd | character varying(20) | | | |
| quota | integer | | | |
| quota_used | integer | | | |
| object_id | integer | | FK | |
| realname | character varying(100) | | | |
> ];
"vhffs_history" [shape = plaintext, label = < | \N | |
| history_id | integer | PK | | |
| object_id | integer | | FK | |
| message | character varying(200) | | | |
| date | bigint | | | |
> ];
"vhffs_httpd" [shape = plaintext, label = < | \N | |
| httpd_id | integer | PK | | |
| servername | character varying(200) | | | |
| object_id | integer | | FK | |
> ];
"vhffs_mailings" [shape = plaintext, label = < | \N | |
| id_mailing | serial | PK | | |
| subject | character varying | | | |
| message | text | | | |
| state | integer | | | |
| date | bigint | | | |
> ];
"vhffs_ml" [shape = plaintext, label = < | \N | |
| ml_id | integer | PK | | |
| local_part | character varying | | | |
| domain | character varying | | FK | |
| prefix | character varying | | | |
| object_id | integer | | FK | |
| open_archive | boolean | | | |
| reply_to | boolean | | | |
| signature | character varying(250) | | | |
| sub_ctrl | integer | | | |
| post_ctrl | integer | | | |
> ];
"vhffs_ml_subscribers" [shape = plaintext, label = < | \N | |
| sub_id | integer | PK | | |
| member | character varying | | | |
| perm | integer | | | |
| hash | character varying | | | |
| ml_id | integer | | FK | |
| language | character varying(16) | | | |
> ];
"vhffs_mxdomain" [shape = plaintext, label = < | \N | |
| mxdomain_id | integer | PK | | |
| domain | character varying | | | |
| boxes_path | character varying | | | |
| catchall | character varying | | | |
| object_id | integer | | FK | |
> ];
"vhffs_mysql" [shape = plaintext, label = < | \N | |
| mysql_id | integer | PK | | |
| dbname | character varying(200) | | | |
| dbuser | character varying(200) | | | |
| dbpass | character varying(32) | | | |
| object_id | integer | | FK | |
> ];
"vhffs_object" [shape = plaintext, label = < | \N | |
| object_id | integer | PK | | |
| owner_uid | integer | | FK | |
| description | text | | | |
| owner_gid | integer | | FK | |
| type | integer | | | |
| state | integer | | | |
| refuse_reason | text | | | |
| date_creation | bigint | | | |
> ];
"vhffs_pgsql" [shape = plaintext, label = < | \N | |
| pgsql_id | integer | PK | | |
| dbname | character varying(200) | | | |
| dbpass | character varying(32) | | | |
| object_id | integer | | FK | |
| dbencoding | character varying(20) | | | |
| dbuser | character varying(200) | | | |
> ];
"vhffs_repository" [shape = plaintext, label = < | \N | |
| repository_id | serial | PK | | |
| name | character varying | | | |
| quota | integer | | | |
| quota_used | integer | | | |
| object_id | integer | | FK | |
> ];
"vhffs_svn" [shape = plaintext, label = < | \N | |
| svn_id | serial | PK | | |
| reponame | character varying | | | |
| public | integer | | | |
| object_id | integer | | FK | |
| ml_name | character varying | | | |
> ];
"vhffs_user_group" [shape = plaintext, label = < | \N | |
| uid | integer | PK | FK | |
| gid | integer | PK | FK | |
| state | integer | | | |
> ];
"vhffs_users" [shape = plaintext, label = < | \N | |
| uid | serial | PK | | |
| gid | integer | | | |
| username | character varying(50) | | | |
| shell | character varying(20) | | | |
| passwd | character varying(40) | | | |
| homedir | character varying(40) | | | |
| admin | integer | | | |
| firstname | character varying(250) | | | |
| lastname | character varying(250) | | | |
| address | text | | | |
| zipcode | character varying(16) | | | |
| city | character varying(250) | | | |
| country | character varying(250) | | | |
| mail | character varying(200) | | | |
| gpg_key | character varying(250) | | | |
| note | integer | | | |
| language | character varying(16) | | | |
| theme | character varying(250) | | | |
| object_id | integer | | FK | |
| lastloginpanel | bigint | | | |
> ];
"vhffs_acl":rtcol1 -> "vhffs_object":ltcol1 [label="fk_vhffs_acl_vhffs_object_src"];
"vhffs_acl":rtcol3 -> "vhffs_object":ltcol1 [label="fk_vhffs_acl_vhffs_object_dst"];
"vhffs_boxes":rtcol1 -> "vhffs_mxdomain":ltcol2 [label="fk_vhffs_boxes_vhffs_mxdomain"];
"vhffs_cvs":rtcol4 -> "vhffs_object":ltcol1 [label="fk_vhffs_cvs_vhffs_object"];
"vhffs_dns":rtcol3 -> "vhffs_object":ltcol1 [label="fk_vhffs_dns_vhffs_object"];
"vhffs_dns_rr":rtcol2 -> "vhffs_dns":ltcol1 [label="fk_vhffs_dns_rr_vhffs_dns"];
"vhffs_forward":rtcol1 -> "vhffs_mxdomain":ltcol2 [label="fk_vhffs_forward_vhffs_mxdomain"];
"vhffs_git":rtcol5 -> "vhffs_object":ltcol1 [label="fk_vhffs_git_vhffs_object"];
"vhffs_groups":rtcol6 -> "vhffs_object":ltcol1 [label="fk_vhffs_group_vhffs_object"];
"vhffs_history":rtcol2 -> "vhffs_object":ltcol1 [label="fk_vhffs_history_vhffs_object"];
"vhffs_httpd":rtcol3 -> "vhffs_object":ltcol1 [label="fk_vhffs_httpd_vhffs_object"];
"vhffs_ml":rtcol3 -> "vhffs_mxdomain":ltcol2 [label="fk_vhffs_ml_vhffs_mxdomain"];
"vhffs_ml":rtcol5 -> "vhffs_object":ltcol1 [label="fk_vhffs_ml_vhffs_object"];
"vhffs_ml_subscribers":rtcol5 -> "vhffs_ml":ltcol1 [label="fk_vhffs_ml_subscribers_vhffs_ml"];
"vhffs_mxdomain":rtcol5 -> "vhffs_object":ltcol1 [label="fk_vhffs_mxdomain_vhffs_object"];
"vhffs_mysql":rtcol5 -> "vhffs_object":ltcol1 [label="fk_vhffs_mysql_vhffs_object"];
"vhffs_object":rtcol2 -> "vhffs_users":ltcol1 [label="fk_vhffs_object_vhffs_user"];
"vhffs_object":rtcol4 -> "vhffs_groups":ltcol1 [label="fk_vhffs_object_vhffs_group"];
"vhffs_pgsql":rtcol4 -> "vhffs_object":ltcol1 [label="fk_vhffs_pgsql_vhffs_object"];
"vhffs_repository":rtcol5 -> "vhffs_object":ltcol1 [label="fk_vhffs_vhffs_repository_vhffs_object"];
"vhffs_svn":rtcol4 -> "vhffs_object":ltcol1 [label="fk_vhffs_svn_vhffs_object"];
"vhffs_user_group":rtcol1 -> "vhffs_users":ltcol1 [label="fk_vhffs_user_group_vhffs_users"];
"vhffs_user_group":rtcol2 -> "vhffs_groups":ltcol1 [label="fk_vhffs_user_group_vhffs_groups"];
"vhffs_users":rtcol19 -> "vhffs_object":ltcol1 [label="fk_vhffs_users_vhffs_object"];
}