var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Table Design Question
I am developing a scheduling solution that will track reservations in certain aeas of our building.
My problem is that I have facilities that are subfacilities of other facilities and I will need to be able to pick those out.
CREATE TABLE [dbo].[Facility] (
[FacilityID] [int] IDENTITY (1, 1) NOT NULL ,
[FacilityName] [varchar] (50) NULL ,
[SubFacility] [int] NULL
) ON [PRIMARY]
Given this table is it possible to get a list of facilities and their subfacilities.
Thanks for your help.
If you invert the logic to use the ParentFacilityId instead of the SubFacility, then yes. Using this design you have now, each facility can have only one sub-facility!
Originally Posted by Pat Phelan
Thanks alot Pat.