12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152 |
- CREATE TABLE CmHoliday
- (
- SiteId int NOT NULL ,
- HolidayMonth smallint NOT NULL ,
- HolidayDay smallint NOT NULL ,
- IsLunar bit NOT NULL ,
- Name nvarchar(16) NOT NULL ,
- IsUse bit NULL ,
-
- PRIMARY KEY (SiteId ASC , HolidayMonth ASC , HolidayDay ASC , IsLunar ASC)
- );
- CREATE TABLE CmHolidayCustom
- (
- SiteId int NOT NULL ,
- HolidayDate datetime NOT NULL ,
- Name nvarchar(16) NOT NULL ,
- IsUse bit NULL ,
-
- PRIMARY KEY (SiteId ASC , HolidayDate ASC)
- );
- CREATE TABLE CmHolidayWeekend
- (
- SiteId int NOT NULL ,
- Saturday bit NOT NULL ,
- Sunday bit NOT NULL ,
- IsUse bit NULL ,
-
- PRIMARY KEY (SiteId ASC)
- );
- ALTER TABLE CmHoliday
- ADD CONSTRAINT FK__CmHoliday__CmSite
- FOREIGN KEY (SiteId) REFERENCES CmSite(SiteId)
- ;
- ALTER TABLE CmHolidayCustom
- ADD CONSTRAINT FK__CmHolidayCustom__CmSite
- FOREIGN KEY (SiteId) REFERENCES CmSite(SiteId)
- ;
- ALTER TABLE CmHolidayWeekend
- ADD CONSTRAINT FK__CmHolidayWeekend__CmSite
- FOREIGN KEY (SiteId) REFERENCES CmSite(SiteId)
- ;
|