Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What do you do with an ENORMOUS primary key?
It looks to me as if you should have a
table of possible schedules, and then:
Create table STANDARDS (
asstcode varchar2(3), jobcode number(5,0),
-- Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminars UK July / Sept Australia July / August Malaysia September USA (MI) November http://www.jlcomp.demon.co.uk/seminar.html Howard J. Rogers wrote in message ...Received on Thu Jun 20 2002 - 07:22:34 CDT
>Suppose I have a table as follows:
>
>Create table STANDARDS (
>asstcode varchar2(3),
>jobcode number(5,0),
>season varchar2(3),
>period number (2,0),
>week number (2,0),
>day varchar2(3))
>
>In other words, an asset can have all sorts of jobs performed to it, and
>those jobs can be scheduled to occur 'sometime in Spring', or 'sometime in
>March', or sometime in week 16, or on Thursday.
>
>The scheduling options are mostly mutually exclusive: if you say 'sometime
>in Spring', you can't then say you want it done in Week 16. Either you are
>vague, or you are specific.
>
>The exception is the week/day combination. You might want a job performed
>each Tuesday and Thursday of week 16, so using both the week and the day
>columns is permitted.
>
>My trouble is that since an assett can have many jobs scheduled for it, and
>each job can be scheduled many times, the entire table is the entire
primary
>key.... and that doesn't feel right to me. I've actually created this table
>as 'ORGANIZATION INDEX', so if it *is* right, I can cope as best as
>possible.
>
>But are there any other suggestions? (And feel free to criticise the
>design/understanding of the relational model and so forth. I first created
>this table about 12 years ago. I've not seen an easier or more appropriate
>way of doing it before now, but one can always learn).
>
>Regards
>HJR
>
>