-
-ALTER TABLE [SubPop] ADD
- CONSTRAINT [DF__SubPopB10__last___19AB9A98] DEFAULT (getdate()) FOR [last_updated_time],
- PRIMARY KEY CLUSTERED
- (
- [batch_id],
- [subsnp_id],
- [pop_id],
- [type]
- ),
- CONSTRAINT [fk_SubPop_batch_id] FOREIGN KEY
- (
- [batch_id]
- ) REFERENCES [Batch] (
- [batch_id]
- ),
- CONSTRAINT [fk_SubPop_pop] FOREIGN KEY
- (
- [pop_id]
- ) REFERENCES [Population] (
- [pop_id]
- ),
- CHECK ([type] = 'GTY' or ([type] = 'HET' or [type] = 'ALE'))