| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591 | 
							- ---------------------------------------------------
 
- -- 기초코드관리
 
- ---------------------------------------------------
 
- ---- work_because_first_WobeFirst
 
- ---- 작업 관리/원인 분류/대분류
 
- -- WobeFirst, WobeSecond를 통합
 
- CREATE TABLE FmsWorkCodeCauseClass
 
- (
 
- 	SiteId				int  NOT NULL ,					-- 현장 고유번호
 
- 	CauseClassId		int  identity(1,1) NOT NULL ,	-- 원인분류 고유번호
 
- 	ParentId			int  NOT NULL ,					-- 부모 원인분류 고유번호
 
- 	Name				nvarchar(50)  NOT NULL ,		-- 작업유형 이름
 
- 	IsUse				bit  NULL ,						-- 사용 유무
 
- 	
 
- 	PRIMARY KEY (SiteId ASC , CauseClassId ASC)
 
- );
 
- -- work_code_emergency_WocoEmergency
 
- -- 긴급 정도 코드
 
- -- 작업 관리/기초 코드 관리/긴급 정도 코드
 
- --CREATE TABLE WocoEmergency
 
- CREATE TABLE FmsWorkCodeEmergency
 
- (
 
- 	SiteId				int  NOT NULL ,					-- 현장 고유번호
 
- 	EmergencyId         int  identity(1,1) NOT NULL ,	-- 긴급 작업 고유번호
 
- 	Name				nvarchar(50)  NULL ,			-- 긴급 작업 이름
 
- 	IsUse				bit  NULL ,						-- 사용 유무
 
- 	PRIMARY KEY (SiteId ASC , EmergencyId ASC)
 
- );
 
- -- work_code_kind_WocoKind
 
- -- 작업 구분 코드
 
- -- 작업 관리/기초 코드 관리/작업 구분 코드
 
- --CREATE TABLE WocoKind
 
- CREATE TABLE FmsWorkCodeType
 
- (
 
- 	WorkTypeId          int  NOT NULL ,					-- 작업구분코드 고유번호 (점검, 법정검사, 민원 등)
 
- 	Name				nvarchar(50)  NOT NULL ,		-- 작업구분코드 이름
 
- 	
 
- 	[Description]		nvarchar(512)  NULL ,			-- 설명
 
- 	
 
- 	PRIMARY KEY (WorkTypeId ASC)
 
- );
 
- INSERT INTO FmsWorkCodeType VALUES (1, '점검계획', '');
 
- INSERT INTO FmsWorkCodeType VALUES (2, '법정검사', '');
 
- INSERT INTO FmsWorkCodeType VALUES (3, '민원', '');
 
- -- work_code_progress_WocoProgress
 
- -- 진행 상태 코드
 
- -- 작업 관리/기초 코드 관리/진행 상태 코드
 
- --CREATE TABLE WocoProgress
 
- CREATE TABLE FmsWorkCodeProgress
 
- (
 
- 	WorkProgressId      int				NOT NULL ,		-- 진행상태 고유번호 (대기, 작업중, 승인 등)
 
- 	Name				nvarchar(24)	NOT NULL ,		-- 진행상태 이름
 
- 	[Description]		nvarchar(512)	NULL ,			-- 설명
 
- 	PRIMARY KEY (WorkProgressId ASC)
 
- );
 
- INSERT INTO FmsWorkCodeProgress VALUES (1, '작업계획', '');
 
- INSERT INTO FmsWorkCodeProgress VALUES (2, '작업보류', '');
 
- INSERT INTO FmsWorkCodeProgress VALUES (3, '작업대기', '');
 
- INSERT INTO FmsWorkCodeProgress VALUES (4, '작업진행중', '');
 
- INSERT INTO FmsWorkCodeProgress VALUES (5, '작업완료', '');
 
- INSERT INTO FmsWorkCodeProgress VALUES (6, '완료승인', '');
 
- ---------------------------------------------------
 
