I am interested in storing geometry attributes in a PostGis database, so that it would be OGC compliant, along with OGC compliant geometry types like point,line, linestring, etc. I also wanted to store some custom type geometry types like ellipse,circle,arrow,some symbols (also combinations of these types) etc, these custom geometry types have different attributes(entities).
Is it possible to store all these geometry in a Generic OGC compliant DataBase?
I'm using pdf file "URL:http://portal.opengeospatial.org/files/?artifact_id=829"(99-049_OpenGIS_Simple_Features_Specification_For_SQL_Rev_1.1.pdf) as a reference, and as per page 2-20, it appears like I can represent any kind of geometry using GEOMETRY_COLUMNS, SPATIAL_REFERENCE_SYSTEMS, FeatureTables and GEOMETRY_COLUMNS. But a lot of the geometries I have are custom created - like thick curved arrows with control points to allow a user to adjust the curvature of the arrow, and a text label at the center of the arrow, polygons with an X mark at the center of every edge and control points at certain points of the polygon to allow the user to resize it etc.
like i have n no:of item(custom_geometries like,arrow,symbols etc)each item has unique attributes. should i create multiple feature table for each item?