Is it important the above NOTICE message?
What does it mean?
 
-- 
Evelio Martínez
Testanet. Dept. desarrollo software.
Av. Reino de Valencia, 15 - 5
46005 Valencia (Spain)
Tel: +34 96 395 90 00
Fax: +34 96 316 23 19
 

DROP TABLE fam;
DROP TABLE subfam;
DROP TABLE pro;
DROP SEQUENCE fam_idfam_seq;
DROP SEQUENCE subfam_idsubfam_seq;
DROP SEQUENCE pro_idpro_seq;


CREATE TABLE fam (
  idfam         serial,
  nombre        varchar(60) not null,
  descrip       text,
  PRIMARY KEY (idfam)
);

CREATE TABLE subfam (
  idsubfam      serial,
  idfam         int4        CONSTRAINT subfam_idfam REFERENCES fam(idfam),
  nombre        varchar(60) NOT NULL,
  descrip       text,
  PRIMARY KEY (idsubfam, idfam)
);


CREATE TABLE pro (
  idpro                 serial, 
  nombre                varchar(60)     NOT NULL,
  idfam                 int4            CONSTRAINT pro_idfam    REFERENCES fam(idfam),
  idsubfam              int4            CONSTRAINT pro_idsubfam REFERENCES 
subfam(idsubfam),
  descrip               text,
  fecha                 date            NOT NULL,
  ubica                 varchar(30),
  estado                char(1)         DEFAULT 'R',  -- Realizado / en Desarrollo
  autor                 varchar(10)     DEFAULT getpgusername(),
  hora                  timestamp       DEFAULT now(),
  claves                varchar(128),  
  PRIMARY KEY (idpro)
);

Reply via email to