SchemaSpy Analysis of fossology.public Generated by
SchemaSpy
Generated by SchemaSpy on Mon Aug 18 18:25 GMT-07:00 2008
Database Type: PostgreSQL - 8.1.11 SourceForge.net

Please support this project

XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

33 Tables and 7 Views:

Table Children Parents Rows Comments
agent 1 22 Defines each agent used in the system.
A new agent record should be defined any time an agent changes in a way that alters the output given the same input.
agent_lic_meta 1 1 291,522 License analysis results
agent_lic_phrases 0 Use this list to group phrases. If the match string exists in the phrase (case-insensitive), then mark it as being part of this group.
agent_lic_raw 404 Raw licenses used for license analysis
agent_lic_status 1 631,545 List of license analysis status.
agent_wc 1 0 Table populated by WC agent.
This is a test/learning agent only.
attrib 2 3,737,261 attribute table. Relates keys to key values.
folder 11 Define a user folder. Folder construction is totally arbitrary and is defined by the user.
Contents can be other folders, uploads and uploadtree records.
foldercontents 24 Folder contents may be another folder, an upload_fk, or an uploadtree_fk. This is user definable.
job 1 1 55 Job info, one entry per user-meaningful job not per step
jobdepends 2 107
jobqueue 2 1 127 queue of steps required to accomplish user-meaningful jobs
key 1 1 152 Define each attribute key. This helps make the attribute data self documenting.
keyagent view key, agent join
leftnav view
lic_progress view track license agent progress by upload
license_14 4,145
licgroup 3 81
licgroup_grps 2 81
licgroup_lics 1 755
licterm 3 57
licterm_map 2 158
licterm_maplic 1 87
licterm_name 3 317,055
licterm_words 1 156
log 37,720 Errors, warnings, and processing logs.
mimetype 1 246 Define mime types for containers
pfile 6 1 1,694,527 physical files
proj 0
scheduler_status 162 The status of the scheduler.
sqlagentproc 0 sql procedures for agents
table_enum 23 enum of tables
ufile 2 1 3,683,726
uplicense view
upload 2 1 14 Information about (gold) files added to the repo.
uploadtree 2 3,683,713 Define the entire ufile tree for a given upload.
This is the navigation path for upload contents.
uptreeatkey view join uploadtree, ufile, pfile, attrib, and key
uptreeattrib view join uploadtree, ufile, pfile, attrib
uptreeup view joined uploadtree, ufile and pfile
users 12 FOSSology user table

Total rows: 14,083,948