Table llx entrepot

Revision as of 02:45, 6 August 2007 by Ywarnier (talk | contribs)

Catégorie:StockCatégorie:Table SQL

 La documentation relative aux autres tables est disponible sur la page Liste des tables
 The documentation related to other tables is available on the tables list page: Liste des tables

Contenu

La table llx_entrepot contient la liste des entrepôts et des informations de localisation les concernant

Contains the list of warehouses and related localisation information.

Structure

+----------------+--------------+------+-----+-------------------+----------------+
| 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              |                |
+----------------+--------------+------+-----+-------------------+----------------+