4
(WIP) MCD
SephiGame edited this page 2025-04-13 14:21:34 +02:00
UTILISATEUR
| Colonne | Type |
|---|---|
| UT_ID | int |
| UT_NOM | varchar(50) |
| UT_PRENOM | varchar(50) |
| UT_MAIL | varchar(100) |
| (FK) UT_TYPE_CLIENTE | int |
| UT_AGE | datetime |
| UT_NB_RDV | int |
| UT_NB_RDV_HONORES | int |
| UT_PRIX_MOYEN | int |
| UT_PDP | blob |
| UT_MDP | text |
| UT_TELEPHONE | text(10) |
| UT_DATE_INSCRIPTION | datetime |
| UT_DERNIERE_CONNEXION | datetime |
COMMANDE
| Colonne | Type |
|---|---|
| CO_ID | int |
| CO_UTILISATEUR | int |
| CO_DATE_CREATION | datetime |
| CO_DATE_UPDATE | datetime |
| CO_STATUS | varchar(10) |
COMMANDE_FORMATION
| Colonne | Type |
|---|---|
| COF_COMMANDE | int |
| COF_FORMATION | int |
FORMATION
| Colonne | Type |
|---|---|
| FO_ID | int |
| FO_TITRE | varchar(50) |
| FO_DESCRIPTION | varchar(50) |
| FO_PRIX | varchar(100) |
| FO_MINIATURE | blob |
| FO_TEASER | varchar(255) |
| FO_URL | varchar(255) |
| FO_DATE_PUBLICATION | datetime |
VIDEO
| Colonne | Type |
|---|---|
| VI_ID | int |
| VI_FORMATION_ID | int |
| VI_TITRE | varchar(50) |
| VI_DESCRIPTION | varchar(50) |
| VI_URL | varchar(255) |
ACHAT
| Colonne | Type |
|---|---|
| AC_ID | int |
| FK AC_USER_ID | int |
| AC_ARTICLE_ID | int |
| AC_TYPE | varchar(50) |
| AC_DATE_ACHAT | datetime |
| AC_DATE_FIN | datetime |