agent

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('agent_id_seq'::regclass)
agent.parent_id fk_268b9c9d727aca70 N
agent_meta.object_id fk_7a69aed6232d562b C
agent_relation.agent_id fk_54585edd3414710b C
event.agent_id fk_3bae0aa73414710b C
opportunity.agent_id fk_8389c3d73414710b C
project.agent_id fk_2fb3d0ee3414710b C
registration.agent_id fk_62a8a7a73414710b C
seal.agent_id fk_2e30ae303414710b C
seal_relation.agent_id fk_487af6513414710b C
seal_relation.owner_id fk_487af6517e3c61f9 C
space.agent_id fk_2972c13a3414710b C
subsite.agent_id fk_b0f67b6f3414710b R
usr.profile_id fk_1762498cccfa12b8 N
parent_id int4 10 √ null
agent.id fk_268b9c9d727aca70 N
user_id int4 10 null
usr.id fk_268b9c9da76ed395 C
type int2 5 null
name varchar 255 null
db_update.name Implied Constraint R
location point 2147483647 √ null

type=POINT
_geo_location geography 2147483647 √ null
short_description text 2147483647 √ null
long_description text 2147483647 √ null
create_timestamp timestamp 29,6 null
status int2 5 null
is_verified bool 1 false
public_location bool 1 √ null
update_timestamp timestamp 22 √ null
subsite_id int4 10 √ null
subsite.id fk_268b9c9dbddfbe89 N

Indexes

Constraint Name Type Sort Column(s)
agent_pk Primary key Asc id
idx_268b9c9dc79c849a Performance Asc subsite_id

Relationships

Close relationships within degrees of separation