> Hola amigos...
>
> tengo este codigo sql
> CREATE TABLE public.fruits_in_stock(
> NAME INTEGER PRIMARY KEY,
> in_stock INTEGER NOT NULL,
> reserved INTEGER NOT NULL DEFAULT 0,
> CHECK(in_stock BETWEEN 0 AND 1000),
> CHECK(reserved <= in_stock)
> );
>
> CREATE TABLE public.fruits_offer(
>
Hola amigos...
tengo este codigo sql
CREATE TABLE public.fruits_in_stock(
NAME INTEGER PRIMARY KEY,
in_stock INTEGER NOT NULL,
reserved INTEGER NOT NULL DEFAULT 0,
CHECK(in_stock BETWEEN 0 AND 1000),
CHECK(reserved <= in_stock)
);
CREATE TABLE public.fruits_offer(
offer_id SERIAL PRIMARY K