ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

DataloggerProgramFiles

Information about datalogger program files

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	ProgramID	Integer				Primary key identifier
	AffiliationID	Integer				Foreign key identifier of the affiliation for the person that created the program
	ProgramName	VarChar(255)				Text name of the datalogger program file
	ProgramDescription	VarChar(5000)				Text description of the datalogger program file
	ProgramVersion	VarChar(50)				Text description of the version of the datalogger program file
	ProgramFileLink	VarChar(255)				URL or file path to the datalogger program file

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_DataloggerProgramFiles_Affiliations	ODM2Core.Affiliations	ODM2Equipment.DataloggerProgramFiles	AffiliationID	AffiliationID

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_DataLoggerFiles_DataloggerProgramFiles	ODM2Equipment.DataloggerProgramFiles	ODM2Equipment.DataLoggerFiles	ProgramID	ProgramID

Triggers (none)

Used in Diagrams

Diagram Name

ODM2Equipment