CREATE TABLE business_entity_configuration ( id serial NOT NULL, business_entity_id integer, global_expiry integer, approval_required boolean, purchase_order_required boolean, CONSTRAINT business_entity_configuration_pk PRIMARY KEY (id), CONSTRAINT business_entity_configuration_to_be_fk FOREIGN KEY (business_entity_id) REFERENCES business_entity (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION ) WITH ( OIDS=FALSE ); ALTER TABLE business_entity_configuration OWNER TO postgres;