Table fossology.public.agent_lic_raw Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
lic_pk serial 10  √  nextval('agent_lic_raw_lic_pk_seq'::regclass) License primary key. Uniquely identifies a license section.
lic_name text 2147483647 Common license name (typically abbreviation like GPLv2)
lic_unique text 2147483647 A unique identifier for the license (used to remove duplicate entries)
lic_text text 2147483647  √  null The actual license text
lic_version int4 10 1 Analysis code version (bsam/filter)
lic_section text 2147483647  √  null Section identifier
lic_id int4 10  √  null uniquely identifies a license (s opposed to a license section)
lic_name_full text 2147483647  √  null Full text license name
lic_url text 2147483647  √  null URL origin of the license
lic_date timestamptz 35,6  √  null when license text was captured
lic_tokens int4 10  √  null # of filter_license tokens in license

Table contained 435 rows at Fri Jul 31 14:27 GMT-07:00 2009

Indexes:
Column(s) Type Sort Constraint Name
lic_pk Primary key Asc lic_pkey
lic_pk Must be unique Asc lic_pk
lic_unique + lic_version Must be unique Asc/Asc One unique per software version