GOBii_meta_db

{"type":"doc","content":[{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"html-macro","parameters":{"macroParams":{"__bodyContent":{"value":"\n\n\n\nGOBii_meta_db_0.1\n\n\n\n\n\n\n\n\n\n\n\n

\n\n\n

\n

Table crop

This table keeps track of all the crops in this GDM instance.

\n\n\n\n\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n\n\t\t\t\n\t\t\n\t\t\n\t\n\n

Indexes	Field Name	Data Type	Description
*	id	serial
*	name	text	The name of the crop. Ex: maize
*	database_name	text	The postgres database name for this crop. The convention is gobii_<crop_name>.
*	owner	text	The postgres user that owns the crop database, typically, appuser.
*	creation_date	timestamptz DEFAULT now()	This is the date the crop was created - it gets auto-filled by the current date when the row was inserted.
Indexes
	pk_crop_id	ON id

\n\n

\n

Table job

This table contains all jobs in the system along with their origin and status.

\n\n\n\n\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n\n\t\t\t\n\t\t\n\t\t\n\t\n\n\t\n\t\t\n\t\t\n\t\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\n\n

Indexes	Field Name	Data Type	Description
*	id	serial
*	name	text	The name of the job. This can reflect the name of the job from an external system (ex. rabbitMQ) if needed.
*	crop_id	integer	This identifies the crop this job is on.
*	type_id	integer	This identifies the type of job, ex: loading, extraction, etc.
*	status	integer	The current state of this job, ex: in_progress, success, fail.
	message	text	A freetext field the application can use to store any custom status message. Ex. Failed with error code 123, Data loaded successfully at 11-11-21 19:00:01.
*	creation_date	timestamptz DEFAULT now()	The date this job was created.
Indexes
	pk_job_id	ON id
Foreign Keys
	job_crop_fkey	( crop_id ) ref crop (id)
	job_type_fkey	( type_id ) ref job_type (id)
	job_status_fkey	( status ) ref status (id)

\n\n

\n

Table job_type

This table contains all job types in the system, for example: data_loading, data_extraction.

\n\n\n\n\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n\n\t\t\t\n\t\t\n\t\t\n\t\n\n

Indexes	Field Name	Data Type	Description
*	id	serial
*	name	text	The name of the job type, ex: loading, extraction
	description	text
Indexes
	pk_job_type_id	ON id

\n\n

\n

Table status

This table contains all the possible status of a job, for example: in_progress, success, failed.

\n\n\n\n\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n\n\t\t\t\n\t\t\n\t\t\n\t\n\n

Indexes	Field Name	Data Type	Description
*	id	serial
*	name	text	The name of the status, ex: fail, success, in_progress, etc.
	description	text
Indexes
	pk_status_id	ON id

\n\n

\n

Table template

This table contains the templates for all the types of files we support.

\n\n\n\n\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\n\n\t\t\t\n\t\t\n\t\t\n\t\n\n\t\n\t\t\n\t\t\n\t\t\n\t\n\n

Indexes	Field Name	Data Type	Description
*	id	serial
*	name	text	The name of the template. This should be descriptive enough to identify the kind of data it applies to.
	crop_id	integer	This identifies the crop this template applies to. Leave it empty if the template is generic and applies to all crops.
	template	jsonb DEFAULT '{}'::jsonb	This is the json template.
	description	text
*	creation_date	timestamptz DEFAULT now()	The date this template was created.
Indexes
	pk_template_id	ON id
Foreign Keys
	template_crop_fkey	( crop_id ) ref crop (id)

\n\n

"}},"macroMetadata":{"macroId":{"value":"86efd3ba-9679-4ac5-b193-8cd86930c298"},"schemaVersion":{"value":"1"},"title":"HTML/Iframe Macro"}}}},{"type":"paragraph"},{"type":"paragraph"}],"version":1}

Meta Schema