Table llx entrepot

Revision as of 15:47, 9 December 2006 by Rodo (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Catégorie:StockCatégorie:Table SQL

+----------------+--------------+------+-----+-------------------+----------------+
| Field          | Type         | Null | Key | Default           | Extra          |
+----------------+--------------+------+-----+-------------------+----------------+
| rowid          | int(11)      |      | PRI | NULL              | auto_increment |
| datec          | datetime     | YES  |     | NULL              |                |
| tms            | timestamp    | YES  |     | CURRENT_TIMESTAMP |                |
| label          | varchar(255) |      | UNI |                   |                |
| description    | text         | YES  |     | NULL              |                |
| lieu           | varchar(64)  | YES  |     | NULL              |                |
| address        | varchar(255) | YES  |     | NULL              |                |
| cp             | varchar(10)  | YES  |     | NULL              |                |
| ville          | varchar(50)  | YES  |     | NULL              |                |
| fk_pays        | int(11)      | YES  |     | 0                 |                |
| statut         | tinyint(4)   | YES  |     | 1                 |                |
| fk_user_author | int(11)      | YES  |     | NULL              |                |
+----------------+--------------+------+-----+-------------------+----------------+