Table webco_3.6.1.public.location_schedule_node 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
obj_oid int4 10
location_schedule_oid int4 10
location_schedule.obj_oid fkclocation_schedule_node_location_schedule
day_number int4 10
status varchar 2147483647
start_time_minutes int4 10  √  null
end_time_minutes int4 10  √  null

Table contained 0 rows at Wed May 11 15:14 EDT 2011

Indexes:
Column(s) Type Sort Constraint Name
obj_oid Primary key Asc location_schedule_node_pkey
end_time_minutes Performance Asc location_schedule_node_end_idx
day_number Performance Asc location_schedule_node_node_idx
start_time_minutes Performance Asc location_schedule_node_start_idx
status Performance Asc location_schedule_status_idx

Close relationships  within of separation: