You will have some performance problems if you take the
doc_type/doc_attribute approach, plus coding the application will not be
fun.
As another poster noted, flexfields are for Oracle Apps and they are just
the way Oracle apps tries to accommodate a limited amount of customization
to table
i like it Jack. just 1 more suggestion - from reading a little more into
the thread. i think he may also want another table to hold values for the
attributes that go with each doc type. this might do it:
Table Doc_Types
Doc_Type_IDNumberPK
,Doc_Type_Descr
Tim,
Can you provide some examples of the attributes for the different document
types?
If I were designing something, I would look for common attributes among all
the documents to see if they can be contained within the same table. There
would be one column within that table that would indicate
Attributes for documents?
Here are few of many possibilities:
1) @#$!
2) Stupid
3) Unintelligible
3) Illiterate
4) Unclear
5) CYA
6) Inscrutable
7) Laughable
8) Meaningless
9) PHB-ish
--
Mladen Gogala
Oracle DBA
-Original Message-
Mercadante, Thomas F
Sent: Thursday, August 07, 2003
If you're on Oracle 9i sounds like a perfect example of the use of
hierarchical object types.
Cheers,
John
In message [EMAIL PROTECTED], STEVE OLLIG
[EMAIL PROTECTED] writes
how about 2 tables w/ a 1:many relationship? document_types each with many
document_type_attributes. read up on data
how about 2 tables w/ a 1:many relationship? document_types each with many
document_type_attributes. read up on data modeling. i think several good
books were mentioned on this list recently.
-Original Message-
Sent: Thursday, August 07, 2003 8:34 AM
To: Multiple recipients of list
