Layer7 API Management

  • Private Community

  • 1.  OTK Database Schema Relationship

    Posted Jul 15, 2018 01:15 PM

    Hi There,

    Is there any diagram for OTK  tables details?If so could you pls share over here.



  • 2.  Re: OTK

    Posted Jul 16, 2018 07:44 PM

    Hi There,

     

    Please have a look at the otk_db_schema SQL statements that are used when creating the OTK DB and let us know if this is what you are looking for.

     

    Those scripts are inside the OTK Installer compressed file.

     

    Hope this helps,

     

    Regards,

    Amit.



  • 3.  Re: OTK

    Posted Jul 16, 2018 09:58 PM

    Thanks for your response. Am precisely looking for all the tables relationship and contain what type of data in each table. For example, issued access token would store in tableA and scope are stored in tableB. Looking something like that relation.



  • 4.  Re: OTK

    Broadcom Employee
    Posted Dec 14, 2018 01:26 PM
      |   view attached

    Good morning,

     

    Using the MySQL Workbench reverse engineer function, I've extracted out the schema into a relationship diagram that I have attached. As this can change from time to time, the attachment is from a 4.2 OTK MySQL database schema.

     

    Sincerely,

     

    Stephen Hughes

    Broadcom Support

    Attachment(s)

    pdf
    otk_db_relationship.pdf   36 KB 1 version