1,988
edits
Table llx boxes: Difference between revisions
Jump to navigation
Jump to search
m
→Table: insert column #
m (→Table: insert params) |
m (→Table: insert column #) |
||
| Line 17: | Line 17: | ||
==Table== | ==Table== | ||
{| class="dolbox" width="100%" cellspacing="0" cellpadding="1" border="0" align="left" | {| class="dolbox" width="100%" cellspacing="0" cellpadding="1" border="0" align="left" | ||
| style="background-color: #e9e9ef" |<b>Field</b> | |# | ||
| style="background-color: #e9e9ef" |<b>Field</b> | |||
| style="background-color: #e9e9ef" |<b>Type</b> | | style="background-color: #e9e9ef" |<b>Type</b> | ||
| style="background-color: #e9e9ef" |<b>Null</b> | | style="background-color: #e9e9ef" |<b>Null</b> | ||
| Line 24: | Line 25: | ||
| style="background-color: #e9e9ef" |<b>Extra</b> | | style="background-color: #e9e9ef" |<b>Extra</b> | ||
| style="background-color: #e9e9ef" |<b>Description</b> | | style="background-color: #e9e9ef" |<b>Description</b> | ||
|- | |- | ||
|1 | |||
|rowid | |rowid | ||
|int(11) | |int(11) | ||
| Line 33: | Line 35: | ||
|technical index | |technical index | ||
|- | |- | ||
|2 | |||
|entity | |entity | ||
|int(11) | |int(11) | ||
| Line 40: | Line 43: | ||
| | | | ||
| | | | ||
|- | |- | ||
|3 | |||
|box_id | |box_id | ||
|int(11) | |int(11) | ||
| Line 48: | Line 52: | ||
| | | | ||
|ID of box ([[Boxes def (Table SQL)|llx_boxes_def]]->rowid) | |ID of box ([[Boxes def (Table SQL)|llx_boxes_def]]->rowid) | ||
|- | |- | ||
|4 | |||
|position | |position | ||
|smallint(6) | |smallint(6) | ||
| Line 56: | Line 61: | ||
| | | | ||
|Position of box | |Position of box | ||
|- | |- | ||
|5 | |||
|box_order | |box_order | ||
|varchar(3) | |varchar(3) | ||
| Line 65: | Line 71: | ||
|Order of box | |Order of box | ||
|- | |- | ||
|6 | |||
|fk_user | |fk_user | ||
|int(11) | |int(11) | ||
| Line 73: | Line 80: | ||
|ID of user that affect the box order ([[Table llx_user|llx_user]]->rowid) | |ID of user that affect the box order ([[Table llx_user|llx_user]]->rowid) | ||
|- | |- | ||
|7 | |||
|maxline | |maxline | ||
|int(11) | |int(11) | ||
| Line 81: | Line 89: | ||
| | | | ||
|- | |- | ||
|8 | |||
|params | |params | ||
|varchar(255) | |varchar(255) | ||