DBDesigner4 HTML Report

Database Model plugin_tmp.xml

Authorizations

UserAnnotationAccess

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
Utilisateur_Certificate	INTEGER	PK	NN	UNSIGNED
Annotation_Link	VARCHAR	PK	NN
Rights_idRights	INTEGER		NN	UNSIGNED
LastAcess	DATE

IndexName	IndexType	Columns
PRIMARY	PRIMARY	Utilisateur_Certificate Annotation_Link
User	Index	Utilisateur_Certificate
Annotation	Index	Annotation_Link
Rights	Index	Rights_idRights

UserVideoAccess

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
Utilisateur_Certificate	INTEGER	PK	NN	UNSIGNED
Video_idVid	INTEGER	PK	NN	UNSIGNED
Rights_idRights	INTEGER		NN	UNSIGNED
LastAccess	DATE

IndexName	IndexType	Columns
PRIMARY	PRIMARY	Utilisateur_Certificate Video_idVid
User	Index	Utilisateur_Certificate
Video	Index	Video_idVid
Rights	Index	Rights_idRights

UserViewAccess

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
Utilisateur_Certificate	INTEGER	PK	NN	UNSIGNED
View_idView	INTEGER	PK	NN	UNSIGNED
Rights_idRights	INTEGER		NN	UNSIGNED

IndexName	IndexType	Columns
PRIMARY	PRIMARY	Utilisateur_Certificate View_idView
User	Index	Utilisateur_Certificate
View	Index	View_idView
Rights	Index	Rights_idRights

UserSessionAccess

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
Utilisateur_Certificate	INTEGER	PK	NN	UNSIGNED
Session_idSession	INTEGER	PK	NN	UNSIGNED
Rights_idRights	INTEGER		NN	UNSIGNED

IndexName	IndexType	Columns
PRIMARY	PRIMARY	Utilisateur_Certificate Session_idSession
User	Index	Utilisateur_Certificate
Session	Index	Session_idSession
Rights	Index	Rights_idRights

ConcreteObjects I

Video

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
idVid	INTEGER	PK	NN	UNSIGNED			AI
Workflow_idWorkflow	INTEGER		NN	UNSIGNED
View_idView	INTEGER		NN	UNSIGNED
Utilisateur_Certificate	INTEGER		NN	UNSIGNED

IndexName	IndexType	Columns
PRIMARY	PRIMARY	idVid
Owner	Index	Utilisateur_Certificate
View	Index	View_idView
Workflow	Index	Workflow_idWorkflow

Annotation

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
Link	VARCHAR	PK	NN				AI
Workflow_idWorkflow	INTEGER		NN	UNSIGNED
Utilisateur_Certificate	INTEGER		NN	UNSIGNED
Related	INTEGER			UNSIGNED
LinkKey	INTEGER		NN	UNSIGNED

IndexName	IndexType	Columns
PRIMARY	PRIMARY	Link
Owner	Index	Utilisateur_Certificate
Workflow	Index	Workflow_idWorkflow
LinkKey	Index	LinkKey

View

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
idView	INTEGER	PK	NN	UNSIGNED			AI
Type_2_idType	INTEGER		NN	UNSIGNED
Rule_idRule	INTEGER		NN	UNSIGNED
Utilisateur_Certificate	INTEGER		NN	UNSIGNED
Session_idSession	INTEGER		NN	UNSIGNED

IndexName	IndexType	Columns
PRIMARY	PRIMARY	idView
Session	Index	Session_idSession
Owner	Index	Utilisateur_Certificate
Rule	Index	Rule_idRule
Type	Index	Type_2_idType

Session

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
idSession	INTEGER	PK	NN	UNSIGNED			AI
Rule_idRule	INTEGER		NN	UNSIGNED
Corpus_idCorpus	INTEGER		NN	UNSIGNED
Utilisateur_Certificate	INTEGER		NN	UNSIGNED

IndexName	IndexType	Columns
PRIMARY	PRIMARY	idSession
Creator	Index	Utilisateur_Certificate
Corpu	Index	Corpus_idCorpus
Rule	Index	Rule_idRule

Corpus

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
idCorpus	INTEGER	PK	NN	UNSIGNED			AI
Rule_idRule	INTEGER		NN	UNSIGNED
Site_idSite	INTEGER		NN	UNSIGNED
Utilisateur_Certificate	INTEGER		NN	UNSIGNED