- -- 실행 계획 및 작업지시
 
- ---------------------------------------------------
 
- -- 실행 계획(=작업요청 =민원)
 
- -- CREATE TABLE WowoRequest
 
- CREATE TABLE FmsWorkRequest
 
- (
 
- 	SiteId				int				NOT NULL ,		-- 현장 고유번호
 
- 	WorkRequestId       int  identity(1,1) NOT NULL ,	-- 작업요청 고유번호
 
- 	WorkTypeId          int				NOT NULL ,		-- 작업요청유형 고유번호 (점검계획, 법정감사, 민원)
 
- 	BusinessFieldId     int				NOT NULL ,		-- 작업장소 고유번호
 
- 	WorkScheduleId      int				NULL ,			-- 기초계획 고유번호 (민원이면 NULL)
 
- 	WorkProgressId      int				NOT NULL ,		-- 진행상태 고유번호
 
- 	Title				nvarchar(200)	NOT NULL ,		-- 작업요청 제목
 
- 	Content				nvarchar(1024)  NULL ,			-- 작업요청자 상세내용
 
- 	RequestUserId		nvarchar(24)	NULL ,			-- 작업요청자 아이디 (데이터게이트웨이에서 올라오면 요청자가 없을 수 있다.)
 
- 	RequestDate			datetime		NOT NULL ,		-- 작업요청 날짜		
 
- 	StartWorkDate		datetime		NOT NULL ,		-- 작업시작일
 
- 	InspectionAgencyId	int				NULL ,			-- 법정검사기관 고유번호(법정검사인 경우만 사용)
 
- 	RejectUserId		nvarchar(24) NULL,				-- 반려한 사용자 ID 		
 
- 	RejectDate			datetime NULL,					-- 반려한 일시
 
- 	RejectReason		nvarchar(512)  NULL ,			-- 반려한 이유
 
- 	PRIMARY KEY (SiteId ASC , WorkRequestId ASC)
 
- );
 
- DBCC CHECKIDENT( FmsWorkRequest, RESEED, 1 )
 
- --CREATE TABLE WowoWorkTargetFacility
 
- CREATE TABLE FmsWorkRequestToFacility
 
- (
 
- 	SiteId				int  NOT NULL ,					-- 현장 고유번호
 
- 	WorkRequestId       int  NOT NULL ,					-- 작업요청 고유번호
 
- 	FacilityCode        int  NOT NULL ,					-- 설비코드
 
- 	
 
- 	PRIMARY KEY (SiteId ASC , WorkRequestId ASC , FacilityCode ASC)
 
- );
 
- -- 작업지시
 
- --CREATE TABLE WowoOrder
 
- CREATE TABLE FmsWorkOrder
 
- (
 
- 	SiteId				int  NOT NULL ,					-- 현장 고유번호
 
- 	WorkRequestId       int  NOT NULL ,					-- 작업요청 고유번호
 
- 	BusinessFieldId     int  NOT NULL ,					-- 작업영역 고유번호
 
- 	EmergencyId         int  NULL,						-- 긴급정보코드(자동지시인 경우 없을 수도 있다. 있다면 하드코딩으로 변경해야 함)
 
- 	OrderUserId         nvarchar(24)	NOT NULL ,		-- 작업지시한 사용자 고유번호
 
- 	OrderDate           datetime		NOT NULL ,		-- 작업지시한 날짜
 
- 	Title				nvarchar(200)	NOT NULL ,		-- 작업지시한 제목
 
- 	Content				nvarchar(2000)  NULL ,			-- 작업지시한 내용
 
- 	
 
- 	StartWorkDate		datetime		NOT NULL ,		-- 작업시작일
 
- 	PRIMARY KEY (SiteId ASC , WorkRequestId ASC)
 
- );
 
- DBCC CHECKIDENT( FmsWorkOrder, RESEED, 1 )
 
- --CREATE TABLE WowoWorkTargetFacility
 
- CREATE TABLE FmsWorkOrderToFacility
 
