...
The table art_spec contains all article specifications.
Art specification is a clientwide ressource.
Table structure
| Field name | Field specification | Comment / Explanation |
|---|---|---|
| idartspec | int(11) | Primary key (auto increment) |
| client | int(11) | Foreign key to table client |
| lang | int(11) | Foreign key to table lang |
| artspec | varchar(255) | Name of the article specification |
| online | tinyint(1) | Flag if specification is active or not |
| artspecdefault | tinyint(1) | Flag if this specification is the default one or not |
...