 
 
 --
--- Name: equipment_inventories; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
+-- Name: equipment_inventories; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
 --
 
 CREATE TABLE equipment_inventories (
-  id integer NOT NULL,
-  facilityid integer NOT NULL,
-  programid integer NOT NULL,
-  equipmentid integer NOT NULL,
-  serialnumber character varying(200),
-  yearofinstallation integer DEFAULT 1900,
-  purchaseprice numeric(18,3) DEFAULT 0,
-  sourceoffund character varying(200),
-  replacementrecommended boolean DEFAULT false,
-  reasonforreplacement character varying(2000),
-  nameofassessor character varying(200),
-  datelastassessed date DEFAULT now(),
-  createdby integer,
-  createddate timestamp without time zone DEFAULT now(),
-  modifiedby integer,
-  modifieddate timestamp without time zone DEFAULT now(),
-  isactive boolean DEFAULT true NOT NULL,
-  datedecommissioned date,
-  primarydonorid integer,
-  hasstabilizer boolean
+    id integer NOT NULL,
+    facilityid integer NOT NULL,
+    programid integer NOT NULL,
+    equipmentid integer NOT NULL,
+    serialnumber character varying(200),
+    yearofinstallation integer DEFAULT 1900,
+    purchaseprice numeric(18,3) DEFAULT 0,
+    sourceoffund character varying(200),
+    replacementrecommended boolean DEFAULT false,
+    reasonforreplacement character varying(2000),
+    nameofassessor character varying(200),
+    datelastassessed date DEFAULT now(),
+    createdby integer,
+    createddate timestamp without time zone DEFAULT now(),
+    modifiedby integer,
+    modifieddate timestamp without time zone DEFAULT now(),
+    isactive boolean DEFAULT true NOT NULL,
+    datedecommissioned date,
+    primarydonorid integer,
+    hasstabilizer boolean
 );
 
 
 ALTER TABLE equipment_inventories OWNER TO postgres;
 
 --
--- Name: equipment_inventory_statuses; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
+-- Name: equipment_inventory_statuses; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
 --
 
 CREATE TABLE equipment_inventory_statuses (
-  id integer NOT NULL,
-  inventoryid integer NOT NULL,
-  statusid integer NOT NULL,
-  notfunctionalstatusid integer,
-  createddate timestamp with time zone DEFAULT now(),
-  createdby integer,
-  modifiedby integer,
-  modifieddate timestamp with time zone DEFAULT now()
+    id integer NOT NULL,
+    inventoryid integer NOT NULL,
+    statusid integer NOT NULL,
+    notfunctionalstatusid integer,
+    createddate timestamp with time zone DEFAULT now(),
+    createdby integer,
+    modifiedby integer,
+    modifieddate timestamp with time zone DEFAULT now()
 );
 
 

--

CREATE SEQUENCE email_notifications_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;


ALTER TABLE email_notifications_id_seq OWNER TO postgres;



--
-- Name: requisition_group_members; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE requisition_group_members (
    id integer NOT NULL,
    requisitiongroupid integer NOT NULL,
    facilityid integer NOT NULL,
    createdby integer,
    createddate timestamp without time zone DEFAULT now(),
    modifiedby integer,
    modifieddate timestamp without time zone DEFAULT now()
);


