我对在插入后创建触发器有很多疑问,在进入新航班后检查它是否是指定飞机的第一次飞行。
在这种情况下,更新 Aircraft.description 字段,使用短语“Inaugural flight on [date of enter flight]”。
有问题的表是这样的:
CREATE TABLE Flight(
flightNumber nchar(6) NOT NULL,
airlineICAOId nchar(3) NOT NULL,
departureDate date NOT NULL,
departureTime time(0) NOT NULL,
fromAirport nchar(4) NOT NULL,
toAirport nchar(4) NOT NULL,
[type] nchar(2) NOT NULL,
registrationNumber nchar(10) NULL,
id nchar(3) NOT NULL,
CONSTRAINT PK_Flight_flightNumber_ICAOId_departureDate_departureTime PRIMARY KEY (flightNumber, airlineICAOId, departureDate, departureTime),
CONSTRAINT FK_Flight_AirlineRoute_flightNumber_ICAOId FOREIGN KEY (flightNumber, airlineICAOId) REFERENCES AirlineRoute,
CONSTRAINT FK_Flight_Airport_fromAirport FOREIGN KEY (fromAirport) REFERENCES Airport (ICAOId),
CONSTRAINT FK_Flight_Airport_toAirport FOREIGN KEY (toAirport) REFERENCES Airport (ICAOId),
CONSTRAINT FK_Flight_Aircraft_registrationNumber FOREIGN KEY (registrationNumber) REFERENCES Aircraft,
CONSTRAINT FK_Flight_CrewGroup_id FOREIGN KEY (id) REFERENCES CrewGroup,
CONSTRAINT FK_Flight_Airline_ICAOId FOREIGN KEY (airlineICAOId) REFERENCES Airline(ICAOId),
CONSTRAINT FK_Flight_FlightType_type FOREIGN KEY ([type]) REFERENCES FlightType ([type])
)