Apologies if I misunderstood what you're trying to do, it's too early in the morning and the caffeine hasn't kicked in yet...
Are you looking for a way to add extra data to existing rows in a table without having to add new columns? I have been thinking about doing something like this for an app I maintain at work. Basically I would create another table and call it tablename_properties where 'tablename' is the name of the table I'm adding properties for. It would contain four columns:
- ID -- the primary key
- tablenameID -- foreign key linking each row to a primary key in the 'tablename' table
- property -- this holds the name of the extension
- value -- this is a text or blob field that holds the extension data
This way you could just add as few or many extra properties to each of the records in 'tablename' as you like. If you only wanted one table to hold everything, then you could just add a tablename column holding the name of the table or to do it 'properly' you could put in a foreign key linked to your database's system table that holds the name of all your other tables (if such a thing exists for your DBMS).
Hope this helps
Cheers, Vik
Robertson-Ravo, Neil (RX) wrote:
Sorry for the XOT Post... but I am hoping you guys will know of this or at least have some input...
Anyone got any decent thoughts on a reusable table extension schema which I can adopt? I aim to create a table which will hold table extensions row by row and be extensibile enough to grow regardless of table type or name.
i.e. the new extension table will be able to extend any and all tables within the system only by adding new rows.
--- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
