Difference between revisions of "Template:SQWareRepositoryPresSgbd"
Expdbtools (talk | contribs) (Page créée avec « == présentation == C'est le module de gestion du référentiel et indicateurs en bdd pour {{{1}}}.<br> Il s'agit {{{2}}} {{{1}}}). C'est pour l'instant le seul type de SGBD … ») |
Expdbtools (talk | contribs) (→Presentation) |
||
| (16 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | == | + | == Presentation == |
| − | + | It is the repository module, and stores rdbms indicators for all RDBMS.<br> | |
| − | + | It is a MySQL database.<br> | |
| − | + | Objects prefix by tsqw_% or isqw_% are generic.<br> | |
| − | + | Objects prefix by tsqw{{{4}}}_% or isqw{{{4}}}_% are specific for {{{1}}}.<br> | |
| + | [[Installation#SQWareRepository for {{{1}}} | Installation guide for SQWareRepository for {{{1}}} ]]<br> | ||
| + | <br> | ||
| − | == convention | + | == Naming convention == |
| − | + | All specific objects for {{{1}}} are named with prefixes: | |
| − | * | + | * tsqw{{{4}}}_% : for tables |
| − | * | + | * isqw{{{4}}}_% : for index |
| − | * | + | * isqw{{{4}}}_%_u : for uniques |
| − | * | + | * isqw{{{4}}}_%_pk : for primary key |
| + | <br> | ||
{{Warning_objets}} | {{Warning_objets}} | ||
<br> | <br> | ||
Latest revision as of 19:15, 22 December 2017
Presentation
It is the repository module, and stores rdbms indicators for all RDBMS.
It is a MySQL database.
Objects prefix by tsqw_% or isqw_% are generic.
Objects prefix by tsqw{{{4}}}_% or isqw{{{4}}}_% are specific for {{{1}}}.
[[Installation#SQWareRepository for {{{1}}} | Installation guide for SQWareRepository for {{{1}}} ]]
Naming convention
All specific objects for {{{1}}} are named with prefixes:
- tsqw{{{4}}}_% : for tables
- isqw{{{4}}}_% : for index
- isqw{{{4}}}_%_u : for uniques
- isqw{{{4}}}_%_pk : for primary key