- (
 
- 	SiteId				int  NOT NULL ,					-- 현장 고유번호
 
- 	WorkRequestId         int  NOT NULL ,					-- 작업지시 고유번호
 
- 	FacilityCode        int  NOT NULL ,					-- 설비코드
 
- 	
 
- 	PRIMARY KEY (SiteId ASC , WorkRequestId ASC , FacilityCode ASC)
 
- );
 
- ---------------------------------------------------
 
- -- 작업결과등록
 
- ---------------------------------------------------
 
- --CREATE TABLE WowoResult
 
- CREATE TABLE FmsWorkResult
 
- (
 
- 	SiteId				int NOT NULL ,			-- 현장 고유번호
 
- 	WorkRequestId       int NOT NULL ,				-- 실행계획 고유번호
 
- 	WorkerUserId        nvarchar(24) NOT NULL ,	-- 작업자 고유번호
 
- 	StartDate           datetime NOT NULL ,		-- 작업 시작일
 
- 	EndDate             datetime NOT NULL ,		-- 작업 완료일
 
- 	CauseClassId		int NULL ,				-- 작업유형 고유번호
 
- 	Content				nvarchar(1024)  NULL ,	-- 작업 상세내용
 
- 	ConfirmedDate       datetime  NULL ,		-- 작업결과 승인날짜
 
- 	ConfirmedUserId     nvarchar(24)  NULL ,	-- 작업결과 승인 사용자 고유번호
 
- 	IsConfirmed			bit NOT NULL ,			-- 작업승인확인	
 
- 	PRIMARY KEY (SiteId ASC , WorkRequestId ASC)
 
- );
 
- -- 작업 결과 용 대상시설 관계 테이블
 
- --CREATE TABLE WowoWorkTargetFacility
 
- CREATE TABLE FmsWorkResultToFacility
 
- (
 
- 	SiteId				int  NOT NULL ,					-- 현장 고유번호
 
- 	WorkRequestId       int  NOT NULL ,					-- 작업결과의 작업지시 고유번호
 
- 	FacilityCode        int  NOT NULL ,					-- 설비코드
 
- 	
 
- 	PRIMARY KEY (SiteId ASC , WorkRequestId ASC , FacilityCode ASC)
 
- );
 
- -- 작업 결과 점검 항목
 
- --CREATE TABLE WowoResultCheckItem
 
- CREATE TABLE FmsWorkResultCheckItem
 
- (
 
- 	SiteId				int NOT NULL ,			-- 현장 고유번호
 
- 	WorkRequestId         int NOT NULL ,			-- 작업지시 고유번호
 
- 	FacilityCode        int NOT NULL ,			-- 설비코드
 
- 	CheckItemId         int NOT NULL ,			-- 작업항목 고유번호
 
- --	IsYesNoResult		bit NOT NULL ,			-- 예,아니오 결과
 
- 	BoolResult          bit NULL ,				-- 작업 결과 (조치여부)
 
- 	TextResult          nvarchar(1024)  NULL ,	-- 작업 결과 수기 항목
 
- --	CheckItemName       nvarchar(100)  NOT NULL ,	-- 작업 항목 이름
 
- --	SortOrderNo         int  NULL ,				-- 정렬 번호
 
- 	
 
- 	PRIMARY KEY (SiteId ASC , WorkRequestId ASC , FacilityCode ASC , CheckItemId ASC)
 
- );
 
- -- 작업결과 첨부파일
 
- --CREATE TABLE WowoResultFile
 
- CREATE TABLE FmsWorkResultFile
 
- (
 
- 	SiteId				int  NOT NULL ,		-- 현장 고유번호
 
- 	WorkRequestId         int  NOT NULL ,		-- 작업지시 고유번호
 
- 	FileId              int  NOT NULL ,		-- 파일 고유번호
 
- 	
 
- 	PRIMARY KEY (SiteId ASC , WorkRequestId ASC)
 
- );
 
