dbTalk Databases Forums  

looking for advice...

comp.databases.postgresql.questions comp.databases.postgresql.questions


Discuss looking for advice... in the comp.databases.postgresql.questions forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
JustSomeGuy
 
Posts: n/a

Default looking for advice... - 03-03-2004 , 08:17 PM






I have a database that should be quite simple to do.

I have a base object that is easily defined
as

create table myObject (
a integer,
b integer,
len integer,
data bytea
);

Now this really should be a type:
And oddly enough it is the only type of data in the entire database.

A list of these is a row in a table.
The list size is variable.

level a one to many level b
level b one to many level c
level c one to many level d

Each of these levels is a list (or row) of these objects..

What does the scheme or sql of this look like.
I'm sort of new to databases.. but I don't know how to make the 'entity
relationships' between the levels.

Help?






Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.