Groups
From Open Source Software Research
Appears in the following schemas:
- sf0103
- sf1104
- sf1204
- sf0205
- sf0305
- sf0405
- sf0505
- sf0605
- sf0705
- sf0805
- sf0905
- sf1005
- sf1105
- sf1205
- sf0106
- sf0206
- sf0306
- sf0406
- sf0506
- sf0606
- sf0706
- sf0806
- sf0906
- sf1006
- sf1106
- sf1206
- sf0107
- sf0207
- sf0307
- sf0407
- sf0507
- sf0607
- sf0707
- sf0807
- sf0907
- sf1007
- sf1107
- sf1207
- sf0108
- sf0208
- sf0308
- sf0408
- sf0508
- sf0608
- sf0708
- sf0808
- sf0908
- sf1008
- sf1108
- sf1208
- sf0109
- sf0209
- sf0309
- sf0409
- sf0509
- sf0609
- sf0709
- sf0809
- sf0909
- sf1009
- sf1109
- sf1209
- sf0110
- sf0210
- sf0310
- sf0410
- sf0510
- sf0610
- sf0710
- sf0810
- sf0910
- sf1010
- sf1110
- sf1210
- sf0111
- sf0211
- sf0311
- sf0411
- sf0511
- sf0611
- sf0711
- sf0811
- sf0911
- sf1011
- sf1111
- sf1211
- sf0112
- sf0212
- sf0312
- sf0412
- sf0512
- sf0612
- sf0712
- sf0812
- sf0912
- sf1012
- sf1112
- sf1212
- sf0113
- sf0213
- sf0813
- sf0913
- sf1013
- sf1113
- sf1213
- sf0114
- sf0214
- sf0314
- sf0514
- sf0614
- sf0714
- sf0814
- sf0914
Most Recent Description
| 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.
