Schema/RefDBLegacy/OracleCMS.sql

-- ======================================================================
create sequence seq_person;
create sequence seq_physics_group;

-- ======================================================================
create table t_person
  (id                           integer         not null,
   name                         varchar (1000)  not null,
   distinguished_name           varchar (1000)  not null,
   contact_info                 varchar (1000)  not null);

create table t_physics_group
  (id                           integer         not null,
   name                         varchar (1000)  not null,
   convenor                     integer         /* not null? */);

-- ======================================================================
alter table t_person
  add constraint pk_person
  primary key (id)
  using index tablespace CMS_DBS_INDX01;

alter table t_person
  add constraint uq_person_name
  unique (name);

alter table t_person
  add constraint uq_person_distinguished
  unique (distinguished_name);

--
alter table t_physics_group
  add constraint pk_physicsgroup
  primary key (id)
  using index tablespace CMS_DBS_INDX01;

alter table t_physics_group
  add constraint uq_physicsgroup_name
  unique (name);

alter table t_physics_group
  add constraint fk_physicsgroup_convener
  foreign key (convenor) references t_person (id);

-- ======================================================================
create index ix_physicsgroup_convener
  on t_physics_group (convenor)
  tablespace CMS_DBS_INDX01;
Revision:	1.5
Committed:	Wed Oct 19 12:54:56 2005 UTC (19 years, 6 months ago) by lat
Content type:	application/sql
Branch:	MAIN
CVS Tags:	before_message_removal
Changes since 1.4:	+2 -43 lines
Log Message:	Store object history in separate table. Make not-understood columns nullable, and don't fill them. Add key for event collection parentage type.
#	Content
1	-- ======================================================================
2	create sequence seq_person;
3	create sequence seq_physics_group;
4
5	-- ======================================================================
6	create table t_person
7	(id 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 (1000) not null,
15	convenor integer /* not null? */);
16
17	-- ======================================================================
18	alter table t_person
19	add constraint pk_person
20	primary key (id)
21	using index tablespace CMS_DBS_INDX01;
22
23	alter table t_person
24	add constraint uq_person_name
25	unique (name);
26
27	alter table t_person
28	add constraint uq_person_distinguished
29	unique (distinguished_name);
30
31	--
32	alter table t_physics_group
33	add constraint pk_physicsgroup
34	primary key (id)
35	using index tablespace CMS_DBS_INDX01;
36
37	alter table t_physics_group
38	add constraint uq_physicsgroup_name
39	unique (name);
40
41	alter table t_physics_group
42	add constraint fk_physicsgroup_convener
43	foreign key (convenor) references t_person (id);
44
45	-- ======================================================================
46	create index ix_physicsgroup_convener
47	on t_physics_group (convenor)
48	tablespace CMS_DBS_INDX01;