System Architect Definitions, Encyclopedia:"C:\SYSARCH\PROJECT\CCAGE\"

System Architect Definitions "C:\SYSARCH\PROJECT\CCAGE\"

cageid (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 10
ORACLE Unique: F

Return to Index

Ccages (Entity)

Description: @cageid
Normalize: T
Definitions Used:: cageid (Data Element)

Return to Index

Ccage_groupmeas (Entity)

Description:: @1 groupmeas_indx+
measdate+
meastime+
name+
chamber_temp+
chamber_humidity+
outside_temp+
outside_humitidy+
@2 cageid / FKFROM &quotCcages.cageid(groupmeas)"/
Normalize: T
Definitions Used:: cageid (Data Element)
groupmeas_indx (Data Element)
name (Data Element)
chamber_temp (Data Element)
chamber_humidity (Data Element)
outside_temp (Data Element)
outside_humitidy (Data Element)
measdate (Data Element)
meastime (Data Element)

Return to Index

Ccage_indvmeas (Entity)

Normalize: T
Description:: @1 indvmeas_indx+
width1a+
width2a+
width3a+
width1b+
width2b+
width3b+
Rdist1+
Rdist2+
Rdist3+
Length1+
Length2+
Mass+
@2 groupmeas_indx / FKFROM &quotCcage_groupmeas.groupmeas_indx(indvmeas)"/+
@3 cageid / FKFROM &quotCcage_groupmeas.cageid(indvmeas)"/
Definitions Used:: cageid (Data Element)
groupmeas_indx (Data Element)
indvmeas_indx (Data Element)
width1a (Data Element)
width2a (Data Element)
width3a (Data Element)
width1b (Data Element)
width2b (Data Element)
width3b (Data Element)
Rdist1 (Data Element)
Rdist2 (Data Element)
Rdist3 (Data Element)
Length1 (Data Element)
Length2 (Data Element)
Mass (Data Element)

Return to Index

chamber_humidity (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

chamber_temp (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

groupmeas (Relationship)

From Entity: Ccages
To Entity: Ccage_groupmeas
Identifying: T
Parent Insert: No_Action
Parent Update: Cascade
Parent Delete: Restrict
Child Delete: No_Action
Child Insert: Restrict
Child Update: Restrict

Return to Index

groupmeas_indx (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 10
ORACLE Unique: F

Return to Index

indvmeas (Relationship)

From Entity: Ccage_groupmeas
To Entity: Ccage_indvmeas
Identifying: T
Parent Insert: No_Action
Parent Update: Cascade
Parent Delete: Restrict
Child Delete: No_Action
Child Insert: Restrict
Child Update: Restrict

Return to Index

indvmeas_indx (Data Element)

SQL Data Type: NUMBER
SQL Type Qualifiers: 10
ORACLE Unique: F

Return to Index

Length1 (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

Length2 (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

Mass (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

measdate (Data Element)

SQL Data Type: DATE
ORACLE Unique: F

Return to Index

meastime (Data Element)

SQL Data Type: DATE
ORACLE Unique: F

Return to Index

name (Data Element)

SQL Data Type: VARCHAR2
SQL Type Qualifiers: 50
ORACLE Unique: F

Return to Index

outside_humitidy (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

outside_temp (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

Rdist1 (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

Rdist2 (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

Rdist3 (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

width1a (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

width1b (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

width2a (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

width2b (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

width3a (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

width3b (Data Element)

SQL Data Type: FLOAT
SQL Type Qualifiers: 32
ORACLE Unique: F

Return to Index

Return to diagram index