Entity-Relationshio Represenation for

Yepes.star.schema Schema

ER Representation for Object Class Accelerator_setup

Entity Set Accelerator_setup
Description: Accelerator Setup ;
Attributes:
  • acc_id: int (identifier, no nulls)
Relationships with other entity-sets:
  • ALWAYS_HAS Beam_setup
  • ALWAYS_HAS Beam_setup
Back to Class Definition

ER Representation for Object Class Beam_setup

Entity Set Beam_setup
Description: Beam Setup ;
Attributes:
  • beam_id: char(10) (identifier, no nulls)
  • Energy: float (no nulls)
  • Polarization: float (no nulls)
Relationships with other entity-sets:
  • ALWAYS_HAS Ion
Back to Class Definition

ER Representation for Object Class Data_set

Entity Set Data_set
Description: Run Period ;
Attributes:
  • set_id: int (identifier, no nulls)
  • Start: datetime (no nulls)
  • End: datetime (no nulls)
Relationships with other entity-sets:
  • ALWAYS_HAS Experiment_setup
  • ALWAYS_HAS Accelerator_setup
Relationships representing set-valued attributes
  • Data_set_run
    Description: Data_set_run;
    Attributes: (none)
    Entity-Sets Involved:
    • Data_set (MANY)
    • Run (MANY)
Back to Class Definition

ER Representation for Object Class Data_unit

Entity Set Data_unit
Description: Contains a unit (raw,reco,esd) of data for one event ;
Attributes:
  • DATA_STORE: varchar(60)
Relationships with other entity-sets: (none)
Back to Class Definition

ER Representation for Object Class Detector

Entity Set Detector
Description: Detector is a piece of equipment in an experiment ;
Attributes:
  • Name: varchar(10) (identifier, no nulls)
  • Status: binary(1) (no nulls)
Relationships with other entity-sets: (none)
Back to Class Definition

ER Representation for Object Class Experiment

Entity Set Experiment
Description: Experiment;
Attributes:
  • Name: varchar(25) (identifier, no nulls)
  • Full_Name: varchar(75) (no nulls)
Relationships with other entity-sets: (none)
Relationships representing set-valued attributes
  • Experiment_Data
    Description: Experiment_Data;
    Attributes: (none)
    Entity-Sets Involved:
    • Experiment (MANY)
    • Data_set (MANY)
  • Experiment_Simulation
    Description: Experiment_Simulation;
    Attributes: (none)
    Entity-Sets Involved:
    • Experiment (MANY)
    • Mc_set (MANY)
Back to Class Definition

ER Representation for Object Class Experiment_setup

Entity Set Experiment_setup
Description: Experiment setup;
Attributes:
  • exp_id: int (identifier, no nulls)
  • Bfield: float (no nulls)
Relationships with other entity-sets: (none)
Relationships representing set-valued attributes
  • Experiment_setup_detectors
    Description: Experiment_setup_detectors;
    Attributes: (none)
    Entity-Sets Involved:
    • Experiment_setup (MANY)
    • Detector (MANY)
Back to Class Definition

ER Representation for Object Class Event

Entity Set Event
Description: Event Object ;
Attributes:
  • number: int (identifier, no nulls)
Relationships with other entity-sets:
  • HAS Data_unit
  • HAS Data_unit
  • HAS Data_unit
Back to Class Definition

ER Representation for Object Class Generator

Entity Set Generator
Description: Monte Carlo Generator ;
Attributes:
  • gen_id: int (identifier, no nulls)
  • Name: varchar(25)
  • Version: float
Relationships with other entity-sets: (none)
Back to Class Definition

ER Representation for Object Class Ion

Entity Set Ion
Description: Beam Particle ;
Attributes:
  • Name: char(5) (identifier, no nulls)
  • A: tinyint (no nulls)
  • Z: tinyint (no nulls)
Relationships with other entity-sets: (none)
Back to Class Definition

ER Representation for Object Class Mc_event

Entity Set Mc_event
Attributes: (none)
Relationships with other entity-sets:
  • ISA Event
  • HAS Data_unit
  • HAS Data_unit
Back to Class Definition

ER Representation for Object Class Mc_run

Entity Set Mc_run
Attributes: (none)
Relationships with other entity-sets:
  • ISA Run
Relationships representing set-valued attributes
  • Mc_run_event
    Description: Mc_run_event;
    Attributes: (none)
    Entity-Sets Involved:
    • Mc_run (MANY)
    • Mc_event (MANY)
Back to Class Definition

ER Representation for Object Class Mc_set

Entity Set Mc_set
Description: Monte Carlo Data Set ;
Attributes: (none)
Relationships with other entity-sets:
  • ISA Data_set
  • ALWAYS_HAS Generator
Relationships representing set-valued attributes
  • Mc_set_run
    Description: Mc_set_run;
    Attributes: (none)
    Entity-Sets Involved:
    • Mc_set (MANY)
    • Mc_run (MANY)
Back to Class Definition

ER Representation for Object Class Run

Entity Set Run
Description: Time during which beam condiditions are stable ;
Attributes:
  • run_id: int (identifier, no nulls)
  • Start: datetime
  • End: datetime
Relationships with other entity-sets: (none)
Relationships representing set-valued attributes
  • Run_events
    Description: Run_events;
    Attributes: (none)
    Entity-Sets Involved:
    • Run (MANY)
    • Event (MANY)
Back to Class Definition