10 lines
385 B
SQL
10 lines
385 B
SQL
USE AdventureWorks
|
|
CREATE TABLE HumanResources.JobCandidateHistory
|
|
(
|
|
JobCandidateID int NOT NULL UNIQUE,
|
|
Resume xml NULL,
|
|
Rating int NOT NULL CONSTRAINT CK_JobCandidateHistory_Rating CHECK(Rating BETWEEN 1 AND 10) CONSTRAINT DF_JobCandidateHistory_Rating DEFAULT 5,
|
|
RejectDate datetime NOT NULL,
|
|
ContactID int NULL,
|
|
FOREIGN KEY (ContactID) REFERENCES Person.Contact(ContactID)
|
|
); |