CREATE TYPE space_type_enum AS ENUM (
            'Building',
            'Corridor',
            'Cupboard',
            'Floor',
            'Open Plan',
            'Room',
            'Space',
            'Unknown'
);

CREATE TYPE item_allocationtype_enum AS ENUM (
-
- Set to UNDEF when disposed
-
   'person',
   'server',
   'podium',
   'lab',
   'public',
   'unallocated',
   'junk',                                      --  official way to record junk
   'other'
);

CREATE TYPE item_managedtype_enum AS ENUM (
-
- Set to UNDEF when disposed
- 
   'unknown',
   'mdp',
   'dice',
   'selfdynamic',
   'selfstatic',
   'managed',
   'other'  
);

CREATE TYPE item_disposaltype_enum AS ENUM (
   'stolen',
   'lost',
   'contract',
   'sold',
   'other'
);

CREATE TYPE item_category_enum AS ENUM (
                'av',
                'cables',
                'cases',
                'components',
                'consumables',
                'desktop',
                'maintenance',
                'mechanical',
                'monitor',
                'networking',
                'networkswitch',
                'office',
                'peripherals',
                'photographic',
                'portable',
                'portable als',
                'power',
                'printer',
                'robotics',
                'server',
                'services',
                'software',
                'storage',   
                'storagearray',
                'tablet', 
                'vision',
                'wap',
                'UNKNOWN' 
);

CREATE TYPE logbook_changetype_enum AS ENUM (
   'creation',
   'location',
   'allocated',
   'managed_type',
   'hostname',
   'comment',
   'disposed',
   'fault'
);

-- AlastairScobie - 17 Jan 2014

Topic revision: r1 - 17 Jan 2014 - 14:25:42 - AlastairScobie
 
This site is powered by the TWiki collaboration platformCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback
This Wiki uses Cookies