Hi all,
i was wondering if somebody had started some kind of documentation of OTRS database (i already have the PNG schemas but they are not completely self-explanatory). Could be a book, PDF, Wiki, whatever...
I have browsed the forum but only found very partial information. Any idea, pointer, url?
BTW thanks for this great otrs resource!
Database documentation somewhere?
Moderator: crythias
-
crythias
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Database documentation somewhere?
What do you want to accomplish?
If you want to know the schema, just describe the tables or export the schema from, for instance, phpMyAdmin/mysqldump. If you want to know the interlinking, they're mostly self-describing, as are the table naming schemes, and the png files tell you explicitly.
In general, you shouldn't need to know the documentation of the database. You should know the documentation of the API: http://dev.otrs.org
Ask a specific question about the database, and you'll get a specific answer. Ask a general question and you'll have to gather the information yourself.
If you know enough to know what you're going to do with the documentation of the OTRS database, you probably should have a clue how to get the information based upon what you have access to.
If you know what you're trying to accomplish, general documentation is likely too much information (You want to solve a problem, not recreate OTRS).
If you want to recreate OTRS from the database schema, you should be able to follow the PNGs and the source code to work it out.
Also, don't post questions in HowTos.
If you want to know the schema, just describe the tables or export the schema from, for instance, phpMyAdmin/mysqldump. If you want to know the interlinking, they're mostly self-describing, as are the table naming schemes, and the png files tell you explicitly.
In general, you shouldn't need to know the documentation of the database. You should know the documentation of the API: http://dev.otrs.org
Ask a specific question about the database, and you'll get a specific answer. Ask a general question and you'll have to gather the information yourself.
If you know enough to know what you're going to do with the documentation of the OTRS database, you probably should have a clue how to get the information based upon what you have access to.
If you know what you're trying to accomplish, general documentation is likely too much information (You want to solve a problem, not recreate OTRS).
If you want to recreate OTRS from the database schema, you should be able to follow the PNGs and the source code to work it out.
Also, don't post questions in HowTos.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask