28,936
edits
Changes
→Structure
Line 11:
Line 11:
= Structure =
= Structure =
−{| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"
+== Table ==
+{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
|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>
Line 22:
Line 23:
| id
| id
| int(11)
| int(11)
−|
+| NO
| PRI
| PRI
|
|
Line 30:
Line 31:
| code
| code
| varchar(12)
| varchar(12)
−|
+| NO
−|
+| UNI
|
|
|
|
Line 46:
Line 47:
| active
| active
| tinyint(4)
| tinyint(4)
−|
+| NO
|
|
| 1
| 1
|
|
| is the status active?
| is the status active?
−|}
+|}
+== Keys ==
+{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
+ |style="background-color: #e9e9ef"| <b>Key</b>
+ |style="background-color: #e9e9ef"| <b>Type</b>
+ |style="background-color: #e9e9ef"| <b>Fields</b>
+|-
+| PRIMARY
+| PRIMARY
+| id
+|-
+| code
+| UNIQUE
+| code
+|}