CREATE TABLE smaster (
    orderid bigint DEFAULT next_id() NOT NULL,
    custname character varying(200) NOT NULL
);

ALTER TABLE ONLY smaster
    ADD CONSTRAINT smaster_pkey PRIMARY KEY (orderid);

CREATE TABLE sdetail (
    orderdetailid bigint DEFAULT next_id() NOT NULL,
    orderid bigint NOT NULL,
    item character varying(200) NOT NULL,
    qty integer NOT NULL,
    rate double precision NOT NULL
);

ALTER TABLE ONLY sdetail
    ADD CONSTRAINT sdetail_pkey PRIMARY KEY (orderdetailid);
    
ALTER TABLE ONLY sdetail
    ADD CONSTRAINT sfk_orderid FOREIGN KEY (orderid) REFERENCES smaster(orderid);