Table fossology.public.agent 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
agent_pk serial 10  √  nextval('agent_agent_pk_seq'::regclass)
key.key_agent_fk key_key_agent_fk_fkey
Primary key
agent_name varchar 32 display name
agent_rev varchar 32  √  null revision string
agent_desc varchar 255  √  null short description
agent_id int4 10 currval('agent_agent_pk_seq'::regclass) agent ID (agents will have same ID regardless of revision)

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

Indexes:
Column(s) Type Sort Constraint Name
agent_pk Primary key Asc agent_pkey
agent_name + agent_rev Must be unique Asc/Asc agent_unique_name_rev

Close relationships  within of separation: