Relational Represenation for
Yepes.star.schema Schema

Relational Representation for Object Class Accelerator_setup

RELATION: Accelerator_setup
Name	Data Type	Default	Primary Key?	Null?	Foreign Key to
_oid	numeric		Yes	No	OBJECTS
acc_id	int		No	No
beam_1	numeric		No	No	Beam_setup
beam_2	numeric		No	No	Beam_setup

Back to Class Definition

Relational Representation for Object Class Beam_setup

RELATION: Beam_setup
Name	Data Type	Default	Primary Key?	Null?	Foreign Key to
Beam	numeric		No	No	Ion
Energy	float		No	No
Polarization	float		No	No
_oid	numeric		Yes	No	OBJECTS
beam_id	char(10)		No	No

Back to Class Definition

Relational Representation for Object Class Data_set

RELATION: Data_set
Name	Data Type	Default	Primary Key?	Null?	Foreign Key to
End	datetime		No	No
Experiment	numeric		No	No	Experiment_setup
RHIC	numeric		No	No	Accelerator_setup
Start	datetime		No	No
_oid	numeric		Yes	No	OBJECTS
set_id	int		No	No

RELATION: Data_set_run
Name	Data Type	Default	Primary Key?	Null?	Foreign Key to
_aid	identity		Yes	No
_oid	numeric		No	No	Data_set
run	numeric		No	No	Run

Back to Class Definition

Relational Representation for Object Class Data_unit

RELATION: Data_unit
Name	Data Type	Default	Primary Key?	Null?	Foreign Key to
DATA_STORE	varchar(60)		No	Yes
_oid	numeric		Yes	No	OBJECTS

Back to Class Definition

Relational Representation for Object Class Detector

RELATION: Detector
Name	Data Type	Default	Primary Key?	Null?	Foreign Key to
Name	varchar(10)		No	No
Status	bit		No	No
_oid	numeric		Yes	No	OBJECTS

Back to Class Definition

Relational Representation for Object Class Experiment

RELATION: Experiment
Name	Data Type	Default	Primary Key?	Null?	Foreign Key to
Full_Name	varchar(75)		No	No
Name	varchar(25)		No	No
_oid	numeric		Yes	No	OBJECTS

RELATION: Experiment_Data
Name	Data Type	Default	Primary Key?	Null?	Foreign Key to
Data	numeric		No	No	Data_set
_aid	identity		Yes	No
_oid	numeric		No	No	Experiment

RELATION: Experiment_Simulation
Name	Data Type	Default	Primary Key?	Null?	Foreign Key to
Simulation	numeric		No	No	Mc_set
_aid	identity		Yes	No
_oid	numeric		No	No	Experiment

Back to Class Definition

Relational Representation for Object Class Experiment_setup

RELATION: Experiment_setup
Name	Data Type	Default	Primary Key?	Null?	Foreign Key to
Bfield	float		No	No
_oid	numeric		Yes	No	OBJECTS
exp_id	int		No	No

RELATION: Experiment_setup_detectors
Name	Data Type	Default	Primary Key?	Null?	Foreign Key to
_aid	identity		Yes	No
_oid	numeric		No	No	Experiment_setup
detectors	numeric		No	No	Detector

Back to Class Definition

Relational Representation for Object Class Event

RELATION: Event
Name	Data Type	Default	Primary Key?	Null?	Foreign Key to
ESD	numeric		No	Yes	Data_unit
RAW	numeric		No	Yes	Data_unit
RECO	numeric		No	Yes	Data_unit
_oid	numeric		Yes	No	OBJECTS
number	int		No	No

Back to Class Definition

Relational Representation for Object Class Generator

RELATION: Generator
Name	Data Type	Default	Primary Key?	Null?	Foreign Key to
Name	varchar(25)		No	Yes
Version	float		No	Yes
_oid	numeric		Yes	No	OBJECTS
gen_id	int		No	No

Back to Class Definition

Relational Representation for Object Class Ion

RELATION: Ion
Name	Data Type	Default	Primary Key?	Null?	Foreign Key to
A	tinyint		No	No
Name	char(5)		No	No
Z	tinyint		No	No
_oid	numeric		Yes	No	OBJECTS

Back to Class Definition

Relational Representation for Object Class Mc_event

RELATION: Mc_event
Name	Data Type	Default	Primary Key?	Null?	Foreign Key to
EVG	numeric		No	Yes	Data_unit
GEANT	numeric		No	Yes	Data_unit
_oid	numeric		Yes	No	Event

Back to Class Definition

Relational Representation for Object Class Mc_run

RELATION: Mc_run
Name	Data Type	Default	Primary Key?	Null?	Foreign Key to
_oid	numeric		Yes	No	Run

RELATION: Mc_run_event
Name	Data Type	Default	Primary Key?	Null?	Foreign Key to
_aid	identity		Yes	No
_oid	numeric		No	No	Mc_run
event	numeric		No	No	Mc_event

Back to Class Definition

Relational Representation for Object Class Mc_set

RELATION: Mc_set
Name	Data Type	Default	Primary Key?	Null?	Foreign Key to
_oid	numeric		Yes	No	Data_set
generator	numeric		No	No	Generator

RELATION: Mc_set_run
Name	Data Type	Default	Primary Key?	Null?	Foreign Key to
_aid	identity		Yes	No
_oid	numeric		No	No	Mc_set
run	numeric		No	No	Mc_run

Back to Class Definition

Relational Representation for Object Class Run

RELATION: Run
Name	Data Type	Default	Primary Key?	Null?	Foreign Key to
End	datetime		No	Yes
Start	datetime		No	Yes
_oid	numeric		Yes	No	OBJECTS
run_id	int		No	No

RELATION: Run_events
Name	Data Type	Default	Primary Key?	Null?	Foreign Key to
_aid	identity		Yes	No
_oid	numeric		No	No	Run
events	numeric		No	No	Event

Back to Class Definition