I have inherited maintaining and extending SQL Power Architect projects in source control which are used to generate the DDL for project DB schemas. We are currently using PostgreSQL 9.5 and SQL Power Architect 1.0.8. (We are using SQL Power Architect to attempt to keep the schema DB-agnostic, in the event the project will eventually migrate to a different type of DB.)
If it is possible to specify UUID columns (aka GUIDs) in Power Architect for table schemas we generate, can anyone tell me which Type needs to specified for the column property of those provided in the Power Architect UI's type list? (ARRAY, DISTINCT, LONGNVARCHAR/LONGVARCHAR, VARCHAR/NVARCHAR, OTHER, UNKNOWN, etc.) Do any of these equate to/generate a UUID column?