schema

text/plain

Download

CREATE TABLE "schaertabelle" (
	"entryid" integer DEFAULT nextval('schaertabelle_entryid_seq'::text) NOT NULL,
	"maschine" smallint NOT NULL,
	"schaerdatum" date NOT NULL,
	"gaenge" smallint NOT NULL,
	"menge" integer NOT NULL,
	"status" smallint NOT NULL,
	"jahrgang" numeric(4,0) NOT NULL,
	"artikelid" integer NOT NULL,
	Constraint "schaertabelle_pkey" Primary Key ("entryid")
);

CREATE  INDEX "schaertabelle_kettnr" on "schaertabelle" using btree ( "maschine" "int2_ops", "schaerdatum" "date_ops" );
CREATE  INDEX "schaertabelle_speed" on "schaertabelle" using btree ( "artikelid" "int4_ops", "jahrgang" "numeric_ops" );

CREATE TABLE "extartbez" (
	"kundennr" numeric(5,0),
	"artikelid" integer NOT NULL,
	"text" character varying(50) NOT NULL,
	"stand" timestamp with time zone DEFAULT now(),
	"bezkomptype" numeric(2,0),
	"extartbezid" numeric(5,0)
);

CREATE UNIQUE INDEX "extartbez_uniq" on "extartbez" using btree ( "kundennr" "numeric_ops", "extartbezid" "numeric_ops", "artikelid" "int4_ops", "bezkomptype" "numeric_ops" );
CREATE  INDEX "extartbez_artikelid" on "extartbez" using btree ( "artikelid" "int4_ops" );
CREATE  INDEX "extartbez_speed" on "extartbez" using btree ( "extartbezid" "numeric_ops", "bezkomptype" "numeric_ops", "text" "varchar_ops" );