Difference between revisions of "Template:SQWareRepositoryPresSgbd"
Expdbtools (talk | contribs) (→Naming convention) |
Expdbtools (talk | contribs) (→Presentation) |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
== Presentation == | == Presentation == | ||
| − | It is the repository module, and stores rdbms indicators for | + | It is the repository module, and stores rdbms indicators for all RDBMS.<br> |
| − | It | + | 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 | + | [[Installation#SQWareRepository for {{{1}}} | Installation guide for SQWareRepository for {{{1}}} ]]<br> |
<br> | <br> | ||
== Naming convention == | == Naming convention == | ||
| − | All objects are named with prefixes: | + | All specific objects for {{{1}}} are named with prefixes: |
| − | * tsqw{{{ | + | * tsqw{{{4}}}_% : for tables |
| − | * isqw{{{ | + | * isqw{{{4}}}_% : for index |
| − | * isqw{{{ | + | * isqw{{{4}}}_%_u : for uniques |
| − | * isqw{{{ | + | * isqw{{{4}}}_%_pk : for primary key |
<br> | <br> | ||
{{Warning_objets}} | {{Warning_objets}} | ||
<br> | <br> | ||
Latest revision as of 20: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
