Adding more information, The reason for the DATA_TYPE column is,
1. As mentioned earlier, if the DATA_TYPE is TEXT the resource value is stored in the VARCHAR column else it will be stored in the BLOB column 2. In the case of images we need to know the specific MIME type in order to render in the UI so we need to store those specifically On 3 November 2016 at 16:01, Uvindra Dias Jayasinha <[email protected]> wrote: > Hi All, > > Currently APIs have a few resources such as Swagger File, Optional WSDL > file, Related Documents file and an Optional Thumbnail image that needs to > be stored as blobs in the DB. > > Initially we thought of having separate tables to store these resources, > but what if we have a single generic resource table to store all these? > > We could have schema such as below for the generic resource table > > > Since we previously stored our resources in the registry, a similar > generic schema was used to store all such resources by the registry itself. > So anything that is not a text data type can be considered as a BLOB. > > The advantages of doing this are, > > 1. Can manage all API related resources from a central table without > having to define custom tables for each resource. > > 2. When an API is deleted its very easy to locate and remove all the > resources related with it > > 3. When a new version of an API is created its very easy to copy over the > resources associated with the previous version to the new one. > > WDYT? > > > -- > Regards, > Uvindra > > Mobile: 777733962 > -- Regards, Uvindra Mobile: 777733962
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