- -- 작업결과 법정검사 정보
 
- --CREATE TABLE WowoResultLaw
 
- CREATE TABLE FmsWorkResultLaw
 
- (
 
- 	SiteId				int  NOT NULL ,			-- 현장 고유번호
 
- 	WorkRequestId         int  NOT NULL ,			-- 작업지시 고유번호
 
- 	CertificationNo     nvarchar(50)   NULL ,	-- 검사증 번호
 
- 	CheckCommission     numeric(10,0)  NULL ,	-- 검사 수수료
 
- 	CheckResult         bit  NULL ,				-- 검사 결과
 
- 	
 
- 	PRIMARY KEY (SiteId ASC , WorkRequestId ASC)
 
- );
 
- ---------------------------------------------------
 
- -- 작업지시
 
- ---------------------------------------------------
 
- ALTER TABLE FmsWorkCodeCauseClass
 
- 	ADD CONSTRAINT FK__FmsWorkCodeCauseClass__CmSite 
 
- 		FOREIGN KEY (SiteId) REFERENCES CmSite(SiteId)
 
- ;
 
- ALTER TABLE FmsWorkCodeEmergency
 
- 	ADD CONSTRAINT FK__FmsWorkCodeEmergency__CmSite 
 
- 		FOREIGN KEY (SiteId) REFERENCES CmSite(SiteId)
 
- ;
 
- -- 실행계획(작업요청) FK
 
- ALTER TABLE FmsWorkRequest
 
- 	ADD CONSTRAINT FK__FmsWorkRequest__CmSite 
 
- 		FOREIGN KEY (SiteId) REFERENCES CmSite(SiteId)
 
- ;
 
- ALTER TABLE FmsWorkRequest
 
- 	ADD CONSTRAINT FK__FmsWorkRequest__FmsWorkCodeWorkType
 
- 		FOREIGN KEY (WorkTypeId) REFERENCES FmsWorkCodeType(WorkTypeId)
 
- ;
 
- ALTER TABLE FmsWorkRequest
 
- 	ADD CONSTRAINT FK__FmsWorkRequest__FmsWorkSchedule
 
- 		FOREIGN KEY (SiteId, WorkScheduleId) REFERENCES FmsWorkSchedule(SiteId, WorkScheduleId)
 
- ;
 
- ALTER TABLE FmsWorkRequest
 
- 	ADD CONSTRAINT FK__FmsWorkRequest__FmsWorkCodeProgress
 
- 		FOREIGN KEY (WorkProgressId) REFERENCES FmsWorkCodeProgress(WorkProgressId)
 
- ;
 
- ALTER TABLE FmsWorkRequest
 
- 	ADD CONSTRAINT FK__FmsWorkRequest__CmBusinessField
 
- 		FOREIGN KEY (SiteId , BusinessFieldId) REFERENCES CmBusinessField(SiteId , BusinessFieldId)
 
- ;
 
- ALTER TABLE FmsWorkRequest
 
- 	ADD CONSTRAINT FK__FmsWorkRequest__CmUser_AsRequestUserId
 
- 		FOREIGN KEY (SiteId , RequestUserId) REFERENCES CmUser(SiteId , UserId)
 
- ;
 
- ALTER TABLE FmsWorkRequest
 
- 	ADD CONSTRAINT FK__FmsWorkRequest__CmUser1_AsRejectUserId
 
- 		FOREIGN KEY (SiteId , RejectUserId) REFERENCES CmUser(SiteId , UserId)
 
- ;
 
- ALTER TABLE FmsWorkRequest
 
- 	ADD CONSTRAINT FK__FmsWorkRequest__FmsWorkCodeLegalInspectionAgency
 
- 		FOREIGN KEY (SiteId , InspectionAgencyId) REFERENCES FmsWorkCodeLegalInspectionAgency(SiteId , InspectionAgencyId)
 
- ;
 
- ALTER TABLE FmsWorkRequestToFacility
 
