OSTicket API

sjaka80

Has there been any upgrades on the API front of the software, or it still supports only Ticket creation?Also, is there an ERD available for the database? Post installation, I've noticed that the tables don't have any relationships? Am I missing something?

ntozier

Q: Has there been any upgrades on the API front of the software, or it still supports only Ticket creation?A: There is a Cron and a Ticket API at this time. So I think the answer is No.Q: Also, is there an ERD available for the database?A: No.Q: Post installation, I've noticed that the tables don't have any relationships?A: This isn't a question.Q: Am I missing something?A: Sounds likely.

sjaka80

@[deleted] My apologies for the bad phrasing of the question. Kindly allow me to rephrase it.1. Inside the downloaded installation folder, inside the following path '..\upload\setup\inc\streams\core' there is a install-mysql.sql file. Is this the file that OSTicket uses to create OSTicket database?2. Does the OSTicket database has PK/FK relationships between the tables, since there is no foreign key constraint in the sql script?

ntozier

Q: Is this the file that OSTicket uses to create OSTicket database?A: Yes.Q: Does the OSTicket database has PK/FK relationships between the tables,

since there is no foreign key constraint in the sql script?A: ost_user table id column is the users id. If this was '1'.If you look at ost_user_account or ost_user_email the user_id field for said user would be '1'.

sjaka80

Thanks once again for your reply. This is correct. What confuses me is that there is no foreign key constraint in the SQL script. Is the data integrity handled programmatically, instead of relationships?