Daten-Typen

Tabelle r:
+---------+---------------+------+-----+---------+----------------+
| Field   | Type          | NUll | Key | Default | Extra          |
+---------+---------------+------+-----+---------+----------------+
| rid     | int(11)       | NO   | PRI | Null    | AUTO_INCREMENT |
| name    | varchar(100)  | NO   |     | Null    |                |
| comment | text          | NO   |     | Null    |                |
| lid     | int(11)       | NO   |     | Null    |                |
| uid     | int(11)       | NO   |     | Null    |                |
| created | datetime      | NO   |     | Null    |                |
| status  | enum('0','1') | NO   |     | Null    |                |
+---------+---------------+------+-----+---------+----------------+


tbl:k
+---------+---------------+------+-----+---------+----------------+
| Field   | Type          | NUll | Key | Default | Extra          |
+---------+---------------+------+-----+---------+----------------+
| kid     | int(11)       | NO   | PRI | Null    | AUTO_INCREMENT |
| name    | varchar(100)  | NO   |     | Null    |                |
+---------+---------------+------+-----+---------+----------------+

tbl:r_k
+-------+---------+------+-----+---------+----------------+
| Field | Type    | NUll | Key | Default | Extra          |
+-------+---------+------+-----+---------+----------------+
| id    | int(11) | NO   | PRI | Null    | AUTO_INCREMENT |
| rid   | int(11) | NO   |     | Null    |                |
| kid   | int(11) | NO   |     | Null    |                |
+-------+---------+------+-----+---------+----------------+

tbl:z
+-------+--------------+------+-----+---------+----------------+
| Field | Type         | NUll | Key | Default | Extra          |
+-------+--------------+------+-----+---------+----------------+
| zid   | int(11)      | NO   | PRI | Null    | AUTO_INCREMENT |
| rid   | int(11)      | NO   |     | Null    |                |
| z1    | varchar(150) | NO   |     | Null    |                |
| z2    | varchar(150) | NO   |     | Null    |                |
| z3    | varchar(150) | NO   |     | Null    |                |
+-------+--------------+------+-----+---------+----------------+

tbl:b
+-------+---------+------+-----+---------+----------------+
| Field | Type    | NUll | Key | Default | Extra          |
+-------+---------+------+-----+---------+----------------+
| bid   | int(11) | NO   | PRI | Null    | AUTO_INCREMENT |
| rid   | int(11) | NO   |     | Null    |                |
| b     | text    | NO   |     | Null    |                |
+-------+---------+------+-----+---------+----------------+

tbl:u
+-------+--------------+------+-----+---------+----------------+
| Field | Type         | NUll | Key | Default | Extra          |
+-------+--------------+------+-----+---------+----------------+
| uid   | int(11)      | NO   | PRI | Null    | AUTO_INCREMENT |
| name  | varchar(100) | NO   |     | Null    |                |
| level | int(11)      | NO   |     | Null    |                |
+-------+--------------+------+-----+---------+----------------+

tbl:related
+-------+---------+------+-----+---------+----------------+
| Field | Type    | NUll | Key | Default | Extra          |
+-------+---------+------+-----+---------+----------------+
| pid   | int(11) | NO   | PRI | Null    | AUTO_INCREMENT |
| rid   | int(11) | NO   |     | Null    |                |
| rid   | int(11) | NO   |     | Null    |                |
+-------+---------+------+-----+---------+----------------+

tbl:l
+-------+--------------+------+-----+---------+----------------+
| Field | Type         | NUll | Key | Default | Extra          |
+-------+--------------+------+-----+---------+----------------+
| lid   | int(11)      | NO   | PRI | Null    | AUTO_INCREMENT |
| name  | varchar(100) | NO   |     | Null    |                |
+-------+--------------+------+-----+---------+----------------+

tbl:edited
+-------+---------------+------+-----+---------+----------------+
| Field | Type          | NUll | Key | Default | Extra          |
+-------+---------------+------+-----+---------+----------------+
| id    | int(11)       | NO   | PRI | Null    | AUTO_INCREMENT |
| rid   | int(11)       | NO   |     | Null    |                |
| uid   | int(11)       | NO   |     | Null    |                |
| date  | datetime      | NO   |     | Null    |                |
+-------+---------------+------+-----+---------+----------------+