- 	ADD CONSTRAINT FK__FmsWorkRequestToFacility__FmsWorkRequest 
 
- 		FOREIGN KEY (SiteId , WorkRequestId) REFERENCES FmsWorkRequest(SiteId , WorkRequestId) 
 
- 		ON DELETE CASCADE
 
- ;
 
- ALTER TABLE FmsWorkRequestToFacility
 
- 	ADD CONSTRAINT FK__FmsWorkRequestToFacility__CmFacility 
 
- 		FOREIGN KEY (SiteId , FacilityCode) REFERENCES CmFacility(SiteId , FacilityCode) 
 
- ;
 
- -- 작업 지시 FK
 
- ALTER TABLE FmsWorkOrder
 
- 	ADD CONSTRAINT FK__FmsWorkOrder__CmSite
 
- 		FOREIGN KEY (SiteId) REFERENCES CmSite(SiteId)
 
- ;
 
- ALTER TABLE FmsWorkOrder
 
- 	ADD CONSTRAINT FK__FmsWorkOrder__FmsWorkRequest
 
- 		FOREIGN KEY (SiteId , WorkRequestId) REFERENCES FmsWorkRequest(SiteId , WorkRequestId)
 
- ;
 
- ALTER TABLE FmsWorkOrder
 
- 	ADD CONSTRAINT FK__FmsWorkOrder__FmsWorkCodeEmergency
 
- 		FOREIGN KEY (SiteId , EmergencyId) REFERENCES FmsWorkCodeEmergency(SiteId , EmergencyId)
 
- ;
 
- ALTER TABLE FmsWorkOrder
 
- 	ADD CONSTRAINT FK__FmsWorkOrder__CmUser
 
- 		FOREIGN KEY (SiteId , OrderUserId) REFERENCES CmUser(SiteId , UserId)
 
- ;
 
- ALTER TABLE FmsWorkOrder
 
- 	ADD CONSTRAINT FK__FmsWorkOrder__CmBusinessField
 
- 		FOREIGN KEY (SiteId , BusinessFieldId) REFERENCES CmBusinessField(SiteId , BusinessFieldId)
 
- ;
 
- ALTER TABLE FmsWorkOrderToFacility
 
- 	ADD CONSTRAINT FK__FmsWorkOrderToFacility__FmsWorkOrder 
 
- 	FOREIGN KEY (SiteId , WorkRequestId) REFERENCES FmsWorkOrder(SiteId , WorkRequestId) 
 
- 	ON DELETE CASCADE
 
- ;
 
- ALTER TABLE FmsWorkOrderToFacility
 
- 	ADD CONSTRAINT FK__FmsWorkOrderToFacility__CmFacility 
 
- 		FOREIGN KEY (SiteId , FacilityCode) REFERENCES CmFacility(SiteId , FacilityCode) 
 
- ;
 
- ---------------------------------------------------
 
- -- 작업결과등록
 
- ---------------------------------------------------
 
- ALTER TABLE FmsWorkResult
 
- 	ADD CONSTRAINT FK__FmsWorkResult__FmsWorkOrder 
 
- 	FOREIGN KEY (SiteId , WorkRequestId) REFERENCES FmsWorkOrder(SiteId , WorkRequestId)
 
- ;
 
- ALTER TABLE FmsWorkResult
 
- 	ADD CONSTRAINT FK__FmsWorkResult__FmsWorkCodeCauseClass 
 
- 	FOREIGN KEY (SiteId , CauseClassId) REFERENCES FmsWorkCodeCauseClass(SiteId , CauseClassId)
 
- ;
 
- ALTER TABLE FmsWorkResult
 
- 	ADD CONSTRAINT FK__FmsWorkResult__CmUser_AsWorkerUserId 
 
- 	FOREIGN KEY (SiteId , WorkerUserId) REFERENCES CmUser(SiteId , UserId)
 
- ;
 
- ALTER TABLE FmsWorkResult
 
