Postgresql and Relationships between tables and Primary keys.
Hi,
I am coming from microsoft access background, intermediate, and I was totally bowled over by the other threads that are similar to mine.
I definitely would need a more beginners response to my question, that is, if it is reasonable to ask such a thing.
I would like to duplicate a database I just setup in access but now I oould like to do it in Postgresql and I have the following questions:
What is the command I give to create a table with the following structure:
tblClients with ClientID as the primary key and then the usual fields of LastName, FirstName and MI etc.
tblClientLines with a composite primary key of ContractID and ClientID since it has a 1 to many relationship with tblClients and tblContracts.
tblContracts with ContractID as the primary key and AuthCode etc as the other fields.
Thank-you for your time and patience, any pointers or advice would be appreciated.
fuzzy.
|