We have a number of constraints on our table and we really should understand what they do at a deeper level. In this video we'll dive into the constraint code below.
create table inms( id bigserial primary key, created_at timestamp not null, altitude numeric(9,2) not null check(altitude > 0), source text not null check(source in('osi','csn','osnb','osnt')) mass numeric(6,3) not null check(mass >=0.125 and mass < 100), high_sensitivity_count int not null check(high_sensitivity_count > 0), low_sensitivity_count int not null check(low_sensitivity_count > 0));