CREATE TABLE "tblstsc1" (
	"surid" character varying(50) NOT NULL,
	"sc1strictnessid" int4 NOT NULL,
	"sc1caption" text,
	"defaultoptionid" int4 NOT NULL,
	CONSTRAINT "tblstsc1_sc1caption" CHECK ((sc1caption <> ''::text)),
	PRIMARY KEY ("surid")
);
CREATE TRIGGER "tblstsc1_before" BEFORE INSERT OR DELETE OR UPDATE ON "tblstsc1"  FOR EACH ROW EXECUTE PROCEDURE "tblstsc1_before" ();
CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "tblstsc1"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'tblstsc1', 'tblidstrictness', 'UNSPECIFIED', 'sc1strictnessid', 'strictnessid');

CREATE TABLE "tblstsc1options" (
	"sc1optionid" int4 NOT NULL,
	"sc1optionname" character varying(50) NOT NULL,
	"sc1optionvalue" float4,
	"surid" character varying(50) NOT NULL,
	CONSTRAINT "tblstsc1options_sc1optionvalue" CHECK ((sc1optionvalue > 0)),
	CONSTRAINT "tblstsc1options_sc1optionname" CHECK ((sc1optionname <> ''::"varchar")),
	PRIMARY KEY ("sc1optionid")
);
CREATE  INDEX "ix_stsc1options_surid" on "tblstsc1options" using btree ( "surid" "varchar_ops" );
CREATE TRIGGER "tblstsc1options_before" BEFORE INSERT OR DELETE OR UPDATE ON "tblstsc1options"  FOR EACH ROW EXECUTE PROCEDURE "tblstsc1options_before" ();