SchemaSpy - Table survey.results

Retargeted results

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

int

10

0

comparisons.res1	FK_comparisons_res1
comparisons.res2	FK_comparisons_res2

Result id (within the dataset)

did

int

10

0

comparisons.did

FK_comparisons_res2

datasets.id

FK_results_did

Dataset id

filename

varchar

64

Result file name

opid

int

10

0

Operator id

Analyzed at Tue Aug 24 23:21 EDT 2010

Indexes:

Column(s)	Type	Sort	Constraint Name
id + did	Primary key	Asc/Asc	PRIMARY
opid	Performance	Asc	IDX_results_opid
id + did	Must be unique	Asc/Asc	UNQ_results_id
did + opid	Must be unique	Asc/Asc	UNQ_results_opid