Branch information in Bitbucket MSSQL Database?

I want to get all the branch information using MSSQL query.
I checked below tables

  1. sta_pull_request
  2. AO_616D7B_BRANCH_MODEL
  3. AO_616D7B_BRANCH_MODEL_CONFIG
  4. AO_616D7B_BRANCH_TYPE
  5. AO_616D7B_BRANCH_TYPE_CONFIG
  6. repository

and did not find the branch information. If anyone could provide table information will be helpful.

Thanks
D

Please clarify what information you are trying to pull out. It’s quite likely that much of this information is not persisted in the Database because its persisted in git itself. Since storing state in two spots at once has many problems, I suspect that the developers did not do that.

I am looking for all the branch names and their repository name in the bitbucket.

I am also looking for Plan Name in Bamboo DB and how to merge these database relation to show them in tableau. Currently I am using the BUILD KEY to merge them.

@sfbehnke - I am looking for list of repositories names and their branch names.