CREATE TYPE administration_status_enum AS ENUM (
	'private',
	'submission', 
	'pre-evaluation', 
	'evaluation', 
	'rejected-TDG', 
	'accepted-TDG', 
	'pre-validation', 
	'validation', 
	'accepted', 
	'rejected-DCRB', 
	'external', 
	'finished'
);

CREATE TYPE check_result_enum AS ENUM (
	'unchecked', 
	'fatal', 
	'error', 
	'warning', 
	'ok'
);

CREATE TYPE member_type_enum AS ENUM (
	'member',
	'chair'
);

CREATE TYPE member_status_enum AS ENUM (
	'invite',
	'invited',
	'accepted',
	'declined'
);

CREATE TYPE name_status_enum AS ENUM (
	'standardized name',
	'preferred name',
	'admitted name',
	'deprecated name',
	'superseded name'
);

CREATE TYPE name_type_enum AS ENUM (
	'name section',
	'data element name'
);

CREATE TYPE owner_type_enum AS ENUM (
	'data category',
	'language section',
	'linguistic section',
	'text',
	'change request'
);

CREATE TYPE registration_status_enum AS ENUM (
	'private',
	'candidate',
	'standard',
	'deprecated',
	'superseded'
);

CREATE TYPE text_type_enum AS ENUM (
	'text',
	'explanatory comment',
	'unresolved issue',
	'change',
	'explanation',
	'linguistic explanation',
	'definition',
	'example',
	'linguistic example',
	'note',
	'administration note'
);

CREATE TYPE user_type_enum AS ENUM (
	'basic',
	'expert',
	'admin'
);

CREATE TYPE message_status_enum AS ENUM (
	'valid',
	'read',
	'obsolete',
	'deleted'
);

CREATE TYPE message_type_enum AS ENUM (
	'message',
	'invitation',
	'request',
	'news',
	'broadcast'
);

CREATE TYPE lock_type_enum AS ENUM (
	'data category'
);

CREATE TYPE access_rights_enum AS ENUM (
	'r',
	'ru',
	'rud'
);