"deliverydate" date,
"serialnumber" text,
"itime" timestamp DEFAULT now(),
- "mtime" timestamp
+ "mtime" timestamp,
+ "pricegroup_id" integer
);
CREATE TABLE "vendor" (
"username" varchar(50),
"user_password" varchar(12),
"salesman_id" integer,
- "c_vendor_id" text
+ "c_vendor_id" text,
+ "klass" integer DEFAULT 0
);
"serialnumber" text,
"id" integer DEFAULT nextval('orderitemsid'::text) PRIMARY KEY,
"itime" timestamp DEFAULT now(),
- "mtime" timestamp
+ "mtime" timestamp,
+ "pricegroup_id" integer
);
CREATE TABLE "exchangerate" (
license_id integer
);
+-- Preisgruppenverwaltung
+CREATE TABLE "pricegroup" (
+ "id" integer DEFAULT nextval('id'::text),
+ "pricegroup" text not null,
+ PRIMARY KEY (id)
+);
+--Preisverwaltung der Preisgruppen
+CREATE TABLE "prices" (
+ "parts_id" integer REFERENCES parts(id),
+ "pricegroup_id" integer REFERENCES pricegroup(id),
+ "price" numeric(15,5)
+);
+
+
+
+
-- Table of tax authoritys
-- for module ustva
-- Lx office