| 5 |
|
-- ====================================================================== |
| 6 |
|
create table t_person |
| 7 |
|
(id integer not null, |
| 8 |
< |
name varchar (80) not null, |
| 9 |
< |
distinguished_name varchar (255) not null, |
| 10 |
< |
contact_info varchar (255) not null, |
| 11 |
< |
created_at float not null, |
| 12 |
< |
created_by integer not null, |
| 13 |
< |
modified_at float not null, |
| 14 |
< |
modified_by integer not null); |
| 8 |
> |
name varchar (1000) not null, |
| 9 |
> |
distinguished_name varchar (1000) not null, |
| 10 |
> |
contact_info varchar (1000) not null); |
| 11 |
|
|
| 12 |
|
create table t_physics_group |
| 13 |
|
(id integer not null, |
| 14 |
< |
name varchar (80) not null, |
| 15 |
< |
convenor integer /* not null? */, |
| 20 |
< |
created_at float not null, |
| 21 |
< |
created_by integer not null, |
| 22 |
< |
modified_at float not null, |
| 23 |
< |
modified_by integer not null); |
| 14 |
> |
name varchar (1000) not null, |
| 15 |
> |
convenor integer /* not null? */); |
| 16 |
|
|
| 17 |
|
-- ====================================================================== |
| 18 |
|
alter table t_person |
| 28 |
|
add constraint uq_person_distinguished |
| 29 |
|
unique (distinguished_name); |
| 30 |
|
|
| 39 |
– |
alter table t_person |
| 40 |
– |
add constraint fk_person_creat |
| 41 |
– |
foreign key (created_by) references t_person (id); |
| 42 |
– |
|
| 43 |
– |
alter table t_person |
| 44 |
– |
add constraint fk_person_mod |
| 45 |
– |
foreign key (modified_by) references t_person (id); |
| 46 |
– |
|
| 31 |
|
-- |
| 32 |
|
alter table t_physics_group |
| 33 |
|
add constraint pk_physicsgroup |
| 42 |
|
add constraint fk_physicsgroup_convener |
| 43 |
|
foreign key (convenor) references t_person (id); |
| 44 |
|
|
| 61 |
– |
alter table t_physics_group |
| 62 |
– |
add constraint fk_physicsgroup_creat |
| 63 |
– |
foreign key (created_by) references t_person (id); |
| 64 |
– |
|
| 65 |
– |
alter table t_physics_group |
| 66 |
– |
add constraint fk_physicsgroup_mod |
| 67 |
– |
foreign key (modified_by) references t_person (id); |
| 68 |
– |
|
| 45 |
|
-- ====================================================================== |
| 70 |
– |
create index ix_person_creat |
| 71 |
– |
on t_person (created_by) |
| 72 |
– |
tablespace CMS_DBS_INDX01; |
| 73 |
– |
|
| 74 |
– |
create index ix_person_mod |
| 75 |
– |
on t_person (modified_by) |
| 76 |
– |
tablespace CMS_DBS_INDX01; |
| 77 |
– |
|
| 78 |
– |
-- |
| 46 |
|
create index ix_physicsgroup_convener |
| 47 |
|
on t_physics_group (convenor) |
| 48 |
|
tablespace CMS_DBS_INDX01; |
| 82 |
– |
|
| 83 |
– |
create index ix_physicsgroup_creat |
| 84 |
– |
on t_physics_group (created_by) |
| 85 |
– |
tablespace CMS_DBS_INDX01; |
| 86 |
– |
|
| 87 |
– |
create index ix_physicsgroup_mod |
| 88 |
– |
on t_physics_group (modified_by) |
| 89 |
– |
tablespace CMS_DBS_INDX01; |
