202 lines
4.3 KiB
SQL
202 lines
4.3 KiB
SQL
---------------------------------------------------------
|
|
-- 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; |