Hi Kotrappa,
I don’t know where you are getting the “??”. Here is what you should have
(from our master database schema):
CREATE TABLE "public"."license_ref" (
"rf_pk" bigint NOT NULL DEFAULT nextval('license_ref_rf_pk_seq'::regclass),
"rf_shortname" text NOT NULL,
"rf_text" text NOT NULL,
"rf_url" text,
"rf_add_date" date,
"rf_copyleft" bit(1),
"rf_OSIapproved" bit(1),
"rf_fullname" text,
"rf_FSFfree" bit(1),
"rf_GPLv2compatible" bit(1),
"rf_GPLv3compatible" bit(1),
"rf_notes" text,
"rf_Fedora" text,
"marydone" boolean NOT NULL DEFAULT false,
"rf_active" boolean NOT NULL DEFAULT true,
"rf_text_updatable" boolean NOT NULL DEFAULT false,
"rf_md5" character(32),
"rf_detector_type" integer NOT NULL,
CONSTRAINT "rf_md5unique" UNIQUE (rf_md5),
CONSTRAINT "rf_pkpk" PRIMARY KEY (rf_pk)
) WITHOUT OIDS;
COMMENT ON COLUMN "license_ref"."rf_pk" IS 'Primary Key';
COMMENT ON COLUMN "license_ref"."rf_shortname" IS 'GPL, APSL, MIT, ...';
COMMENT ON COLUMN "license_ref"."rf_text" IS 'reference License text, or
regex';
COMMENT ON COLUMN "license_ref"."rf_url" IS 'URL of authoritative license
text';
COMMENT ON COLUMN "license_ref"."rf_add_date" IS 'Date License added to this
table';
COMMENT ON COLUMN "license_ref"."rf_copyleft" IS 'Is license copyleft?';
COMMENT ON COLUMN "license_ref"."rf_OSIapproved" IS 'Is license OSI approved?
';
COMMENT ON COLUMN "license_ref"."rf_fullname" IS 'GNU General Public License,
Apple Public Source License, ...';
COMMENT ON COLUMN "license_ref"."rf_FSFfree" IS 'Is license FSF free?';
COMMENT ON COLUMN "license_ref"."rf_GPLv2compatible" IS 'Is license GPL v2
compatible';
COMMENT ON COLUMN "license_ref"."rf_GPLv3compatible" IS 'Is license GPL v3
compatible';
COMMENT ON COLUMN "license_ref"."rf_notes" IS 'General notes (public)';
COMMENT ON COLUMN "license_ref"."rf_Fedora" IS '"Good", "Bad", "Unknown"';
COMMENT ON COLUMN "license_ref"."rf_active" IS 'change this to false if you
don''t want this reference license to be used in new analyses (does not apply
to nomos agent)';
COMMENT ON COLUMN "license_ref"."rf_text_updatable" IS 'true if the license
text can be updated (eg written by nomos)';
COMMENT ON COLUMN "license_ref"."rf_md5" IS 'md5 of the license text, used to
keep duplicates out of the system';
COMMENT ON COLUMN "license_ref"."rf_detector_type" IS '1 uses reference
license, 2 nomos’;
Thanks,
Bob Gobeille
> On Nov 6, 2014, at 3:43 AM, Kotrappa DeverShetty (WT01 - Manufacturing & Hi
> Tech) <[email protected]> wrote:
>
> Hello Bob,
>
> We would like to understand the meaning of column with “??” in license_ref
> table below
> If you can explain here or give us link of information, we would be grateful
> to you.
> This is required because we want to store similar information in our database
> of in-house tool we are developing.
>
> license_ref table
> ----------------------
>
> rf_pk, - License id primary key
> rf_shortname, - short name of license -like GPL
> rf_text, -complete license text
> rf_url, - URL of where license text is got from
> rf_add_date, - ??
> rf_copyleft, - ??
> rf_OSIapproved, - flag of OSI approval
> rf_fullname, - full name of license e.g. General Public License
> rf_FSFfree, - ??
> rf_GPLv2compatible, --??
> rf_GPLv3compatible, --??
> rf_notes, --??
> rf_Fedora, --??
> marydone, --??
> rf_active, --??
> rf_text_updatable, --??
> rf_md5, - MD5 checksum of license text
> rf_detector_type --??
>
> Regards
> Kotrappa.
>
>
> From: Kotrappa DeverShetty (WT01 - Manufacturing & Hi Tech)
> Sent: 03 November 2014 19:11
> To: '[email protected]'
> Cc: '[email protected]'; Ravishankar T.S (WT01 - Manufacturing & Hi Tech)
> Subject: license_ref table column information
>
> Hello Bob,
>
> We would like to understand the meaning of column with “??” in license_ref
> table below
> If you can explain here or give us link of information, we would be grateful
> to you.
> This is required because we want to store similar information in our database
> of in-house tool we are developing.
>
> license_ref table
> ----------------------
>
> rf_pk, - License id primary key
> rf_shortname, - short name of license -like GPL
> rf_text, -complete license text
> rf_url, - URL of where license text is got from
> rf_add_date, - ??
> rf_copyleft, - ??
> rf_OSIapproved, - flag of OSI approval
> rf_fullname, - full name of license e.g. General Public License
> rf_FSFfree, - ??
> rf_GPLv2compatible, --??
> rf_GPLv3compatible, --??
> rf_notes, --??
> rf_Fedora, --??
> marydone, --??
> rf_active, --??
> rf_text_updatable, --??
> rf_md5, - MD5 checksum of license text
> rf_detector_type --??
>
> Regards
> Kotrappa.
> The information contained in this electronic message and any attachments to
> this message are intended for the exclusive use of the addressee(s) and may
> contain proprietary, confidential or privileged information. If you are not
> the intended recipient, you should not disseminate, distribute or copy this
> e-mail. Please notify the sender immediately and destroy all copies of this
> message and any attachments.
>
> WARNING: Computer viruses can be transmitted via email. The recipient should
> check this email and any attachments for the presence of viruses. The company
> accepts no liability for any damage caused by any virus transmitted by this
> email.
>
> www.wipro.com
>
_______________________________________________
fossology mailing list
[email protected]
http://lists.fossology.org/mailman/listinfo/fossology
