DEFAULT on column pubdate|(getdate())
DEFAULT on column type|('UNDECIDED')
FOREIGN KEY|pub_id
|REFERENCES pubs.dbo.publishers (pub_id)
PRIMARY KEY (clustered)|title_id