|
|
| Line 16: |
Line 16: |
| | [[Dialog database api|Dialog database api]] | | [[Dialog database api|Dialog database api]] |
| | | | |
| − | ==== Structure ====
| |
| − | Database structuur
| |
| | | | |
| − | <table>
| |
| − | <tr><th>'''''Sentence'''''</th></tr>
| |
| − | <tr><th align="left" >id</th> <td align="left">Int</td> <td align="left">Unique identification number</td></tr>
| |
| − | <tr><th align="left">sentence</th> <td align="left">String</td> <td align="left">Sentence string (text)</td></tr>
| |
| − | <tr><td>-----------</td></tr>
| |
| − | <tr><th>'''''Link'''''</th></tr>
| |
| − | <tr><th align="left">reply_to_sentence</th><td align="left">Int</td><td align="left">Sentence id identifying the sentence replied to</td></tr>
| |
| − | <tr><th align="left">Reply_sentence</th><td align="left">int</td><td align="left">Sentence id identifying the sentence reply</td></tr>
| |
| − | <tr><th align="left">order</th> <td align="left"> int</td> <td align="left">Sentence position in reply list</td></tr>
| |
| − | <tr><td>-----------</td></tr>
| |
| − | <tr><th>'''''Property'''''</th></tr>
| |
| − | <tr><th align="left">id</th> <td align="left"> Int</td> <td align="left"> Unique identification number</td></tr>
| |
| − | <tr><th align="left">name</th> <td align="left"> String</td> <td align="left"> Property name</td></tr>
| |
| − | <tr><th align="left">show</th> <td align="left"> Int</td> <td align="left"> Enable/disable property in database</td></tr>
| |
| − | <tr><td>-----------</td></tr>
| |
| − | <tr><th>'''''Property_list'''''</th></tr>
| |
| − | <tr><th align="left">property_id</th><td align="left">Int</td><td align="left">Property id indentifying the property</td></tr>
| |
| − | <tr><th align="left">sentence_id</th><td align="left">Int</td><td align="left">Sentence id indentifying the sentence</td></tr>
| |
| − | <tr><th align="left">value</th> <td align="left">String</td><td align="left">Value of the property</td></tr>
| |
| − | <tr><td>-----------</td></tr>
| |
| − | <tr><th>'''''Action'''''</th></tr>
| |
| − | <tr><th align="left">id</th> <td align="left"> Int</td> <td align="left"> Unique identification number</td></tr>
| |
| − | <tr><th align="left">action</th> <td align="left"> String</td> <td align="left"> Action string</td></tr>
| |
| − | <tr><td>-----------</td></tr>
| |
| − | <tr><th>'''''Action_list'''''</th></tr>
| |
| − | <tr><th align="left">action_id</th><td align="left">Int</td><td align="left">Action id indentifying the Action</td></tr>
| |
| − | <tr><th align="left">sentence_id</th><td align="left">Int</td><td align="left"> Sentence id indentifying the Sentence</td></tr>
| |
| − | <tr><th align="left">order</th><td align="left">Int</td><td align="left">Action position in action list</td></tr>
| |
| − | <tr><th align="left">kind</th><td align="left">Int</td><td align="left">Identifying if the action is a pre or post action</td></tr>
| |
| − | </table>
| |
| − |
| |
| − | Notes:
| |
| − | Default properties already available in the database are:
| |
| − | * audio_url (default = “”)
| |
| − | * avatar_type (default = “”)
| |
| − | * is_root (default=”0”)
| |
| − |
| |
| − |
| |
| − | Orders of sentences or actions are not forced to be unique so multiple sentences can be placed on the same order number the real order of the data in the list will be unknown then.
| |
| − |
| |
| − | Id’s will be automatically generated by the database and can’t be manipulated
| |
| − |
| |
| − | Action Kind will be 0 = PreAction and 1 = PostAction
| |
| − |
| |
| − | Property show will be 0 = Disabled and 1 = Enabled. When disabled property will not be added to property list of sentences
| |
| | | | |
| | === Download === | | === Download === |
