new cablestrandend schema?

[mzagrabe]

We need to keep track of (fiber) cable terminations on each end of a given cablestrand.

One solution could look like...

1. Create a new table cable_strand_end that references cablestrand.

create table cable_strand_end ( id bigint primary key default nextval('cable_strand_end_id_seq'), cablestrand foreign key references cablestrand(id), closet foreign key references closet(id), strand_termination foreign key references strand_termination(id) );

create table strand_termination( id bigint primar key default nextval('strand_termination_id_seq'), description varchar not null unqiue ); insert into strand_termination (description) values ('LC - UPC'); insert into strand_termination (description) values ('LC - APC'); insert into strand_termination (description) values ('SC'); insert into strand_termination (description) values ('ST');

Obviously there would be a bit of work to build up the UI around this schema, but it would give us the relational data structures to track the data.