| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960 | ----------------------------------------------------- 건물/층 관리-----------------------------------------------------CREATE TABLE InbuBuildingCREATE TABLE CmBuilding(	SiteId				int  NOT NULL ,					-- 현장 고유번호	BuildingId          int  identity(1,1) NOT NULL ,	-- 빌딩 고유번호	Name				nvarchar(50)  NOT NULL ,		-- 빌딩 이름		PRIMARY KEY (SiteId ASC , BuildingId ASC));DBCC CHECKIDENT( CmBuilding, RESEED, 1 )CREATE TABLE CmFloor(	SiteId				int  NOT NULL ,					-- 현장 고유번호	BuildingId          int  NOT NULL ,					-- 빌딩 고유번호	FloorId             int  identity(1,1) NOT NULL ,	-- 층 고유번호	Name				nvarchar(50)  NOT NULL ,		-- 층 이름	PRIMARY KEY (SiteId ASC , BuildingId ASC , FloorId ASC));DBCC CHECKIDENT( CmFloor, RESEED, 1 )CREATE TABLE CmZone(	SiteId				int  NOT NULL ,					-- 현장 고유번호	BuildingId          int  NOT NULL ,					-- 빌딩 고유번호	FloorId             int  NOT NULL ,					-- 층 고유번호	ZoneId				int  identity(1,1) NOT NULL ,	-- 존 고유번호	Name				nvarchar(50)  NOT NULL ,		-- 존 이름		PRIMARY KEY (SiteId ASC , BuildingId ASC , FloorId ASC , ZoneId ASC));DBCC CHECKIDENT( CmZone, RESEED, 1 )ALTER TABLE CmBuilding	ADD CONSTRAINT FK__CmBuilding__CmSite FOREIGN KEY (SiteId) REFERENCES CmSite(SiteId);ALTER TABLE CmFloor	ADD CONSTRAINT FK__CmFloor_CmBuilding FOREIGN KEY (SiteId , BuildingId) REFERENCES CmBuilding(SiteId , BuildingId);ALTER TABLE CmZone	ADD CONSTRAINT FK__CmZone__CmBuilding FOREIGN KEY (SiteId , BuildingId) REFERENCES CmBuilding(SiteId , BuildingId);ALTER TABLE CmZone	ADD CONSTRAINT FK__CmZone__CmFloor FOREIGN KEY (SiteId , BuildingId , FloorId) REFERENCES CmFloor(SiteId , BuildingId , FloorId);--ALTER TABLE CmBuilding--	ADD CONSTRAINT FK__CmBuilding__CmFile FOREIGN KEY (SiteId,FileId) REFERENCES CmFile(SiteId,FileId)--;--ALTER TABLE CmFloor--	ADD CONSTRAINT FK__CmFloor__CmFile FOREIGN KEY (SiteId,FileId) REFERENCES CmFile(SiteId,FileId)--;
 |