space

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('space_id_seq'::regclass)
event_attendance.space_id fk_350dd4be23575340 C
event_occurrence.space_id fk_e61358dc23575340 C
space.parent_id fk_2972c13a727aca70 C
space_meta.object_id fk_bc846ebf232d562b C
space_relation.space_id fk_1a0e9a3023575340 C
parent_id int4 10 √ null
space.id fk_2972c13a727aca70 C
location point 2147483647 √ null

type=POINT
_geo_location geography 2147483647 √ null
name varchar 255 null
db_update.name Implied Constraint R
short_description text 2147483647 √ null
long_description text 2147483647 √ null
create_timestamp timestamp 29,6 now()
status int2 5 null
type int2 5 null
agent_id int4 10 √ null
agent.id fk_2972c13a3414710b C
is_verified bool 1 false
public bool 1 false
update_timestamp timestamp 22 √ null
subsite_id int4 10 √ null
subsite.id fk_2972c13abddfbe89 N

Indexes

Constraint Name Type Sort Column(s)
space_pk Primary key Asc id
idx_2972c13ac79c849a Performance Asc subsite_id
space_location Performance Asc _geo_location
space_type Performance Asc type

Relationships

Close relationships within degrees of separation