Dise Complete Database structure

This page contains a list of all the tables in the Dise Complete database and their usage.

Administrative

These tables are for administrative proposes mostly and not automatically updated by the software.

Companies

Companies using this database and their information.

People

People accessing the database. A Person can be connected to one of the People providing more details.

Projects

Projects that are working with the database. People and Sites can be connected to a Project.

Sites

Sites for your Dise system, Players and ControlSites can be connected to one site.

Users

Users that have access to your Dise system. An user will have a password that will be used together with the user name to authenticate

Software use

These tables are being automatically updated by the different Dise softwares.

ApprovedLevel

The levels of what Dise Movies can be approved to.

Content

Files, scenes or objects that will be referenced from the statistics.

ControlSites

Information about all PCs that run Composer, Bridge or any other "Control" software.

DynamicData

Custom data that might be used for scheduling or data connections.

Events

Applications will add their events to this table.

GroupItems

Connecting Inventory to the Groups table.

Groups

Groups of different inventory, used for example by the Dise System Control.

Inventory

Applications, displays or other devices that has registered to the database.

InventoryLibrary

Types of applications, displays, devices etc that can be used in the Dise Complete system.

MessageTypes

Different types of messages that applications can register.

Messsages

Messages registered by different applications.

PlayerContent

References between the Players and the Content tables. Gives one unique id for each player-content combination.

Players

PCs that run Replay, Probe or any other Player software.

Problems

Problems added to the system.

ProblemHistory

History of the problems.

Settings

Settings stored by different applications in the system.

Statistics

Statistics information, the information is an id from the PlayersContent table and start and stop dates for the content.

Status

Status for each Player (Replay, Probe) application.

Not used

These tables are currently not used by any of our softwares.

ContentFiles

Table with filename and version information about the different files used in the system.

ContentRelations

Table that will contain relations between different types of content

Customers

Table that will contain the different customers accessing the system.

Orders

Table that will contain the current orders in the system.

Providers

Table that will contain the content providers working with the system.

Other

DCProperties

Used to manage the version of the Dise Complete database structure. Do not change any values in this table.