{"swagger":"2.0","info":{"title":"bitnami_redmine","description":"API generated with [PHP-CRUD-API](https://github.com/mevdschee/php-crud-api)","version":"1.0.0"},"host":"dream.sysnec.com.br","basePath":"/api.php","schemes":["https"],"consumes":["application/json"],"produces":["application/json"],"tags":[{"name":"projects","description":""},{"name":"projects_mtime","description":""},{"name":"time_entries","description":""}],"paths":{"/projects":{"get":{"tags":["projects"],"summary":"List","parameters":[{"name":"exclude","in":"query","description":"One or more related entities (comma separated).","required":false,"type":"string"},{"name":"include","in":"query","description":"One or more related entities (comma separated).","required":false,"type":"string"},{"name":"order","in":"query","description":"Column you want to sort on and the sort direction (comma separated). Example: id,desc","required":false,"type":"string"},{"name":"page","in":"query","description":"Page number and page size (comma separated). NB: You cannot use \"page\" without \"order\"! Example: 1,10","required":false,"type":"string"},{"name":"transform","in":"query","description":"Transform the records to object format. NB: This can also be done client-side in JavaScript!","required":false,"type":"boolean"},{"name":"columns","in":"query","description":"The table columns you want to retrieve (comma separated). Example: posts.*,categories.name","required":false,"type":"string"},{"name":"filter[]","in":"query","description":"Filters to be applied. Each filter consists of a column, an operator and a value (comma separated). Example: id,eq,1","required":false,"type":"array","collectionFormat":"multi","items":{"type":"string"}},{"name":"satisfy","in":"query","description":"Should all filters match (default)? Or any?","required":false,"type":"string","enum":["any"]}],"responses":{"200":{"description":"An array of projects","schema":{"type":"array","items":{"type": "object","properties": {"id": {"type": "integer","x-dbtype": "int","x-nullable": false,"x-referenced": [["projects_mtimes","project_id"]],"x-primary-key": true},"name": {"type": "string","x-dbtype": "varchar","x-nullable": false,"maxLength": 255,"default": ""},"description": {"type": "string","x-dbtype": "text","x-nullable": true,"maxLength": 65535},"homepage": {"type": "string","x-dbtype": "varchar","x-nullable": true,"maxLength": 255,"default": ""},"is_public": {"type": "integer","x-dbtype": "tinyint","x-nullable": false,"default": 1},"parent_id": {"type": "integer","x-dbtype": "int","x-nullable": true},"created_on": {"type": "string","x-dbtype": "datetime","x-nullable": true},"updated_on": {"type": "string","x-dbtype": "datetime","x-nullable": true},"identifier": {"type": "string","x-dbtype": "varchar","x-nullable": true,"maxLength": 255},"status": {"type": "integer","x-dbtype": "int","x-nullable": false,"default": 1},"lft": {"type": "integer","x-dbtype": "int","x-nullable": true},"rgt": {"type": "integer","x-dbtype": "int","x-nullable": true},"inherit_members": {"type": "integer","x-dbtype": "tinyint","x-nullable": false,"default": 0},"default_version_id": {"type": "integer","x-dbtype": "int","x-nullable": true}}}}}}},"post":{"tags":["projects"],"summary":"Create","parameters":[{"name":"item","in":"body","description":"Item to create.","required":true,"schema":{"type": "object","required":["id"],"properties": {"id": {"type": "integer","x-dbtype": "int","x-nullable": false,"x-referenced": [["projects_mtimes","project_id"]],"x-primary-key": true},"name": {"type": "string","x-dbtype": "varchar","x-nullable": false,"maxLength": 255,"default": ""},"description": {"type": "string","x-dbtype": "text","x-nullable": true,"maxLength": 65535},"homepage": {"type": "string","x-dbtype": "varchar","x-nullable": true,"maxLength": 255,"default": ""},"is_public": {"type": "integer","x-dbtype": "tinyint","x-nullable": false,"default": 1},"parent_id": {"type": "integer","x-dbtype": "int","x-nullable": true},"created_on": {"type": "string","x-dbtype": "datetime","x-nullable": true},"updated_on": {"type": "string","x-dbtype": "datetime","x-nullable": true},"identifier": {"type": "string","x-dbtype": "varchar","x-nullable": true,"maxLength": 255},"status": {"type": "integer","x-dbtype": "int","x-nullable": false,"default": 1},"lft": {"type": "integer","x-dbtype": "int","x-nullable": true},"rgt": {"type": "integer","x-dbtype": "int","x-nullable": true},"inherit_members": {"type": "integer","x-dbtype": "tinyint","x-nullable": false,"default": 0},"default_version_id": {"type": "integer","x-dbtype": "int","x-nullable": true}}}}],"responses":{"200":{"description":"Identifier of created item.","schema":{"type":"integer"}}}}},"/projects/{id}":{"get":{"tags":["projects"],"summary":"Read","parameters":[{"name":"id","in":"path","description":"Identifier for item.","required":true,"type":"string"}],"responses":{"200":{"description":"The requested item.","schema":{"type": "object","properties": {"id": {"type": "integer","x-dbtype": "int","x-nullable": false,"x-referenced": [["projects_mtimes","project_id"]],"x-primary-key": true},"name": {"type": "string","x-dbtype": "varchar","x-nullable": false,"maxLength": 255,"default": ""},"description": {"type": "string","x-dbtype": "text","x-nullable": true,"maxLength": 65535},"homepage": {"type": "string","x-dbtype": "varchar","x-nullable": true,"maxLength": 255,"default": ""},"is_public": {"type": "integer","x-dbtype": "tinyint","x-nullable": false,"default": 1},"parent_id": {"type": "integer","x-dbtype": "int","x-nullable": true},"created_on": {"type": "string","x-dbtype": "datetime","x-nullable": true},"updated_on": {"type": "string","x-dbtype": "datetime","x-nullable": true},"identifier": {"type": "string","x-dbtype": "varchar","x-nullable": true,"maxLength": 255},"status": {"type": "integer","x-dbtype": "int","x-nullable": false,"default": 1},"lft": {"type": "integer","x-dbtype": "int","x-nullable": true},"rgt": {"type": "integer","x-dbtype": "int","x-nullable": true},"inherit_members": {"type": "integer","x-dbtype": "tinyint","x-nullable": false,"default": 0},"default_version_id": {"type": "integer","x-dbtype": "int","x-nullable": true}}}}}},"put":{"tags":["projects"],"summary":"Update","parameters":[{"name":"id","in":"path","description":"Identifier for item.","required":true,"type":"string"},{"name":"item","in":"body","description":"Properties of item to update.","required":true,"schema":{"type": "object","required":["id"],"properties": {"id": {"type": "integer","x-dbtype": "int","x-nullable": false,"x-referenced": [["projects_mtimes","project_id"]],"x-primary-key": true},"name": {"type": "string","x-dbtype": "varchar","x-nullable": false,"maxLength": 255,"default": ""},"description": {"type": "string","x-dbtype": "text","x-nullable": true,"maxLength": 65535},"homepage": {"type": "string","x-dbtype": "varchar","x-nullable": true,"maxLength": 255,"default": ""},"is_public": {"type": "integer","x-dbtype": "tinyint","x-nullable": false,"default": 1},"parent_id": {"type": "integer","x-dbtype": "int","x-nullable": true},"created_on": {"type": "string","x-dbtype": "datetime","x-nullable": true},"updated_on": {"type": "string","x-dbtype": "datetime","x-nullable": true},"identifier": {"type": "string","x-dbtype": "varchar","x-nullable": true,"maxLength": 255},"status": {"type": "integer","x-dbtype": "int","x-nullable": false,"default": 1},"lft": {"type": "integer","x-dbtype": "int","x-nullable": true},"rgt": {"type": "integer","x-dbtype": "int","x-nullable": true},"inherit_members": {"type": "integer","x-dbtype": "tinyint","x-nullable": false,"default": 0},"default_version_id": {"type": "integer","x-dbtype": "int","x-nullable": true}}}}],"responses":{"200":{"description":"Number of affected rows.","schema":{"type":"integer"}}}},"delete":{"tags":["projects"],"summary":"Delete","parameters":[{"name":"id","in":"path","description":"Identifier for item.","required":true,"type":"string"}],"responses":{"200":{"description":"Number of affected rows.","schema":{"type":"integer"}}}},"patch":{"tags":["projects"],"summary":"Increment","parameters":[{"name":"id","in":"path","description":"Identifier for item.","required":true,"type":"string"},{"name":"item","in":"body","description":"Properties of item to update.","required":true,"schema":{"type": "object","required":["id"],"properties": {"id": {"type": "integer","x-dbtype": "int","x-nullable": false,"x-referenced": [["projects_mtimes","project_id"]],"x-primary-key": true},"name": {"type": "string","x-dbtype": "varchar","x-nullable": false,"maxLength": 255,"default": ""},"description": {"type": "string","x-dbtype": "text","x-nullable": true,"maxLength": 65535},"homepage": {"type": "string","x-dbtype": "varchar","x-nullable": true,"maxLength": 255,"default": ""},"is_public": {"type": "integer","x-dbtype": "tinyint","x-nullable": false,"default": 1},"parent_id": {"type": "integer","x-dbtype": "int","x-nullable": true},"created_on": {"type": "string","x-dbtype": "datetime","x-nullable": true},"updated_on": {"type": "string","x-dbtype": "datetime","x-nullable": true},"identifier": {"type": "string","x-dbtype": "varchar","x-nullable": true,"maxLength": 255},"status": {"type": "integer","x-dbtype": "int","x-nullable": false,"default": 1},"lft": {"type": "integer","x-dbtype": "int","x-nullable": true},"rgt": {"type": "integer","x-dbtype": "int","x-nullable": true},"inherit_members": {"type": "integer","x-dbtype": "tinyint","x-nullable": false,"default": 0},"default_version_id": {"type": "integer","x-dbtype": "int","x-nullable": true}}}}],"responses":{"200":{"description":"Number of affected rows.","schema":{"type":"integer"}}}}},"/projects_mtime":{"get":{"tags":["projects_mtime"],"summary":"List","parameters":[{"name":"exclude","in":"query","description":"One or more related entities (comma separated).","required":false,"type":"string"},{"name":"include","in":"query","description":"One or more related entities (comma separated).","required":false,"type":"string"},{"name":"order","in":"query","description":"Column you want to sort on and the sort direction (comma separated). Example: id,desc","required":false,"type":"string"},{"name":"page","in":"query","description":"Page number and page size (comma separated). NB: You cannot use \"page\" without \"order\"! Example: 1,10","required":false,"type":"string"},{"name":"transform","in":"query","description":"Transform the records to object format. NB: This can also be done client-side in JavaScript!","required":false,"type":"boolean"},{"name":"columns","in":"query","description":"The table columns you want to retrieve (comma separated). Example: posts.*,categories.name","required":false,"type":"string"},{"name":"filter[]","in":"query","description":"Filters to be applied. Each filter consists of a column, an operator and a value (comma separated). Example: id,eq,1","required":false,"type":"array","collectionFormat":"multi","items":{"type":"string"}},{"name":"satisfy","in":"query","description":"Should all filters match (default)? Or any?","required":false,"type":"string","enum":["any"]}],"responses":{"200":{"description":"An array of projects_mtime","schema":{"type":"array","items":{"type": "object","properties": {"project_id": {"type": "integer","x-dbtype": "int","x-nullable": false,"default": 0,"x-primary-key": true},"month": {"type": "integer","x-dbtype": "int","x-nullable": false,"default": 1,"x-primary-key": true},"year": {"type": "integer","x-dbtype": "int","x-nullable": false,"default": 2015,"x-primary-key": true},"hours_ant": {"type": "integer","x-dbtype": "int","x-nullable": false,"default": 0},"hours": {"type": "string","x-dbtype": "decimal","x-nullable": false,"default": "0.0"}}}}}}},"post":{"tags":["projects_mtime"],"summary":"Create","parameters":[{"name":"item","in":"body","description":"Item to create.","required":true,"schema":{"type": "object","properties": {"project_id": {"type": "integer","x-dbtype": "int","x-nullable": false,"default": 0,"x-primary-key": true},"month": {"type": "integer","x-dbtype": "int","x-nullable": false,"default": 1,"x-primary-key": true},"year": {"type": "integer","x-dbtype": "int","x-nullable": false,"default": 2015,"x-primary-key": true},"hours_ant": {"type": "integer","x-dbtype": "int","x-nullable": false,"default": 0},"hours": {"type": "string","x-dbtype": "decimal","x-nullable": false,"default": "0.0"}}}}],"responses":{"200":{"description":"Identifier of created item.","schema":{"type":"integer"}}}}},"/projects_mtime/{id}":{"get":{"tags":["projects_mtime"],"summary":"Read","parameters":[{"name":"id","in":"path","description":"Identifier for item.","required":true,"type":"string"}],"responses":{"200":{"description":"The requested item.","schema":{"type": "object","properties": {"project_id": {"type": "integer","x-dbtype": "int","x-nullable": false,"default": 0,"x-primary-key": true},"month": {"type": "integer","x-dbtype": "int","x-nullable": false,"default": 1,"x-primary-key": true},"year": {"type": "integer","x-dbtype": "int","x-nullable": false,"default": 2015,"x-primary-key": true},"hours_ant": {"type": "integer","x-dbtype": "int","x-nullable": false,"default": 0},"hours": {"type": "string","x-dbtype": "decimal","x-nullable": false,"default": "0.0"}}}}}},"put":{"tags":["projects_mtime"],"summary":"Update","parameters":[{"name":"id","in":"path","description":"Identifier for item.","required":true,"type":"string"},{"name":"item","in":"body","description":"Properties of item to update.","required":true,"schema":{"type": "object","properties": {"project_id": {"type": "integer","x-dbtype": "int","x-nullable": false,"default": 0,"x-primary-key": true},"month": {"type": "integer","x-dbtype": "int","x-nullable": false,"default": 1,"x-primary-key": true},"year": {"type": "integer","x-dbtype": "int","x-nullable": false,"default": 2015,"x-primary-key": true},"hours_ant": {"type": "integer","x-dbtype": "int","x-nullable": false,"default": 0},"hours": {"type": "string","x-dbtype": "decimal","x-nullable": false,"default": "0.0"}}}}],"responses":{"200":{"description":"Number of affected rows.","schema":{"type":"integer"}}}},"delete":{"tags":["projects_mtime"],"summary":"Delete","parameters":[{"name":"id","in":"path","description":"Identifier for item.","required":true,"type":"string"}],"responses":{"200":{"description":"Number of affected rows.","schema":{"type":"integer"}}}},"patch":{"tags":["projects_mtime"],"summary":"Increment","parameters":[{"name":"id","in":"path","description":"Identifier for item.","required":true,"type":"string"},{"name":"item","in":"body","description":"Properties of item to update.","required":true,"schema":{"type": "object","properties": {"project_id": {"type": "integer","x-dbtype": "int","x-nullable": false,"default": 0,"x-primary-key": true},"month": {"type": "integer","x-dbtype": "int","x-nullable": false,"default": 1,"x-primary-key": true},"year": {"type": "integer","x-dbtype": "int","x-nullable": false,"default": 2015,"x-primary-key": true},"hours_ant": {"type": "integer","x-dbtype": "int","x-nullable": false,"default": 0},"hours": {"type": "string","x-dbtype": "decimal","x-nullable": false,"default": "0.0"}}}}],"responses":{"200":{"description":"Number of affected rows.","schema":{"type":"integer"}}}}},"/time_entries":{"get":{"tags":["time_entries"],"summary":"List","parameters":[{"name":"exclude","in":"query","description":"One or more related entities (comma separated).","required":false,"type":"string"},{"name":"include","in":"query","description":"One or more related entities (comma separated).","required":false,"type":"string"},{"name":"order","in":"query","description":"Column you want to sort on and the sort direction (comma separated). Example: id,desc","required":false,"type":"string"},{"name":"page","in":"query","description":"Page number and page size (comma separated). NB: You cannot use \"page\" without \"order\"! Example: 1,10","required":false,"type":"string"},{"name":"transform","in":"query","description":"Transform the records to object format. NB: This can also be done client-side in JavaScript!","required":false,"type":"boolean"},{"name":"columns","in":"query","description":"The table columns you want to retrieve (comma separated). Example: posts.*,categories.name","required":false,"type":"string"},{"name":"filter[]","in":"query","description":"Filters to be applied. Each filter consists of a column, an operator and a value (comma separated). Example: id,eq,1","required":false,"type":"array","collectionFormat":"multi","items":{"type":"string"}},{"name":"satisfy","in":"query","description":"Should all filters match (default)? Or any?","required":false,"type":"string","enum":["any"]}],"responses":{"200":{"description":"An array of time_entries","schema":{"type":"array","items":{"type": "object","properties": {"id": {"type": "integer","x-dbtype": "int","x-nullable": false,"x-primary-key": true},"project_id": {"type": "integer","x-dbtype": "int","x-nullable": false},"user_id": {"type": "integer","x-dbtype": "int","x-nullable": false},"issue_id": {"type": "integer","x-dbtype": "int","x-nullable": true},"hours": {"type": "number","x-dbtype": "float","x-nullable": false},"comments": {"type": "string","x-dbtype": "varchar","x-nullable": true,"maxLength": 1024},"activity_id": {"type": "integer","x-dbtype": "int","x-nullable": false},"spent_on": {"type": "string","x-dbtype": "date","x-nullable": false},"tyear": {"type": "integer","x-dbtype": "int","x-nullable": false},"tmonth": {"type": "integer","x-dbtype": "int","x-nullable": false},"tweek": {"type": "integer","x-dbtype": "int","x-nullable": false},"created_on": {"type": "string","x-dbtype": "datetime","x-nullable": false},"updated_on": {"type": "string","x-dbtype": "datetime","x-nullable": false}}}}}}},"post":{"tags":["time_entries"],"summary":"Create","parameters":[{"name":"item","in":"body","description":"Item to create.","required":true,"schema":{"type": "object","required":["id","project_id","user_id","hours","activity_id","spent_on","tyear","tmonth","tweek","created_on","updated_on"],"properties": {"id": {"type": "integer","x-dbtype": "int","x-nullable": false,"x-primary-key": true},"project_id": {"type": "integer","x-dbtype": "int","x-nullable": false},"user_id": {"type": "integer","x-dbtype": "int","x-nullable": false},"issue_id": {"type": "integer","x-dbtype": "int","x-nullable": true},"hours": {"type": "number","x-dbtype": "float","x-nullable": false},"comments": {"type": "string","x-dbtype": "varchar","x-nullable": true,"maxLength": 1024},"activity_id": {"type": "integer","x-dbtype": "int","x-nullable": false},"spent_on": {"type": "string","x-dbtype": "date","x-nullable": false},"tyear": {"type": "integer","x-dbtype": "int","x-nullable": false},"tmonth": {"type": "integer","x-dbtype": "int","x-nullable": false},"tweek": {"type": "integer","x-dbtype": "int","x-nullable": false},"created_on": {"type": "string","x-dbtype": "datetime","x-nullable": false},"updated_on": {"type": "string","x-dbtype": "datetime","x-nullable": false}}}}],"responses":{"200":{"description":"Identifier of created item.","schema":{"type":"integer"}}}}},"/time_entries/{id}":{"get":{"tags":["time_entries"],"summary":"Read","parameters":[{"name":"id","in":"path","description":"Identifier for item.","required":true,"type":"string"}],"responses":{"200":{"description":"The requested item.","schema":{"type": "object","properties": {"id": {"type": "integer","x-dbtype": "int","x-nullable": false,"x-primary-key": true},"project_id": {"type": "integer","x-dbtype": "int","x-nullable": false},"user_id": {"type": "integer","x-dbtype": "int","x-nullable": false},"issue_id": {"type": "integer","x-dbtype": "int","x-nullable": true},"hours": {"type": "number","x-dbtype": "float","x-nullable": false},"comments": {"type": "string","x-dbtype": "varchar","x-nullable": true,"maxLength": 1024},"activity_id": {"type": "integer","x-dbtype": "int","x-nullable": false},"spent_on": {"type": "string","x-dbtype": "date","x-nullable": false},"tyear": {"type": "integer","x-dbtype": "int","x-nullable": false},"tmonth": {"type": "integer","x-dbtype": "int","x-nullable": false},"tweek": {"type": "integer","x-dbtype": "int","x-nullable": false},"created_on": {"type": "string","x-dbtype": "datetime","x-nullable": false},"updated_on": {"type": "string","x-dbtype": "datetime","x-nullable": false}}}}}},"put":{"tags":["time_entries"],"summary":"Update","parameters":[{"name":"id","in":"path","description":"Identifier for item.","required":true,"type":"string"},{"name":"item","in":"body","description":"Properties of item to update.","required":true,"schema":{"type": "object","required":["id","project_id","user_id","hours","activity_id","spent_on","tyear","tmonth","tweek","created_on","updated_on"],"properties": {"id": {"type": "integer","x-dbtype": "int","x-nullable": false,"x-primary-key": true},"project_id": {"type": "integer","x-dbtype": "int","x-nullable": false},"user_id": {"type": "integer","x-dbtype": "int","x-nullable": false},"issue_id": {"type": "integer","x-dbtype": "int","x-nullable": true},"hours": {"type": "number","x-dbtype": "float","x-nullable": false},"comments": {"type": "string","x-dbtype": "varchar","x-nullable": true,"maxLength": 1024},"activity_id": {"type": "integer","x-dbtype": "int","x-nullable": false},"spent_on": {"type": "string","x-dbtype": "date","x-nullable": false},"tyear": {"type": "integer","x-dbtype": "int","x-nullable": false},"tmonth": {"type": "integer","x-dbtype": "int","x-nullable": false},"tweek": {"type": "integer","x-dbtype": "int","x-nullable": false},"created_on": {"type": "string","x-dbtype": "datetime","x-nullable": false},"updated_on": {"type": "string","x-dbtype": "datetime","x-nullable": false}}}}],"responses":{"200":{"description":"Number of affected rows.","schema":{"type":"integer"}}}},"delete":{"tags":["time_entries"],"summary":"Delete","parameters":[{"name":"id","in":"path","description":"Identifier for item.","required":true,"type":"string"}],"responses":{"200":{"description":"Number of affected rows.","schema":{"type":"integer"}}}},"patch":{"tags":["time_entries"],"summary":"Increment","parameters":[{"name":"id","in":"path","description":"Identifier for item.","required":true,"type":"string"},{"name":"item","in":"body","description":"Properties of item to update.","required":true,"schema":{"type": "object","required":["id","project_id","user_id","hours","activity_id","spent_on","tyear","tmonth","tweek","created_on","updated_on"],"properties": {"id": {"type": "integer","x-dbtype": "int","x-nullable": false,"x-primary-key": true},"project_id": {"type": "integer","x-dbtype": "int","x-nullable": false},"user_id": {"type": "integer","x-dbtype": "int","x-nullable": false},"issue_id": {"type": "integer","x-dbtype": "int","x-nullable": true},"hours": {"type": "number","x-dbtype": "float","x-nullable": false},"comments": {"type": "string","x-dbtype": "varchar","x-nullable": true,"maxLength": 1024},"activity_id": {"type": "integer","x-dbtype": "int","x-nullable": false},"spent_on": {"type": "string","x-dbtype": "date","x-nullable": false},"tyear": {"type": "integer","x-dbtype": "int","x-nullable": false},"tmonth": {"type": "integer","x-dbtype": "int","x-nullable": false},"tweek": {"type": "integer","x-dbtype": "int","x-nullable": false},"created_on": {"type": "string","x-dbtype": "datetime","x-nullable": false},"updated_on": {"type": "string","x-dbtype": "datetime","x-nullable": false}}}}],"responses":{"200":{"description":"Number of affected rows.","schema":{"type":"integer"}}}}}}}