Could you pl post the table creation scripts ?
That would be much helpful for others to reply to your question.

Tamil