1. points table that contains my points (typically contacts with coordinates), a


2. spans table that links two points together, an


3. endpoints table that references a span and a point, indicating that while there may be another span connected to that same contact point, it is not electrically connected to the referenced span, and a


4. feeds table that contains the power supply devices and references a span.

table circuits
	(
	span_id int primary key,
	point1 int,
	point1_ends bit,
	point2 int,
	point2_ends bit
	)

;with trace as
(
select distinct
	c.span_id,
	c.point1,
	c.point1_ends,
	c.point2,
	c.point2_ends,
	0 as 'span_count'
from
	circuits c
inner join
	feeds f
	on
		f.span_id = c.span_id
where
	f.ps_id = 1 --this is the power supply I want to get the circuit for

union all

select
	c.span_id,
	c.point1,
	c.point1_ends,
	c.point2,
	c.point2_ends,
	t.span_count + 1
from
	circuits c
inner join
	trace t
	on
	(c.point1 = t.point1 and c.span_id != t.span_id and t.point1_ends != 1)
	or
	(c.point1 = t.point2 and c.span_id != t.span_id and t.point2_ends != 1)
	or
	(c.point2 = t.point1 and c.span_id != t.span_id and t.point1_ends != 1)
	or
	(c.point2 = t.point2 and c.span_id != t.span_id and t.point2_ends != 1)
where
	t.span_count < 20
)

select * from trace;