[Phpgroupware-developers] HR - tableset

[Sigurd Nes]

I have outlined a set of tables (attached) to support these features:
Training item is rated and linked to tasks with degree of relevance. The
tasks are rated for importance and grouped into job-descriptions
(job-type) - which is linked to an organization layout (hierarchy).
Training items is categorized as education, courses or work experiences.

Any thoughts?

Regards

Sigurd

 array(
			'fd' => array(
				'id' => array('type' => 'auto','precision' => '4','nullable' => False),
				'org_parent' => array('type' => 'int','precision' => '4','nullable' => True),
				'job_id' => array('type' => 'int','precision' => '4','nullable' => True),
				'user_id' => array('type' => 'int','precision' => '4','nullable' => True),
				'part_time_percent' => array('type' => 'int','precision' => '4','nullable' => True),
				'name' => array('type' => 'varchar','precision' => '64','nullable' => True),
				'descr' => array('type' => 'text','nullable' => True),
				'entry_date' => array('type' => 'int','precision' => '4','nullable' => True),
				'owner' => array('type' => 'int','precision' => '4','nullable' => True),
				'access' => array('type' => 'varchar','precision' => '7','nullable' => True),
			),
			'pk' => array('id'),
			'fk' => array(),
			'ix' => array(),
			'uc' => array()
		),

		'hr_job' => array(
			'fd' => array(
				'id' => array('type' => 'auto','precision' => '4','nullable' => False),
				'job_parent' => array('type' => 'int','precision' => '4','nullable' => True),
				'name' => array('type' => 'varchar','precision' => '64','nullable' => True),
				'descr' => array('type' => 'text','nullable' => True),
				'entry_date' => array('type' => 'int','precision' => '4','nullable' => True),
				'owner' => array('type' => 'int','precision' => '4','nullable' => True),
				'access' => array('type' => 'varchar','precision' => '7','nullable' => True),
			),
			'pk' => array('id'),
			'fk' => array(),
			'ix' => array(),
			'uc' => array()
		),

		'hr_task' => array(
			'fd' => array(
				'id' => array('type' => 'auto','precision' => '4','nullable' => False),
				'name' => array('type' => 'varchar','precision' => '64','nullable' => True),
				'descr' => array('type' => 'text','nullable' => True),
				'entry_date' => array('type' => 'int','precision' => '4','nullable' => True),
			),
			'pk' => array('id'),
			'fk' => array(),
			'ix' => array(),
			'uc' => array()
		),

		'hr_task_job' => array(
			'fd' => array(
				'task_id' => array('type' => 'int','precision' => '4','nullable' => False),
				'job_id' => array('type' => 'int','precision' => '4','nullable' => False),
				'importance' => array('type' => 'int','precision' => '4','nullable' => True),
				'required_skill' => array('type' => 'int','precision' => '4','nullable' => True)
			),
			'pk' => array('task_id','job_id'),
			'fk' => array(),
			'ix' => array(),
			'uc' => array()
		),

		'hr_training' => array(
			'fd' => array(
				'id' => array('type' => 'int','precision' => '4','nullable' => False),
				'user_id' => array('type' => 'int','precision' => '4','nullable' => False),
				'name' => array('type' => 'varchar','precision' => '40','nullable' => True),
				'skill' => array('type' => 'int','precision' => '4','nullable' => True),
				'category' => array('type' => 'int','precision' => '4','nullable' => True),
				'start_date' => array('type' => 'int','precision' => '4','nullable' => True),
				'end_date' => array('type' => 'int','precision' => '4','nullable' => True),
				'place' => array('type' => 'int','precision' => '4','nullable' => True),
				'reference' => array('type' => 'varchar','precision' => '255','nullable' => False),
				'descr' => array('type' => 'text','nullable' => True),
				'entry_date' => array('type' => 'int','precision' => '4','nullable' => True),
				'owner' => array('type' => 'int','precision' => '4','nullable' => True),
				'access' => array('type' => 'varchar','precision' => '7','nullable' => True),
			),
			'pk' => array('id','user_id'),
			'fk' => array(),
			'ix' => array(),
			'uc' => array()
		),

		'hr_training_category' => array(
			'fd' => array(
				'id' => array('type' => 'int','precision' => '4','nullable' => False),
				'descr' => array('type' => 'varchar','precision' => '40','nullable' => True),
			),
			'pk' => array('id'),
			'fk' => array(),
			'ix' => array(),
			'uc' => array()
		),

		'hr_training_place' => array(
			'fd' => array(
				'id' => array('type' => 'int','precision' => '4','nullable' => False),
				'name' => array('type' => 'varchar','precision' => '64','nullable' => True),
				'address' => array('type' => 'varchar','precision' => '255','nullable' => False),
				'zip' => array('type' => 'int','precision' => '4','nullable' => True),
				'town' => array('type' => 'varchar','precision' => '255','nullable' => False),
				'descr' => array('type' => 'text','nullable' => True),
			),
			'pk' => array('id'),
			'fk' => array(),
			'ix' => array(),
			'uc' => array()
		),
		'hr_training_task' => array(
			'fd' => array(
				'training_id' => array('type' => 'int','precision' => '4','nullable' => False),
				'task_id' => array('type' => 'int','precision' => '4','nullable' => False),
				'relevance' => array('type' => 'int','precision' => '4','nullable' => True),
			),
			'pk' => array('training_id','task_id'),
			'fk' => array(),
			'ix' => array(),
			'uc' => array()
		),
	);