| Colonne | Type | Null | Key |
|---|
| manuscrit_ID | bigint | NO | PRI |
| manuscrit_user_ID | int | NO | MUL |
| manuscrit_titre | varchar(255) | YES | |
| manuscrit_auteur | varchar(255) | YES | |
| manuscrit_description | text | YES | |
| manuscrit_etape | int | YES | |
| manuscrit_file_path | varchar(255) | YES | |
| manuscrit_bonnesfeuilles | varchar(255) | NO | |
| manuscrit_couverture | varchar(255) | NO | |
| manuscrit_4couverture | varchar(255) | NO | |
| manuscrit_statut | enum('Brouillon','Publié','Envoyé','Accepté','Refusé') | YES | |
| manuscrit_date_creation | timestamp | YES | |
| manuscrit_date_modification | timestamp | YES | |
| manuscrit_taille | bigint | YES | |
| manuscrit_nombre_chapitres | int | YES | |
| manuscrit_nombre_mots | int | YES | |
| manuscrit_sommaire | text | YES | |
| manuscrit_format_prevu | enum('Broché','Ebook','Poche','Audiobook','Autre') | YES | |
| manuscrit_est_serie | tinyint(1) | YES | |
| manuscrit_serie_nom | varchar(255) | YES | |
| manuscrit_serie_ordre | int | YES | |
| manuscrit_resume_long | text | YES | |
| manuscrit_public_cible | enum('Jeunesse','Adulte','Jeunes adultes','Tous publics') | YES | |
| manuscrit_genre_ID | int | YES | MUL |
| manuscrit_editeur_nom | varchar(255) | YES | |
| manuscrit_editeur_adresse | text | YES | |
| manuscrit_directeur_publication | varchar(255) | YES | |
| manuscrit_depot_legal | date | YES | |
| manuscrit_isbn | varchar(20) | YES | |
| manuscrit_imprimeur | varchar(255) | YES | |
| manuscrit_lieu_impression | varchar(255) | YES | |
| manuscrit_tirage | varchar(50) | YES | |
| manuscrit_copyright | varchar(255) | YES | |
| manuscrit_date_parution | date | YES | |
| manuscrit_licence_droits | varchar(255) | YES | |
| manuscrit_downloads | int | YES | |
| manuscrit_etat | enum('privé','public') | NO | |
| manuscrit_actif | tinyint | NO | |
| manuscrit_synopsis | longtext | YES | |