- 	ADD CONSTRAINT FK__FmsWorkResult__CmUser_AsConfirmedUserId  
 
- 	FOREIGN KEY (SiteId , ConfirmedUserId) REFERENCES CmUser(SiteId , UserId)
 
- ;
 
- ALTER TABLE FmsWorkResultCheckItem
 
- 	ADD CONSTRAINT FK__FmsWorkResultCheckItem__FmsWorkResult 
 
- 	FOREIGN KEY (SiteId , WorkRequestId) REFERENCES FmsWorkResult(SiteId , WorkRequestId)
 
- ;
 
- ALTER TABLE FmsWorkResultCheckItem
 
- 	ADD CONSTRAINT FK__FmsWorkResultCheckItem__FmsFacilityCheckItem
 
- 	FOREIGN KEY (SiteId , FacilityCode, CheckItemId) REFERENCES FmsFacilityCheckItem(SiteId, FacilityCode, CheckItemId)
 
- ;
 
- ALTER TABLE FmsWorkResultCheckItem
 
- 	ADD CONSTRAINT FK__FmsWorkResultCheckItem__CmFacility
 
- 	FOREIGN KEY (SiteId , FacilityCode) REFERENCES CmFacility(SiteId, FacilityCode)
 
- ;
 
- ALTER TABLE FmsWorkResultToFacility
 
- 	ADD CONSTRAINT FK__FmsWorkResultToFacility__FmsWorkOrder 
 
- 	FOREIGN KEY (SiteId , WorkRequestId) REFERENCES FmsWorkResult(SiteId , WorkRequestId) 
 
- 	ON DELETE CASCADE
 
- ;
 
- ALTER TABLE FmsWorkResultToFacility
 
- 	ADD CONSTRAINT FK__FmsWorkResultToFacility__CmFacility 
 
- 		FOREIGN KEY (SiteId , FacilityCode) REFERENCES CmFacility(SiteId , FacilityCode) 
 
- ;
 
- ALTER TABLE FmsWorkResultFile
 
- 	ADD CONSTRAINT FK__FmsWorkResultFile__FmsWorkResult 
 
- 	FOREIGN KEY (SiteId , WorkRequestId) REFERENCES FmsWorkResult(SiteId , WorkRequestId)
 
- ;
 
- ALTER TABLE FmsWorkResultFile
 
- 	ADD CONSTRAINT FK__FmsWorkResultFile__CmFile 
 
- 	FOREIGN KEY (SiteId , FileId) REFERENCES CmFile(SiteId , FileId)
 
- ;
 
- ALTER TABLE FmsWorkResultLaw
 
- 	ADD CONSTRAINT FK__FmsWorkResultLaw__FmsWorkResult 
 
- 	FOREIGN KEY (SiteId , WorkRequestId) REFERENCES FmsWorkResult(SiteId , WorkRequestId)
 
- ;
 
- ALTER TABLE FmsWorkSchedule
 
- 	ADD CONSTRAINT FK__FmsWorkSchedule__FmsWorkCodeType 
 
- 	FOREIGN KEY (WorkTypeId) REFERENCES FmsWorkCodeType(WorkTypeId)
 
- ;
 
- ALTER TABLE FmsFacilityCheckItem
 
- 	ADD CONSTRAINT FK__FmsFacilityCheckItem__FmsWorkCodeType 
 
- 	FOREIGN KEY (WorkTypeId) REFERENCES FmsWorkCodeType(WorkTypeId)
 
- ;
 
- ---- work_because_first_WobeFirst
 
- ---- 작업 관리/원인 분류/대분류
 
- ----CREATE TABLE WobeFirst
 
- --CREATE TABLE FmsWorkCodeCauseClassFirst
 
