{
   "columns" : {
      "downloads/created_at" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : null,
         "COLUMN_NAME" : "created_at",
         "COLUMN_TYPE" : "datetime",
         "EXTRA" : "",
         "IS_NULLABLE" : "NO",
         "ORDINAL_POSITION" : 3,
         "TABLE_NAME" : "downloads",
         "key_col" : "downloads/created_at"
      },
      "downloads/expires_at" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "expires_at",
         "COLUMN_TYPE" : "datetime",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 6,
         "TABLE_NAME" : "downloads",
         "key_col" : "downloads/expires_at"
      },
      "downloads/id" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_bin",
         "COLUMN_DEFAULT" : "''",
         "COLUMN_NAME" : "id",
         "COLUMN_TYPE" : "char(36)",
         "EXTRA" : "",
         "IS_NULLABLE" : "NO",
         "ORDINAL_POSITION" : 1,
         "TABLE_NAME" : "downloads",
         "key_col" : "downloads/id"
      },
      "downloads/state" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "'NEW'",
         "COLUMN_NAME" : "state",
         "COLUMN_TYPE" : "enum('NEW','DOWNLOADED')",
         "EXTRA" : "",
         "IS_NULLABLE" : "NO",
         "ORDINAL_POSITION" : 2,
         "TABLE_NAME" : "downloads",
         "key_col" : "downloads/state"
      },
      "downloads/updated_at" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : null,
         "COLUMN_NAME" : "updated_at",
         "COLUMN_TYPE" : "datetime",
         "EXTRA" : "",
         "IS_NULLABLE" : "NO",
         "ORDINAL_POSITION" : 4,
         "TABLE_NAME" : "downloads",
         "key_col" : "downloads/updated_at"
      },
      "downloads/upload_id" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_bin",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "upload_id",
         "COLUMN_TYPE" : "char(36)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 5,
         "TABLE_NAME" : "downloads",
         "key_col" : "downloads/upload_id"
      },
      "sessions/created_at" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : null,
         "COLUMN_NAME" : "created_at",
         "COLUMN_TYPE" : "datetime",
         "EXTRA" : "",
         "IS_NULLABLE" : "NO",
         "ORDINAL_POSITION" : 3,
         "TABLE_NAME" : "sessions",
         "key_col" : "sessions/created_at"
      },
      "sessions/expires_at" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "expires_at",
         "COLUMN_TYPE" : "datetime",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 5,
         "TABLE_NAME" : "sessions",
         "key_col" : "sessions/expires_at"
      },
      "sessions/id" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_bin",
         "COLUMN_DEFAULT" : "''",
         "COLUMN_NAME" : "id",
         "COLUMN_TYPE" : "char(36)",
         "EXTRA" : "",
         "IS_NULLABLE" : "NO",
         "ORDINAL_POSITION" : 1,
         "TABLE_NAME" : "sessions",
         "key_col" : "sessions/id"
      },
      "sessions/ttl" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "ttl",
         "COLUMN_TYPE" : "int(11)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 2,
         "TABLE_NAME" : "sessions",
         "key_col" : "sessions/ttl"
      },
      "sessions/updated_at" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : null,
         "COLUMN_NAME" : "updated_at",
         "COLUMN_TYPE" : "datetime",
         "EXTRA" : "",
         "IS_NULLABLE" : "NO",
         "ORDINAL_POSITION" : 4,
         "TABLE_NAME" : "sessions",
         "key_col" : "sessions/updated_at"
      },
      "uploads/created_at" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : null,
         "COLUMN_NAME" : "created_at",
         "COLUMN_TYPE" : "datetime",
         "EXTRA" : "",
         "IS_NULLABLE" : "NO",
         "ORDINAL_POSITION" : 8,
         "TABLE_NAME" : "uploads",
         "key_col" : "uploads/created_at"
      },
      "uploads/data" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "data",
         "COLUMN_TYPE" : "longblob",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 2,
         "TABLE_NAME" : "uploads",
         "key_col" : "uploads/data"
      },
      "uploads/expires_at" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "expires_at",
         "COLUMN_TYPE" : "datetime",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 11,
         "TABLE_NAME" : "uploads",
         "key_col" : "uploads/expires_at"
      },
      "uploads/id" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_bin",
         "COLUMN_DEFAULT" : "''",
         "COLUMN_NAME" : "id",
         "COLUMN_TYPE" : "char(36)",
         "EXTRA" : "",
         "IS_NULLABLE" : "NO",
         "ORDINAL_POSITION" : 1,
         "TABLE_NAME" : "uploads",
         "key_col" : "uploads/id"
      },
      "uploads/mime_type" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "mime_type",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 4,
         "TABLE_NAME" : "uploads",
         "key_col" : "uploads/mime_type"
      },
      "uploads/original_name" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "original_name",
         "COLUMN_TYPE" : "varchar(255)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 3,
         "TABLE_NAME" : "uploads",
         "key_col" : "uploads/original_name"
      },
      "uploads/reseller_id" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "reseller_id",
         "COLUMN_TYPE" : "int(10) unsigned",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 13,
         "TABLE_NAME" : "uploads",
         "key_col" : "uploads/reseller_id"
      },
      "uploads/session_id" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_bin",
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "session_id",
         "COLUMN_TYPE" : "char(36)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 10,
         "TABLE_NAME" : "uploads",
         "key_col" : "uploads/session_id"
      },
      "uploads/size" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "size",
         "COLUMN_TYPE" : "int(11)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 5,
         "TABLE_NAME" : "uploads",
         "key_col" : "uploads/size"
      },
      "uploads/state" : {
         "CHARACTER_SET_NAME" : "utf8mb3",
         "COLLATION_NAME" : "utf8mb3_general_ci",
         "COLUMN_DEFAULT" : "'NEW'",
         "COLUMN_NAME" : "state",
         "COLUMN_TYPE" : "enum('NEW','UPLOADED')",
         "EXTRA" : "",
         "IS_NULLABLE" : "NO",
         "ORDINAL_POSITION" : 7,
         "TABLE_NAME" : "uploads",
         "key_col" : "uploads/state"
      },
      "uploads/subscriber_id" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "subscriber_id",
         "COLUMN_TYPE" : "int(10) unsigned",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 12,
         "TABLE_NAME" : "uploads",
         "key_col" : "uploads/subscriber_id"
      },
      "uploads/ttl" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : "NULL",
         "COLUMN_NAME" : "ttl",
         "COLUMN_TYPE" : "int(11)",
         "EXTRA" : "",
         "IS_NULLABLE" : "YES",
         "ORDINAL_POSITION" : 6,
         "TABLE_NAME" : "uploads",
         "key_col" : "uploads/ttl"
      },
      "uploads/updated_at" : {
         "CHARACTER_SET_NAME" : null,
         "COLLATION_NAME" : null,
         "COLUMN_DEFAULT" : null,
         "COLUMN_NAME" : "updated_at",
         "COLUMN_TYPE" : "datetime",
         "EXTRA" : "",
         "IS_NULLABLE" : "NO",
         "ORDINAL_POSITION" : 9,
         "TABLE_NAME" : "uploads",
         "key_col" : "uploads/updated_at"
      }
   },
   "constraints" : {
      "downloads/downloads_ibfk_1/upload_id/uploads/id" : {
         "COLUMN_NAME" : "upload_id",
         "CONSTRAINT_NAME" : "downloads_ibfk_1",
         "DELETE_RULE" : "CASCADE",
         "REFERENCED_COLUMN_NAME" : "id",
         "REFERENCED_TABLE_NAME" : "uploads",
         "TABLE_NAME" : "downloads",
         "UPDATE_RULE" : "CASCADE",
         "key_col" : "downloads/downloads_ibfk_1/upload_id/uploads/id"
      },
      "uploads/u_reseller_id_ref/reseller_id/resellers/id" : {
         "COLUMN_NAME" : "reseller_id",
         "CONSTRAINT_NAME" : "u_reseller_id_ref",
         "DELETE_RULE" : "CASCADE",
         "REFERENCED_COLUMN_NAME" : "id",
         "REFERENCED_TABLE_NAME" : "resellers",
         "TABLE_NAME" : "uploads",
         "UPDATE_RULE" : "CASCADE",
         "key_col" : "uploads/u_reseller_id_ref/reseller_id/resellers/id"
      },
      "uploads/u_subscriber_id_ref/subscriber_id/voip_subscribers/id" : {
         "COLUMN_NAME" : "subscriber_id",
         "CONSTRAINT_NAME" : "u_subscriber_id_ref",
         "DELETE_RULE" : "CASCADE",
         "REFERENCED_COLUMN_NAME" : "id",
         "REFERENCED_TABLE_NAME" : "voip_subscribers",
         "TABLE_NAME" : "uploads",
         "UPDATE_RULE" : "CASCADE",
         "key_col" : "uploads/u_subscriber_id_ref/subscriber_id/voip_subscribers/id"
      },
      "uploads/uploads_ibfk_1/session_id/sessions/id" : {
         "COLUMN_NAME" : "session_id",
         "CONSTRAINT_NAME" : "uploads_ibfk_1",
         "DELETE_RULE" : "CASCADE",
         "REFERENCED_COLUMN_NAME" : "id",
         "REFERENCED_TABLE_NAME" : "sessions",
         "TABLE_NAME" : "uploads",
         "UPDATE_RULE" : "CASCADE",
         "key_col" : "uploads/uploads_ibfk_1/session_id/sessions/id"
      }
   },
   "indexes" : {
      "downloads/PRIMARY/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "id",
         "INDEX_NAME" : "PRIMARY",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 0,
         "NULLABLE" : "",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "downloads",
         "key_col" : "downloads/PRIMARY/1"
      },
      "downloads/downloads_expires_at/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "expires_at",
         "INDEX_NAME" : "downloads_expires_at",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "downloads",
         "key_col" : "downloads/downloads_expires_at/1"
      },
      "downloads/upload_id/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "upload_id",
         "INDEX_NAME" : "upload_id",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "downloads",
         "key_col" : "downloads/upload_id/1"
      },
      "sessions/PRIMARY/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "id",
         "INDEX_NAME" : "PRIMARY",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 0,
         "NULLABLE" : "",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sessions",
         "key_col" : "sessions/PRIMARY/1"
      },
      "sessions/sessions_expires_at/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "expires_at",
         "INDEX_NAME" : "sessions_expires_at",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "sessions",
         "key_col" : "sessions/sessions_expires_at/1"
      },
      "uploads/PRIMARY/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "id",
         "INDEX_NAME" : "PRIMARY",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 0,
         "NULLABLE" : "",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "uploads",
         "key_col" : "uploads/PRIMARY/1"
      },
      "uploads/reseller_id_idx/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "reseller_id",
         "INDEX_NAME" : "reseller_id_idx",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "uploads",
         "key_col" : "uploads/reseller_id_idx/1"
      },
      "uploads/session_id/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "session_id",
         "INDEX_NAME" : "session_id",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "uploads",
         "key_col" : "uploads/session_id/1"
      },
      "uploads/subscriber_id_idx/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "subscriber_id",
         "INDEX_NAME" : "subscriber_id_idx",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "uploads",
         "key_col" : "uploads/subscriber_id_idx/1"
      },
      "uploads/uploads_expires_at/1" : {
         "COLLATION" : "A",
         "COLUMN_NAME" : "expires_at",
         "INDEX_NAME" : "uploads_expires_at",
         "INDEX_TYPE" : "BTREE",
         "NON_UNIQUE" : 1,
         "NULLABLE" : "YES",
         "SEQ_IN_INDEX" : 1,
         "SUB_PART" : null,
         "TABLE_NAME" : "uploads",
         "key_col" : "uploads/uploads_expires_at/1"
      }
   },
   "routines" : {},
   "tables" : {
      "downloads" : {
         "CREATE_OPTIONS" : "",
         "ENGINE" : "InnoDB",
         "TABLE_COLLATION" : "utf8mb3_general_ci",
         "TABLE_NAME" : "downloads",
         "key_col" : "downloads"
      },
      "sessions" : {
         "CREATE_OPTIONS" : "",
         "ENGINE" : "InnoDB",
         "TABLE_COLLATION" : "utf8mb3_general_ci",
         "TABLE_NAME" : "sessions",
         "key_col" : "sessions"
      },
      "uploads" : {
         "CREATE_OPTIONS" : "",
         "ENGINE" : "InnoDB",
         "TABLE_COLLATION" : "utf8mb3_general_ci",
         "TABLE_NAME" : "uploads",
         "key_col" : "uploads"
      }
   },
   "triggers" : {},
   "views" : {}
}
