123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137 |
- CREATE TABLE FmsDrawingCodeGroup
- (
- SiteId int NOT NULL ,
- DrawingGroupId int identity(1,1) NOT NULL ,
- Name nvarchar(50) NOT NULL ,
- IsUse bit NULL ,
- PRIMARY KEY (SiteId ASC , DrawingGroupId ASC)
- );
- DBCC CHECKIDENT( FmsDrawingCodeGroup, RESEED, 1 )
- CREATE TABLE FmsDrawingCodeType
- (
- SiteId int NOT NULL ,
- DrawingTypeId int identity(1,1) NOT NULL ,
- Name nvarchar(50) NOT NULL ,
- IsUse bit NULL ,
-
- PRIMARY KEY (SiteId ASC , DrawingTypeId ASC)
- );
- DBCC CHECKIDENT( FmsDrawingCodeType, RESEED, 1 )
- CREATE TABLE FmsDrawing
- (
- SiteId int NOT NULL ,
- DrawingId int identity(1,1) NOT NULL ,
- DrawingNo nvarchar(20) NOT NULL ,
- DrawingGroupId int NOT NULL ,
- DrawingTypeId int NOT NULL ,
- Name nvarchar(255) NOT NULL ,
- [Description] nvarchar(2000) NULL ,
-
- PRIMARY KEY (SiteId ASC , DrawingId ASC)
- );
- DBCC CHECKIDENT( FmsDrawing, RESEED, 1 )
- CREATE TABLE FmsDrawingHistory
- (
- SiteId int NOT NULL ,
- DrawingId int NOT NULL ,
- HistoryId int identity(1,1) NOT NULL ,
- RevisionNo int NOT NULL ,
- FileId int NOT NULL ,
- [Description] nvarchar(2000) NULL ,
- UpdatedDate datetime NULL ,
- UpdatedUserId nvarchar(24) NULL ,
- PRIMARY KEY (SiteId ASC , DrawingId ASC , HistoryId ASC)
- );
- DBCC CHECKIDENT( FmsDrawingHistory, RESEED, 1 )
-
- ALTER TABLE FmsDrawingCodeGroup
- ADD CONSTRAINT FK__FmsDrawingCodeGroup__CmSite
- FOREIGN KEY (SiteId) REFERENCES CmSite(SiteId)
- ;
- ALTER TABLE FmsDrawingCodeType
- ADD CONSTRAINT FK__FmsDrawingCodeType__CmSite
- FOREIGN KEY (SiteId) REFERENCES CmSite(SiteId)
- ;
- ALTER TABLE FmsDrawing
- ADD CONSTRAINT FK__FmsDrawing__CmSite
- FOREIGN KEY (SiteId) REFERENCES CmSite(SiteId)
- ;
- ALTER TABLE FmsDrawing
- ADD CONSTRAINT FK__FmsDrawing__FmsDrawingCodeGroup
- FOREIGN KEY (SiteId , DrawingGroupId) REFERENCES FmsDrawingCodeGroup(SiteId , DrawingGroupId)
- ;
- ALTER TABLE FmsDrawing
- ADD CONSTRAINT FK__FmsDrawing__FmsDrawingCodeType
- FOREIGN KEY (SiteId , DrawingTypeId) REFERENCES FmsDrawingCodeType(SiteId , DrawingTypeId)
- ;
- ALTER TABLE FmsDrawingHistory
- ADD CONSTRAINT FK__FmsDrawingHistory__FmsDrawing
- FOREIGN KEY (SiteId , DrawingId) REFERENCES FmsDrawing(SiteId , DrawingId)
- ;
- ALTER TABLE FmsDrawingHistory
- ADD CONSTRAINT FK__FmsDrawingHistory__FmsFile
- FOREIGN KEY (SiteId , FileId) REFERENCES CmFile(SiteId , FileId)
- ;
- ALTER TABLE FmsDrawingHistory
- ADD CONSTRAINT FK__FmsDrawingHistory__CmUser
- FOREIGN KEY (SiteId , UpdatedUserId) REFERENCES CmUser(SiteId , UserId)
- ;
|