# Databases tables but no fields

**URL:** https://discuss.tryton.org/t/databases-tables-but-no-fields/8108
**Category:** Developer
**Created:** [December 9, 2024, 2:37pm UTC](https://discuss.tryton.org/t/databases-tables-but-no-fields/8108 "2024-12-09T14:37:25Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![herve\_02](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/h/7ea924/32.png) [@herve\_02](https://discuss.tryton.org/u/herve_02)
#### Post date: [December 9, 2024, 2:37pm UTC](https://discuss.tryton.org/t/databases-tables-but-no-fields/8108/1 "2024-12-09T14:37:25Z")

</div>

i do not understand why the databases are created but not the fields. should e obvious but i can’t see..

```auto
class Contrats(DeactivableMixin, ModelSQL, ModelView, MultiValueMixin):
	'Contrats'
	__name__ = 'formo.contrats'
    
	_order_name = 'write_date'
	_order = [('write_date', 'DESC')]
	
	code = fields.Char('Code', required=True, select=True),
	date_contrat = fields.Date('Date contrat'),
	libelle = fields.Char('Libellé',size=255),
	regles = fields.MultiValue(
		fields.Many2One('formo.regles', "Contrats-règles")),
	AyantDroit = fields.Many2One('party.party', 'party' "Ayant Droit"),
	notes=fields.Text('Notes'),
	produits = fields.Many2Many(
		'formo.contrats_rel_product.product', 'party', 'category', "Produits")

```

```auto
tryton=# \d formo_contrats;
                                             Table « public.formo_contrats »
   Colonne | Type | Collationnement | NULL-able | Par défaut                 
-------------+--------------------------------+-----------------+-----------+--------------------------------------------
 id | integer | | not null | nextval('formo_contrats_id_seq'::regclass)
 active | boolean | | | false
 create_date | timestamp(6) without time zone | | | 
 create_uid | integer | | | 
 write_date | timestamp(6) without time zone | | | 
 write_uid | integer | | | 
Index :
    "formo_contrats_pkey" PRIMARY KEY, btree (id)
Contraintes de vérification :
    "formo_contrats_id_positive" CHECK (id >= 0)

```

---

<div class="post-metadata">

### Author: ![dave](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/d/ee7513/32.png) [@dave](https://discuss.tryton.org/u/dave)
#### Post date: [December 9, 2024, 3:33pm UTC](https://discuss.tryton.org/t/databases-tables-but-no-fields/8108/2 "2024-12-09T15:33:14Z")

</div>

Might be related to the commas that you have at the end of each line

> [@herve\_02](#):
>
> `...elect=True)` **,**

---

<div class="post-metadata">

### Author: ![herve\_02](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/h/7ea924/32.png) [@herve\_02](https://discuss.tryton.org/u/herve_02)
#### Post date: [December 9, 2024, 3:50pm UTC](https://discuss.tryton.org/t/databases-tables-but-no-fields/8108/3 "2024-12-09T15:50:09Z")

</div>

/o  
thank you very much

---

<div class="post-metadata">

### Author: ![system](https://discuss-cdn.tryton.org/uploads/default/original/1X/c6f8ec0a40525cdcd50058c734283450a4b3d38b.png) [@system](https://discuss.tryton.org/u/system)
#### Post date: [December 10, 2024, 3:50pm UTC](https://discuss.tryton.org/t/databases-tables-but-no-fields/8108/4 "2024-12-10T15:50:18Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