- --(
 
- --	FirstId				int  NOT NULL ,
 
- --	FirstName           nvarchar(50)  NOT NULL ,
 
- --	SortOrderNo            int  NULL ,
 
- --	IsUse            bit  NULL ,
 
- --	InsertedDate        datetime  NULL ,
 
- --	InsertedUserId      nvarchar(24)  NULL ,
 
- --	UpdatedDate         datetime  NULL ,
 
- --	UpdatedUserId       nvarchar(24)  NULL ,
 
- 	
 
- --	PRIMARY KEY (FirstId ASC)
 
- --);
 
- ----CREATE TABLE WobeSecond
 
- --CREATE TABLE FmsWorkCodeCauseClassSecond
 
- --(
 
- --	FirstId             int  NOT NULL ,
 
- --	SecondId            int  NOT NULL ,
 
- --	SecondName          nvarchar(50)  NOT NULL ,
 
- 	
 
- --	SortOrderNo            int  NULL ,
 
- --	IsUse            bit  NULL ,
 
- --	InsertedDate        datetime  NULL ,
 
- --	InsertedUserId      nvarchar(24)  NULL ,
 
- --	UpdatedDate         datetime  NULL ,
 
- --	UpdatedUserId       nvarchar(24)  NULL ,
 
- 	
 
- --	PRIMARY KEY (SecondId ASC)
 
- --);
 
- -- work_work_orderMaterial_WowoOrderMaterial
 
- -- 지시 자재 리스트
 
- -- work/work/orderMaterial
 
- --CREATE TABLE WowoOrderMaterial
 
- --CREATE TABLE FmsWowoOrderMaterial
 
- --(
 
- --	WorkOrderId             numeric(8,0)  NOT NULL ,
 
- --	MaterialId          nvarchar(30)  NOT NULL ,
 
- --	OrderCount             int  NOT NULL ,
 
- --	DeliveryCount          int  NULL ,
 
- --	ReturnCount            int  NULL ,
 
- --	UseCount               int  NULL ,
 
- --	IsDelivery           bit  NOT NULL ,
 
- --	InoutDate            datetime  NULL ,
 
- 	
 
- --	PRIMARY KEY (WorkOrderId ASC,MaterialId ASC)
 
- --);
 
- ---------------------------------------------------
 
- -- 작업결과등록
 
- ---------------------------------------------------
 
- --CREATE TABLE WowoMaterial
 
- --(
 
- --	WorkOrderId             numeric(8,0)  NOT NULL ,
 
- --	ResultId            int  NOT NULL ,
 
- --	MaterialId          nvarchar(30)  NOT NULL ,
 
- --	DeliveryNo           nvarchar(30)  NOT NULL ,
 
- --	OrderCount             int  NOT NULL ,
 
- --	OrderNote         nvarchar(2000)  NULL ,
 
- --	DeliveryId          int  NOT NULL ,
 
- 	
 
- --	PRIMARY KEY (WorkOrderId ASC,ResultId ASC,MaterialId ASC,DeliveryNo ASC)
 
- --)
 
- --;
 
- ---------------------------------------------------
 
- -- 기초코드관리
 
- ---------------------------------------------------
 
- --ALTER TABLE WobeSecond
 
- --	ADD  FOREIGN KEY (firstSeq) REFERENCES WobeFirst(firstSeq)
 
- --;
 
- ---------------------------------------------------
 
- -- 작업지시
 
- ---------------------------------------------------
 
- --ALTER TABLE FmsWorkOrderMaterial
 
- --	ADD  FOREIGN KEY (WorkOrderId) REFERENCES FmsWorkOrder(WorkOrderId)
 
- --;
 
- --ALTER TABLE FmsWorkOrderMaterial
 
- --	ADD  FOREIGN KEY (materialSeq) REFERENCES MamaMaterial(materialSeq)
 
- --;
 
- -- SuteTeam : 근무편성관리
 
- --ALTER TABLE FmsWorkOrder
 
- --	ADD  FOREIGN KEY (CompanyId,TeamId) REFERENCES SuteTeam(CompanyId,TeamId)
 
- --;
 
- --ALTER TABLE FmsWorkOrderMaterial
 
- --	ADD  FOREIGN KEY (warehouseSeq) REFERENCES MaplWarehouse(warehouseSeq)
 
- --;
 
- --ALTER TABLE FmsWorkRequest
 
- --	ADD  FOREIGN KEY (alarmDatetime,systemSeq,pointId) REFERENCES BaalAlarm(alarmDatetime,systemSeq,pointId)
 
- --;
 
- --ALTER TABLE FmsWorkRequestSmsTeam
 
- --	ADD  FOREIGN KEY (CompanyId,TeamId) REFERENCES SuteTeam(CompanyId,TeamId)
 
- --;
 
- ---------------------------------------------------
 
- -- 작업결과등록
 
- ---------------------------------------------------
 
- --ALTER TABLE WowoMaterial
 
- --	ADD  FOREIGN KEY (WorkOrderId,ResultId) REFERENCES FmsWorkResult(WorkOrderId,ResultId)
 
- --;
 
- --ALTER TABLE WowoMaterial
 
- --	ADD  FOREIGN KEY (materialSeq) REFERENCES MamaMaterial(materialSeq)
 
- --;
 
- --ALTER TABLE WowoMaterial
 
- --	ADD  FOREIGN KEY (warehouseSeq) REFERENCES MaplWarehouse(warehouseSeq)
 
- --;
 
- --ALTER TABLE WowoMaterial
 
- --	ADD  FOREIGN KEY (enterNo,deliveryNo) REFERENCES MamsLink(enterNo,deliveryNo)
 
- --;
 
- --ALTER TABLE WowoMaterial
 
- --	ADD  FOREIGN KEY (deliverySeq) REFERENCES MacoDelivery(deliverySeq)
 
- --;
 
- --ALTER TABLE FmsWorkRequest
 
- --	ADD CONSTRAINT FK__FmsWorkRequest__BemsMonitoringPoint
 
- --		FOREIGN KEY (SiteId , AlarmFacilityCode , AlarmPropertyId) 
 
- --		REFERENCES BemsMonitoringPoint(SiteId , FacilityCode , PropertyId)
 
- --;
 
- -- WocoAccept는 연동된 테이블을 찾지 못했고, 일지 작성주기 코드는 인수인계관리에서 사용하기 때문에 일단 사용하지 않는다.
 
- ---- work_code_acpt_WocoAcpt
 
- ---- 작업 관리/기초 코드 관리/작업 구분 코드
 
- ----CREATE TABLE WocoAccept
 
- --CREATE TABLE FmsWorkCodeAccept
 
- --(
 
- --	AcceptId			int  NOT NULL ,
 
- --	Name				nvarchar(50)  NOT NULL ,
 
- --	IsUse				bit  NULL ,
 
- --	SortOrderNo         int  NULL ,
 
- --	InsertedDate        datetime  NULL ,
 
- --	InsertedUserId      nvarchar(24)  NULL ,
 
- --	UpdatedDate         datetime  NULL ,
 
- --	UpdatedUserId       nvarchar(24)  NULL ,
 
- 	
 
- --	PRIMARY KEY (AcceptId ASC)
 
- --);
 
- ---- 	일지작성주기코드
 
- ----	작업 관리/기초 코드 관리/일지작성주기코드
 
- ----CREATE TABLE WocoCycle
 
- --CREATE TABLE FmsWorkCodeCycle
 
- --(
 
- --	CycleId             int  NOT NULL ,
 
- --	Name				nvarchar(50)  NOT NULL ,
 
- 	
 
- --	IsUse				bit  NULL ,
 
- --	SortOrderNo         int  NULL ,
 
- --	InsertedDate        datetime  NULL ,
 
- --	InsertedUserId      nvarchar(24)  NULL ,
 
- --	UpdatedDate         datetime  NULL ,
 
- --	UpdatedUserId       nvarchar(24)  NULL ,
 
- 	
 
- --	PRIMARY KEY (CycleId ASC)
 
- --);
 
 
  |