1 -- Sequence: cobapply_id_seq
3 -- DROP SEQUENCE cobapply_id_seq;
5 CREATE SEQUENCE cobapply_id_seq
11 ALTER TABLE cobapply_id_seq
13 GRANT ALL ON TABLE cobapply_id_seq TO admin;
14 GRANT ALL ON TABLE cobapply_id_seq TO xtrole;
17 -- cob apply - planned credit memo applications for a bill ;
22 cobapply_id integer NOT NULL DEFAULT nextval(('cobapply_id_seq'::text)::regclass),
23 cobapply_cobmisc_id integer,
24 cobapply_aropen_id integer,
25 cobapply_applied boolean,
27 CONSTRAINT cobapply_pkey PRIMARY KEY (cobapply_id ),
28 CONSTRAINT cobapply_cobmisc_id_fkey FOREIGN KEY (cobapply_cobmisc_id)
29 REFERENCES cobmisc (cobmisc_id)
30 ON UPDATE CASCADE ON DELETE NO ACTION,
31 CONSTRAINT cobapply_aropen_id_fkey FOREIGN KEY (cobapply_aropen_id)
32 REFERENCES aropen (aropen_id)
33 ON UPDATE CASCADE ON DELETE NO ACTION
39 CREATE INDEX cobapply_cobmisc_id_ix ON cobapply USING btree (cobapply_cobmisc_id);
40 CREATE INDEX cobapply_aropen_id_ix ON cobapply USING btree (cobapply_aropen_id);
41 CREATE INDEX cobapply_applied_ix ON cobapply USING btree (cobapply_applied);
45 GRANT ALL ON TABLE cobapply TO admin;
46 GRANT ALL ON TABLE cobapply TO xtrole;
47 COMMENT ON TABLE cobapply
48 IS 'Planned credit memo applies to bills';