Results 1 to 4 of 4

Thread: Table question

  1. #1
    Join Date
    Sep 2003
    Posts
    11

    Unanswered: Table question

    I wish to create a database to hold information on source code dependencies.

    FileName
    Computer primarily on
    Language
    ClassNames
    Path to one example
    Filenames it depends
    Other Dependencies - access to resources etc
    Description

    This seems to only require one table. How would I then go about implementing this? Can I relate the table to itself or what?

    The dependencies is what does it. It makes it seem that I need to join the table to itself.

    Thanks for any help.

  2. #2
    Join Date
    Sep 2003
    Posts
    11
    Whooops, I'll go and post this in the database design forum.

    Relevant question however: - the only database program I have really used is access. With this you could set up things like saying tables should have a one to many relationship. Is there a way to automatically enforce relationships such as this in mysql?

    Thanks.

  3. #3
    Join Date
    Sep 2003
    Posts
    6
    Use InnoDB tabletype and if you are looking for a nice GUI to create relationships then you can try SQLyog.

  4. #4
    Join Date
    Sep 2003
    Posts
    11
    Cheers, everything is now good

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •