| 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 |
Please support this project |
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
33 Tables and 7 Views:
Total rows: 14,083,948
| 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 |