-- CREATE TTIPOSREPORTEID, TTIPOSREPORTE, TREPREPORTES
DROP TABLE TTIPOSREPORTE;
DROP TABLE TTIPOSREPORTEID;

CREATE TABLE TTIPOSREPORTEID ( 
	CTIPOREPORTE VARCHAR(20) DEFAULT NULL , 
	CONSTRAINT IPK_TTIPO PRIMARY KEY( CTIPOREPORTE ));

CREATE TABLE TTIPOSREPORTE ( 
	CTIPOREPORTE VARCHAR(20) NOT NULL , 
	FHASTA TIMESTAMP NOT NULL , 
	CIDIOMA VARCHAR(3) NOT NULL , 
	FDESDE TIMESTAMP NOT NULL , 
	DESCRIPCION VARCHAR(20) NOT NULL , 
	VERSIONCONTROL NUMERIC(22, 0) DEFAULT 0 , 
	CONSTRAINT IPKREP PRIMARY KEY(CTIPOREPORTE , FHASTA , CIDIOMA));   

ALTER TABLE TTIPOSREPORTE ADD CONSTRAINT FKIDIREP 
	FOREIGN KEY(CIDIOMA) 
	REFERENCES TIDIOMASID (CIDIOMA) 
	ON DELETE NO ACTION 
	ON UPDATE NO ACTION; 

ALTER TABLE TTIPOSREPORTE 
	ADD CONSTRAINT FKREPID 
	FOREIGN KEY(CTIPOREPORTE) 
	REFERENCES TTIPOSREPORTEID (CTIPOREPORTE) 
	ON DELETE NO ACTION 
	ON UPDATE NO ACTION;