| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293 | ----------------------------------------------------- 업무관리----------------------------------------------------- 선임 항목 -- 작업자를 한명 설정하게 됨으로써 이는 사용하지 않음--CREATE TABLE FmsBusinessSeniorItem --(--	SiteId				int					NOT NULL,		-- 현장 고유번호--	SeniorItemId		int	identity(1,1)	NOT NULL,		-- 선임 항목 고유번호--	Name				nvarchar(52)		NOT NULL,		-- 항목 이름--	PeopleCount			int					NOT NULL,		-- 사람 수--	Qualification		nvarchar(200)		NULL,			-- 자격--	IsUse				bit					NULL,			-- 사용 유무--	PRIMARY KEY (SiteId ASC , SeniorItemId ASC)--);--DBCC CHECKIDENT( FmsBusinessSeniorItem, RESEED, 1 )-- 자격증 -> CmUserLicense 로 변경--CREATE TABLE FmsBusinessLicense--(--	SiteId					int				NOT NULL,		-- 현장 고유번호--	LicenseId				int	identity(1,1) NOT NULL,		-- 자격증 고유번호--	Name					nvarchar(52)	NOT NULL,		-- 자격증 이름--	IssuingOffice			nvarchar(52)	NOT NULL,		-- 발행사 --	BusinessFieldId					int				NULL,	-- 사업 영역 고유번호--	EducationalInstitute	nvarchar(52)	NULL,			-- 교육 기관--	Note					nvarchar(256)	NULL,			-- 메모--	IsUse					bit				NULL,			-- 사용 유무--	PRIMARY KEY (SiteId ASC , LicenseId ASC)--);--DBCC CHECKIDENT( FmsBusinessLicense, RESEED, 1 )-- 자격증 -> CmUserToLicense 로 변경--CREATE TABLE FmsBusinessSeniorItemToLicense--(--	SiteId					int		NOT NULL,				-- 현장 고유번호--	SeniorItemId			int		NOT NULL,				-- 선임 항목 고유번호--	LicenseId				int		NOT NULL,				-- 자격증 고유번호--	PRIMARY KEY (SiteId ASC , SeniorItemId ASC , LicenseId ASC)--);-- 선임--CREATE TABLE FmsBusinessSenior--(--	SiteId				int					NOT NULL,		-- 현장 고유번호--	SeniorItemId		int					NOT NULL,		-- 선임 항목 고유번호--	SeniorId			int	identity(1,1)	NOT NULL,		-- 선임 고유번호--	SeniorUserId        nvarchar(24)		NOT NULL ,		-- 선임 사용자 고유번호--	StartDate			datetime			NULL,			-- 시작 날짜--	EndDate				datetime			NULL,			-- 완료 날짜--	Note				nvarchar(256)	NULL,				-- 메모--	IsUse				bit				NULL,				-- 사용 유무--	PRIMARY KEY (SiteId ASC , SeniorId ASC)--);--DBCC CHECKIDENT( FmsBusinessSenior, RESEED, 1 )--ALTER TABLE FmsBusinessSeniorItem--	ADD CONSTRAINT FK__FmsBusinessSeniorItem__CmSite FOREIGN KEY (SiteId) REFERENCES CmSite(SiteId)--;--ALTER TABLE FmsBusinessLicense--	ADD CONSTRAINT FK__FmsBusinessLicense__CmSite FOREIGN KEY (SiteId) REFERENCES CmSite(SiteId)--;--ALTER TABLE FmsBusinessLicense--	ADD CONSTRAINT FK__FmsBusinessLicense__CmBusinessField FOREIGN KEY (SiteId,BusinessFieldId) REFERENCES CmBusinessField(SiteId, BusinessFieldId)--;--ALTER TABLE FmsBusinessSenior--	ADD CONSTRAINT FK__FmsBusinessSenior__CmSite FOREIGN KEY (SiteId) REFERENCES CmSite(SiteId)--;--ALTER TABLE FmsBusinessSenior--	ADD CONSTRAINT FK__FmsBusinessSenior__FmsBusinessSeniorItem FOREIGN KEY (SiteId,SeniorItemId) REFERENCES FmsBusinessSeniorItem(SiteId,SeniorItemId)--;--ALTER TABLE FmsBusinessSenior--	ADD CONSTRAINT FK__FmsBusinessSenior__CmUser FOREIGN KEY (SiteId,SeniorUserId) REFERENCES CmUser(SiteId,UserId)--;--ALTER TABLE FmsBusinessSeniorItemToLicense--	ADD CONSTRAINT FK__FmsBusinessSeniorItemToLicense__FmsBusinessSeniorItem FOREIGN KEY (SiteId,SeniorItemId) REFERENCES FmsBusinessSeniorItem(SiteId,SeniorItemId)--;--ALTER TABLE FmsBusinessSeniorItemToLicense--	ADD CONSTRAINT FK__FmsBusinessSeniorItemToLicense__FmsLicense FOREIGN KEY (SiteId,LicenseId) REFERENCES FmsBusinessLicense(SiteId,LicenseId)--;
 |