IndexName	IndexType	Columns
PRIMARY	PRIMARY	idCorpus
Creator	Index	Utilisateur_Certificate
Site	Index	Site_idSite
Rule	Index	Rule_idRule

Site

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
idSite	INTEGER	PK	NN	UNSIGNED			AI
Rule_idRule	INTEGER		NN	UNSIGNED

IndexName	IndexType	Columns
PRIMARY	PRIMARY	idSite
Rule	Index	Rule_idRule

ConcreteVideo

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
Video_idVid	INTEGER	PK	NN	UNSIGNED
Resolution_idResolution	INTEGER	PK	NN	UNSIGNED
Format_idFormat	INTEGER	PK	NN	UNSIGNED
Link	VARCHAR

IndexName	IndexType	Columns
PRIMARY	PRIMARY	Video_idVid Resolution_idResolution Format_idFormat
Video	Index	Video_idVid
Resolution	Index	Resolution_idResolution
Format	Index	Format_idFormat

MontageParts

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
Montage_idMontage	INTEGER	PK	NN	UNSIGNED
View_idView	INTEGER	PK	NN	UNSIGNED

IndexName	IndexType	Columns
PRIMARY	PRIMARY	Montage_idMontage View_idView
MontageParts_FKIndex1	Index	Montage_idMontage
MontageParts_FKIndex2	Index	View_idView

SubCorpus

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
Corpus_idCorpus	INTEGER	PK	NN	UNSIGNED

IndexName	IndexType	Columns
PRIMARY	PRIMARY	Corpus_idCorpus
Pere	Index	Corpus_idCorpus
Fils	Index	Corpus_idCorpus

Meta

AnnotationMeta

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
Metadata_idMetadata	INTEGER	PK	NN	UNSIGNED
Annotation_Link	VARCHAR	PK	NN
Content	TEXT

IndexName	IndexType	Columns
PRIMARY	PRIMARY	Metadata_idMetadata Annotation_Link
Meta	Index	Metadata_idMetadata
Annotation	Index	Annotation_Link

VideoMeta

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
Metadata_idMetadata	INTEGER	PK	NN	UNSIGNED
Video_idVid	INTEGER	PK	NN	UNSIGNED
Content	TEXT

IndexName	IndexType	Columns
PRIMARY	PRIMARY	Metadata_idMetadata Video_idVid
Meta	Index	Metadata_idMetadata
Video	Index	Video_idVid

CorpusMeta

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
Corpus_idCorpus	INTEGER	PK	NN	UNSIGNED
Metadata_idMetadata	INTEGER	PK	NN	UNSIGNED
Content	TEXT

IndexName	IndexType	Columns
PRIMARY	PRIMARY	Corpus_idCorpus Metadata_idMetadata
Corpus	Index	Corpus_idCorpus
Meta	Index	Metadata_idMetadata

SessionMeta

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
Session_idSession	INTEGER	PK	NN	UNSIGNED
Metadata_idMetadata	INTEGER	PK	NN	UNSIGNED
Content	TEXT

IndexName	IndexType	Columns
PRIMARY	PRIMARY	Session_idSession Metadata_idMetadata
Session	Index	Session_idSession
Meta	Index	Metadata_idMetadata

SiteMeta

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
Site_idSite	INTEGER	PK	NN	UNSIGNED
Metadata_idMetadata	INTEGER	PK	NN	UNSIGNED
Content	TEXT

IndexName	IndexType	Columns
PRIMARY	PRIMARY	Site_idSite Metadata_idMetadata
Site	Index	Site_idSite
Meta	Index	Metadata_idMetadata

ViewMeta

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
View_idView	INTEGER	PK	NN	UNSIGNED
Metadata_idMetadata	INTEGER	PK	NN	UNSIGNED
Content	TEXT

IndexName	IndexType	Columns
PRIMARY	PRIMARY	View_idView Metadata_idMetadata
View	Index	View_idView
Meta	Index	Metadata_idMetadata

MontageMeta

ColumnName	DataType	PrimaryKey	NotNull	Flags	Default Value	Comment	AutoInc
Montage_idMontage	INTEGER	PK	NN	UNSIGNED
Metadata_idMetadata	INTEGER	PK	NN	UNSIGNED
Content	TEXT

IndexName	IndexType	Columns
PRIMARY	PRIMARY	Montage_idMontage Metadata_idMetadata
MontageMeta_FKIndex1	Index	Montage_idMontage
MontageMeta_FKIndex2	Index	Metadata_idMetadata