Tik-76.115 Tietokanta

Mobile1

Taulut

+----------------------+
|        Tables        |
+----------------------+
| ad                   |
| ad_location_relation |
| advertiser           |
| advertiser_location  |
| authentication       |
| log                  |
| rule                 |
| rule_field           |
| rule_property        |
| rule_request_text    |
+----------------------+

ad

+---------------+-----------+------+-----+---------+----------------+---------------------------------+
| Field         | Type      | Null | Key | Default | Extra          | Privileges                      |
+---------------+-----------+------+-----+---------+----------------+---------------------------------+
| id            | int(11)   |      | PRI |         | auto_increment | select,insert,update,references |
| valid_time    | date      | YES  |     |         |                | select,insert,update,references |
| content       | char(254) | YES  |     |         |                | select,insert,update,references |
| rule_id       | int(11)   | YES  |     |         |                | select,insert,update,references |
| advertiser_id | int(11)   | YES  |     |         |                | select,insert,update,references |
+---------------+-----------+------+-----+---------+----------------+---------------------------------+

ad_location_relation

+-------------+---------+------+-----+---------+-------+---------------------------------+
| Field       | Type    | Null | Key | Default | Extra | Privileges                      |
+-------------+---------+------+-----+---------+-------+---------------------------------+
| ad_id       | int(11) | YES  |     | NULL    |       | select,insert,update,references |
| location_id | int(11) | YES  |     | NULL    |       | select,insert,update,references |
+-------------+---------+------+-----+---------+-------+---------------------------------+

advertiser

+-------+-----------+------+-----+---------+----------------+---------------------------------+
| Field | Type      | Null | Key | Default | Extra          | Privileges                      |
+-------+-----------+------+-----+---------+----------------+---------------------------------+
| id    | int(11)   |      | PRI |         | auto_increment | select,insert,update,references |
| name  | char(254) | YES  |     |         |                | select,insert,update,references |
+-------+-----------+------+-----+---------+----------------+---------------------------------+

advertiser_location

+---------------+-----------+------+-----+---------+----------------+---------------------------------+
| Field         | Type      | Null | Key | Default | Extra          | Privileges                      |
+---------------+-----------+------+-----+---------+----------------+---------------------------------+
| id            | int(11)   |      | PRI | NULL    | auto_increment | select,insert,update,references |
| name          | char(254) | YES  |     | NULL    |                | select,insert,update,references |
| description   | char(254) | YES  |     | NULL    |                | select,insert,update,references |
| distance      | int(11)   | YES  |     | NULL    |                | select,insert,update,references |
| advertiser_id | int(11)   | YES  |     | NULL    |                | select,insert,update,references |
| LON           | double    | YES  |     | NULL    |                | select,insert,update,references |
| LAT           | double    | YES  |     | NULL    |                | select,insert,update,references |
+---------------+-----------+------+-----+---------+----------------+---------------------------------+

authentication

+-------+-----------+------+-----+---------+----------------+---------------------------------+
| Field | Type      | Null | Key | Default | Extra          | Privileges                      |
+-------+-----------+------+-----+---------+----------------+---------------------------------+
| id    | int(11)   |      | PRI | NULL    | auto_increment | select,insert,update,references |
| uid   | char(254) | YES  |     | NULL    |                | select,insert,update,references |
| pwd   | char(254) | YES  |     | NULL    |                | select,insert,update,references |
+-------+-----------+------+-----+---------+----------------+---------------------------------+

log

+---------+---------+------+-----+---------+----------------+---------------------------------+
| Field   | Type    | Null | Key | Default | Extra          | Privileges                      |
+---------+---------+------+-----+---------+----------------+---------------------------------+
| id      | int(11) |      | PRI | NULL    | auto_increment | select,insert,update,references |
| ad_id   | int(11) | YES  |     | NULL    |                | select,insert,update,references |
| time    | date    | YES  |     | NULL    |                | select,insert,update,references |
| rule_id | int(11) | YES  |     | NULL    |                | select,insert,update,references |
| LON     | double  | YES  |     | NULL    |                | select,insert,update,references |
| LAT     | double  | YES  |     | NULL    |                | select,insert,update,references |
+---------+---------+------+-----+---------+----------------+---------------------------------+

rule

+-------+-----------+------+-----+---------+----------------+---------------------------------+
| Field | Type      | Null | Key | Default | Extra          | Privileges                      |
+-------+-----------+------+-----+---------+----------------+---------------------------------+
| id    | int(11)   |      | PRI | NULL    | auto_increment | select,insert,update,references |
| ad_id | int(11)   | YES  |     | NULL    |                | select,insert,update,references |
| info  | char(254) | YES  |     | NULL    |                | select,insert,update,references |
+-------+-----------+------+-----+---------+----------------+---------------------------------+

rule_field

+-------+-----------+------+-----+---------+----------------+---------------------------------+
| Field | Type      | Null | Key | Default | Extra          | Privileges                      |
+-------+-----------+------+-----+---------+----------------+---------------------------------+
| id    | int(11)   |      | PRI | NULL    | auto_increment | select,insert,update,references |
| name  | char(254) | YES  |     | NULL    |                | select,insert,update,references |
| info  | char(254) | YES  |     | NULL    |                | select,insert,update,references |
| min   | int(11)   | YES  |     | NULL    |                | select,insert,update,references |
| max   | int(11)   | YES  |     | NULL    |                | select,insert,update,references |
+-------+-----------+------+-----+---------+----------------+---------------------------------+

rule_property

+----------+---------+------+-----+---------+-------+---------------------------------+
| Field    | Type    | Null | Key | Default | Extra | Privileges                      |
+----------+---------+------+-----+---------+-------+---------------------------------+
| rule_id  | int(11) | YES  |     | NULL    |       | select,insert,update,references |
| field_id | int(11) | YES  |     | NULL    |       | select,insert,update,references |
| min      | int(11) | YES  |     | NULL    |       | select,insert,update,references |
| max      | int(11) | YES  |     | NULL    |       | select,insert,update,references |
+----------+---------+------+-----+---------+-------+---------------------------------+

rule_request_text

+---------+-----------+------+-----+---------+-------+---------------------------------+
| Field   | Type      | Null | Key | Default | Extra | Privileges                      |
+---------+-----------+------+-----+---------+-------+---------------------------------+
| rule_id | int(11)   | YES  |     | NULL    |       | select,insert,update,references |
| text    | char(254) | YES  |     | NULL    |       | select,insert,update,references |
+---------+-----------+------+-----+---------+-------+---------------------------------+