Groups

From Open Source Software Research
Jump to: navigation, search

Appears in the following schemas:

Most Recent Description

Table "sf0914.groups"
Column Type Modifiers
group_id integer not null default nextval(('groups_pk_seq'::text)::regclass)
group_name character varying(40)
homepage character varying(128)
is_public integer not null default 0
status character(1) not null default 'A'::bpchar
unix_group_name character varying(64) not null default ''::character varying
http_domain character varying(80)
short_description text
license character varying(16)
register_time integer not null default 0
use_mail integer not null default 1
use_forum integer not null default 1
use_pm integer not null default 1
use_cvs integer not null default 0
use_news integer not null default 1
preferred_support_type integer not null default 1
preferred_support_resource text not null default ''::text
type integer not null default 1
use_docman integer not null default 1
not_open_source integer not null default 0
send_all_tasks integer not null default 0
use_pm_depend_box integer not null default 1
potm integer
donation_request text
donate_optin integer default 0
big_mirror integer
project_submitter integer
row_modtime integer
use_screenshots integer not null default 1
use_svn integer not null default 1
disable_mostactive integer
additional_trove_cats integer not null default 0
use_wiki integer not null default 0


Other Information About the Data

  • group_id: appears to be the unique identifier for projects.
  • unix_group_name: is the file name of the project (http://sourceforge.net/projects/unix_group_name/)
  • group_name: appears to default to unix_group_name if the project doesn't manually change the name
  • homepage: the url of the project's homepage
  • license: is the project's license type
  • register_time: is the date and time the project was registered on SF as a timestamp

ER diagram

See the ER diagrams page for numerous diagrams related to this table.