/* (Beta) Export of data model Camera of the subject dataModel.Device for a PostgreSQL database. Pending translation of enumerations and multityped attributes */

CREATE TYPE cameraType_type AS ENUM ('FIXED','PTZ','DOME','DAY/NIGHT','C-MOUNT','BULLET');CREATE TYPE Camera_type AS ENUM ('Camera');

CREATE TABLE Camera (address JSON, alternateName TEXT, areaServed TEXT, cameraName TEXT, cameraNum NUMERIC, cameraOrientation JSON, cameraType cameraType_type, cameraUsage TEXT, dataProvider TEXT, dateCreated TIMESTAMP, dateModified TIMESTAMP, description TEXT, endDateTime TIMESTAMP, id TEXT PRIMARY KEY, imageSnapshot TEXT, location JSON, mediaURL TEXT, name TEXT, on BOOLEAN, owner JSON, seeAlso JSON, source TEXT, startDateTime TIMESTAMP, streamName TEXT, streamURL TEXT, type Camera_type);