| 6 |
|
-- ====================================================================== |
| 7 |
|
create table t_run_quality |
| 8 |
|
(id integer not null, |
| 9 |
< |
name varchar (1000) not null, |
| 10 |
< |
created_at float not null, |
| 11 |
< |
created_by integer not null, |
| 12 |
< |
modified_at float, |
| 13 |
< |
modified_by integer); |
| 9 |
> |
name varchar (1000) not null); |
| 10 |
|
|
| 11 |
|
create table t_run |
| 12 |
|
(id integer not null, |
| 13 |
|
run_number integer not null, |
| 14 |
< |
run_quality integer not null, |
| 19 |
< |
created_at float not null, |
| 20 |
< |
created_by integer not null, |
| 21 |
< |
modified_at float, |
| 22 |
< |
modified_by integer); |
| 14 |
> |
run_quality integer not null); |
| 15 |
|
|
| 16 |
|
create table t_evcoll_run |
| 17 |
|
(event_collection integer not null, |
| 27 |
|
add constraint uq_run_quality_name |
| 28 |
|
unique (name); |
| 29 |
|
|
| 38 |
– |
alter table t_run_quality |
| 39 |
– |
add constraint fk_run_quality_creatby |
| 40 |
– |
foreign key (created_by) references t_person (id); |
| 41 |
– |
|
| 42 |
– |
alter table t_run_quality |
| 43 |
– |
add constraint fk_run_quality_modifby |
| 44 |
– |
foreign key (modified_by) references t_person (id); |
| 45 |
– |
|
| 30 |
|
-- |
| 31 |
|
alter table t_run |
| 32 |
|
add constraint pk_run |
| 41 |
|
add constraint fk_run_quality |
| 42 |
|
foreign key (run_quality) references t_run_quality (id); |
| 43 |
|
|
| 60 |
– |
alter table t_run |
| 61 |
– |
add constraint fk_run_creatby |
| 62 |
– |
foreign key (created_by) references t_person (id); |
| 63 |
– |
|
| 64 |
– |
alter table t_run |
| 65 |
– |
add constraint fk_run_modifby |
| 66 |
– |
foreign key (modified_by) references t_person (id); |
| 67 |
– |
|
| 44 |
|
-- |
| 45 |
|
alter table t_evcoll_run |
| 46 |
|
add constraint pk_evcoll_run |
| 54 |
|
alter table t_evcoll_run |
| 55 |
|
add constraint fk_evcoll_run_run |
| 56 |
|
foreign key (run) references t_run (id); |
| 81 |
– |
|
| 82 |
– |
-- ====================================================================== |
| 83 |
– |
create index ix_run_quality_creatby |
| 84 |
– |
on t_run_quality (created_by) |
| 85 |
– |
tablespace CMS_DBS_INDX01; |
| 86 |
– |
|
| 87 |
– |
create index ix_run_quality_modifby |
| 88 |
– |
on t_run_quality (modified_by) |
| 89 |
– |
tablespace CMS_DBS_INDX01; |
| 90 |
– |
|
| 91 |
– |
-- |
| 92 |
– |
create index ix_run_creatby |
| 93 |
– |
on t_run (created_by) |
| 94 |
– |
tablespace CMS_DBS_INDX01; |
| 95 |
– |
|
| 96 |
– |
create index ix_run_modifby |
| 97 |
– |
on t_run (modified_by) |
| 98 |
– |
tablespace CMS_DBS_INDX01; |
