Re: [Phpgroupware-developers] HR - tableset

[Dave Hall]

On Sun, 2005-11-13 at 19:01 +0100, Sigurd Nes wrote:
> 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?

I just did a quick review.  This is what struck me when I looked at it.

hr_org - why not use the contacts orgs?
hr_training_category - why not use the api cats?

Have you considered linking the training time info to the calendar so
users can easily see when training is scheduled when arranging other
events?

Just some ideas

Cheers

Dave
> 
> Regards
> 
> Sigurd
> 
> HTML page attachment (tables_current.inc.php)
> 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() ), ); 
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://lists.gnu.org/mailman/listinfo/phpgroupware-developers
-- 
Dave Hall (aka skwashd)
API Coordinator
phpGroupWare
e address@hidden
w phpgroupware.org