---------------------------------------------------------
-- Tabele pentru ROAOFERTA v 1.0.0	               --
-- Created by marius.atanasiu on 5/04/2006, 9:07:00 AM --
---------------------------------------------------------

spool tabele.log

prompt
prompt Creating table CRM_NOTE_VANZARI
prompt ===============================
prompt
create table CRM_NOTE_VANZARI
(
  ID_NOTA  NUMBER(5) not null,
  DENUMIRE VARCHAR2(30),
  SCD      VARCHAR2(4),
  ASCD     VARCHAR2(4),
  SCC      VARCHAR2(4),
  ASCC     VARCHAR2(4),
  DATAORAS DATE default SYSDATE,
  STERS    NUMBER(1) default 0,
  ID_UTIL  NUMBER(8),
  DATAORA  DATE,
  ID_UTILS NUMBER(8)
)
tablespace ROA
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table CRM_NOTE_VANZARI
  add constraint PK_CRM_NOTE_VANZARI primary key (ID_NOTA)
  using index 
  tablespace ROA
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table CRM_CATEG_ARTICOLE
prompt =================================
prompt
create table CRM_CATEG_ARTICOLE
(
  ID_CATEG NUMBER(5) not null,
  DENUMIRE VARCHAR2(30),
  ID_NOTA  NUMBER(5),
  STERS    NUMBER(1) default 0,
  ID_UTIL  NUMBER(8),
  DATAORA  DATE default SYSDATE,
  ID_UTILS NUMBER(8),
  DATAORAS DATE,
  TATA     NUMBER(5)
)
tablespace ROA
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table CRM_CATEG_ARTICOLE
  add constraint PK_CRM_CATEG_ARTICOLE primary key (ID_CATEG)
  using index 
  tablespace ROA
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table CRM_CATEG_ARTICOLE
  add constraint FK_CRM_CATEG_ARTICOLE_001 foreign key (ID_NOTA)
  references CRM_NOTE_VANZARI (ID_NOTA);


prompt
prompt Creating table CRM_POLITICI_PRETURI
prompt ===================================
prompt
create table CRM_POLITICI_PRETURI
(
  ID_POL    NUMBER(5) not null,
  NUME      VARCHAR2(100),
  DATAI     DATE,
  DATAS     DATE,
  ID_VALUTA NUMBER(5),
  STERS     NUMBER(1) default 0,
  ID_UTIL   NUMBER(10),
  DATAORA   DATE default sysdate not null,
  ID_UTILS  NUMBER(10),
  DATAORAS  DATE
)
tablespace ROA
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table CRM_POLITICI_PRETURI
  add constraint PK_CRM_PP primary key (ID_POL)
  using index 
  tablespace ROA
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table CRM_POLITICI_PRETURI
  add constraint FK_CRM_PP_001 foreign key (ID_UTIL)
  references SYN_UTILIZATORI (ID_UTIL);
alter table CRM_POLITICI_PRETURI
  add constraint FK_CRM_PP_002 foreign key (ID_UTILS)
  references SYN_UTILIZATORI (ID_UTIL);
alter table CRM_POLITICI_PRETURI
  add constraint FK_CRM_PP_003 foreign key (ID_VALUTA)
  references NOM_VALUTE (ID_VALUTA);



prompt
prompt Creating table CRM_POLITICI_PRET_ART
prompt ====================================
prompt
create table CRM_POLITICI_PRET_ART
(
  ID_POL_ART NUMBER(5) not null,
  ID_POL     NUMBER(5) not null,
  ID_ART     NUMBER(5) not null,
  PRET       NUMBER(20,4),
  UM         VARCHAR2(10),
  ID_VALUTA  NUMBER(5) not null,
  STERS      NUMBER(1) default 0,
  ID_UTIL    NUMBER(10),
  DATAORA    DATE default sysdate not null,
  ID_UTILS   NUMBER(10),
  DATAORAS   DATE
)
tablespace ROA
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table CRM_POLITICI_PRET_ART
  add constraint PK_CRM_PPA primary key (ID_POL_ART)
  using index 
  tablespace ROA
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table CRM_POLITICI_PRET_ART
  add constraint FK_CRM_PPA_001 foreign key (ID_ART)
  references NOM_ARTICOLE (ID_ARTICOL);
alter table CRM_POLITICI_PRET_ART
  add constraint FK_CRM_PPA_002 foreign key (ID_UTIL)
  references SYN_UTILIZATORI (ID_UTIL);
alter table CRM_POLITICI_PRET_ART
  add constraint FK_CRM_PPA_003 foreign key (ID_UTILS)
  references SYN_UTILIZATORI (ID_UTIL);
alter table CRM_POLITICI_PRET_ART
  add constraint FK_CRM_PPA_004 foreign key (ID_VALUTA)
  references NOM_VALUTE (ID_VALUTA);



spool off;