Re: Implementing different document types with different attributes

Tim,

Are you using 9i?

If so create a parent_t object type with the common attributes.

Create child object types UNDER parent_t.

You can then define a table of type parent_t able to accept rows of all types.

Cheers,

John Thomas

In message <F001.005C9796.20030807082923_at_fatcity.com>, Vernaillen Tim <tim.vernaillen_at_xgs.be> writes
>sorry, misunderstood
>
>Invoices:
> - Origin
> - Form Template ID
> - AWB
> - Bill To Customer
> - Bill To Customer Name
> - Invoice #
> - Invoice date
> - customs Entry #
> - entry date
> - query handling (boolean)
> - cash application (boolean)
> - credit & collection (boolean)
> - text search (boolean)
> - shipment folder (boolean)
>
>Customs Document:
> - AWB
> - Clearance #
> - Customs Entry #
> - Entry date
> - deferement #
>
>Cash batches:
> - query handling (boolean)
> - cash application (boolean)
> - credit & collection (boolean)
>
>So, you could see, we've more than 50 type of documents and in total
>those have more than 70 different attributes (some are the same). There
>is not one attribute that appears on every document type!!!
>I would create so 50 tables (for each document type 1), but if someone
>has another suggestion, I would like to do it in an other way.
>
>-----Original Message-----
>Sent: donderdag 7 augustus 2003 16:59
>To: Multiple recipients of list ORACLE-L
>attributes
>
>
>
>Just one or two examples, please.
>
>
>
>
> "Vernaillen Tim"
> <tim.vernaillen To: Multiple
>recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> @xgs.be> cc:
> Sent by: Subject: RE:
>Implementing different document types with different attributes
> ml-errors
>
>
> 08/07/2003 10:44
> AM
> Please respond
> to ORACLE-L
>
>
>
>
>
>
>attribute is a specific part of an index-file, but those attributes are
>different for all document types
>
>-----Original Message-----
>Sent: donderdag 7 augustus 2003 16:15
>To: Multiple recipients of list ORACLE-L
>attributes
>
>
>
>What do you have as an example of an "attribute"?
>
>
>
>
> "Vernaillen Tim"
>
> <tim.vernaillen To: Multiple recipients
>of list ORACLE-L <ORACLE-L_at_fatcity.com>
> @xgs.be> cc:
>
> Sent by: Subject: Implementing
>different document types with different attributes
> ml-errors
>
>
>
> 08/07/2003 09:34
>
> AM
>
> Please respond
>
> to ORACLE-L
>
>
>
>
>
>
>
>Hello
>
>
>I've an installation/implementation question!
>We've to analyse 50 document types, in total those 50 has 70 different
>attributes.
>We don't want to put all those document types into one table, because more
>than the half (35) of the attributes are not always used for each document
>type. This will have to much disk space for each record, if most of the
>fields are just blank.
>
>
>Has anyone suggestions how to build our table-structure?
>I've heart something about FlexFields, what are they?
>Takes every field diskspace, even if it's blank (null)?
>
>
>Thanks in advance for the response!
>
>
>Tim
>
>
>
>
>
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Thomas Day
> INET: tday6_at_csc.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Vernaillen Tim
> INET: tim.vernaillen_at_xgs.be
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
>
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Thomas Day
> INET: tday6_at_csc.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Thomas
  INET: oracle_at_toronto.demon.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).