List of relations Name | Type | Owner ----------------------------+-------+----------- blogs_article_associations | table | webmonkey blogs_article_categories | table | webmonkey blogs_articles | table | webmonkey blogs_categories | table | webmonkey blogs_comments | table | webmonkey blogs_link_categories | table | webmonkey blogs_links | table | webmonkey blogs_project_links | table | webmonkey blogs_project_types | table | webmonkey blogs_projects | table | webmonkey blogs_weblogs | table | webmonkey (11 rows) Table "blogs_article_associations" Attribute | Type | Modifier --------------------+--------------------------+---------- article_referer_id | integer | not null article_id | integer | not null creation_date | timestamp with time zone | not null notes | text | Index: blogs_article_associations_pkey Constraint: (article_referer_id <> article_id) Table "blogs_article_categories" Attribute | Type | Modifier ------------+---------+---------- article_id | integer | not null cat_id | integer | not null Index: blogs_article_categories_pkey Table "blogs_articles" Attribute | Type | Modifier ---------------+--------------------------+------------------------------------------------------------------- article_id | integer | not null default nextval('"blogs_articles_article_id_seq"'::text) title | text | description | text | creation_date | timestamp with time zone | not null updated | timestamp with time zone | content | text | not null blog_id | integer | not null project_id | integer | keywords | text | Index: blogs_articles_pkey Table "blogs_categories" Attribute | Type | Modifier -------------+---------+----------------------------------------------------------------- cat_id | integer | not null default nextval('"blogs_categories_cat_id_seq"'::text) cat_name | text | not null description | text | parent_id | integer | Index: blogs_categories_pkey Constraint: (cat_id <> parent_id) Table "blogs_comments" Attribute | Type | Modifier ------------+--------------------------+------------------------------------------------------------------- comment_id | integer | not null default nextval('"blogs_comments_comment_id_seq"'::text) article_id | integer | not null name | text | email | text | comment | text | not null created | timestamp with time zone | not null Index: blogs_comments_pkey Table "blogs_link_categories" Attribute | Type | Modifier -----------+---------+---------- link_id | integer | not null cat_id | integer | not null Index: blogs_link_categories_pkey Table "blogs_links" Attribute | Type | Modifier ---------------+--------------------------+------------------------------------------------------------- link_id | integer | not null default nextval('"blogs_links_link_id_seq"'::text) link_text | text | not null description | text | annotation | text | creation_date | timestamp with time zone | not null link_url | text | Index: blogs_links_pkey Constraint: (link_url NOTNULL) Table "blogs_project_links" Attribute | Type | Modifier ------------+---------+---------- project_id | integer | not null link_id | integer | not null Index: blogs_project_links_pkey Table "blogs_project_types" Attribute | Type | Modifier -------------+---------+--------------------------------------------------------------------- type_id | integer | not null default nextval('"blogs_project_types_type_id_seq"'::text) type_name | text | not null description | text | Index: blogs_project_types_pkey Table "blogs_projects" Attribute | Type | Modifier ---------------+--------------------------+------------------------------------------------------------------- project_id | integer | not null default nextval('"blogs_projects_project_id_seq"'::text) project_name | text | not null type_id | integer | not null creation_date | timestamp with time zone | not null description | text | status | character varying(10) | not null Index: blogs_projects_pkey Table "blogs_weblogs" Attribute | Type | Modifier ---------------+--------------------------+--------------------------------------------------------------- blog_id | integer | not null default nextval('"blogs_weblogs_blog_id_seq"'::text) blog_name | text | not null description | text | creation_date | timestamp with time zone | not null url | text | Index: blogs_weblogs_pkey -------------------------------------------------------------------------------- Relation Diagram _________________ __________________ _______________________ | blogs_weblogs | | blogs_projects | | blogs_project_types | ----------------- ------------------ ----------------------- | blog_id |<-+ +->| project_id | +->| type_id | _________________ | | | type_id |*----+ _______________________ | | __________________ | | +---------------+ +---+-------------------------+ | __________________ | __________________ | _______________________ | | blogs_articles | | | blogs_comments | | | blogs_project_links | | ------------------ | ------------------ | ----------------------- +-*| blog_id | | +-*| article_id | +-*| project_id | | project_id |*-+ | __________________ +-*| link_id | | article_id |<-+-+ | _______________________ __________________ | | | | +--------|-------------------------+ _______________ | | ____________________________ | blogs_links | | | | blogs_article_categories | --------------- | | ---------------------------- | link_id |<-+ | | cat_id |*------+ _______________ | +-*| article_id | | | ____________________________ | | | +-----------+ | | _________________________ ____________________ | | | blogs_link_categories | | blogs_categories | | | ------------------------- -------------------- | +-*| link_id | +->| cat_id |<-+ | cat_id |*-----+ ____________________ _________________________