Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.sys.apple2 > #25423

Re: My database schema, was Re: Retro computer collection...

Show all headers | View raw

In article <dog_cow-1437843759@macgui.com>, D Finnigan
<dog_cow@macgui.com> wrote:
> 
> This is really spartan, but it gets the job done for me. I am willing to
> improve it, but contact me near the end of August because I'm too busy now
> to devote time to it.
> 
> CREATE TABLE IF NOT EXISTS `items` (
>   `item_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
>   `name` varchar(255) NOT NULL DEFAULT '',
>   `obtained_from` varchar(255) NOT NULL DEFAULT '',
>   `obtained_date` varchar(255) NOT NULL DEFAULT '',
>   `price` varchar(50) NOT NULL DEFAULT '',
>   `serial_no` varchar(255) NOT NULL DEFAULT '',
>   `part_no` varchar(255) NOT NULL DEFAULT '',
>   `notes` text NOT NULL,
>   PRIMARY KEY (`item_id`)
> ) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

That's an extremely simple flat-file database, easily buildable in any
database or spreadsheet application. Other than putting something in
the Notes field, it won't do the collecting of various parts into a
"system" record that the original poster was looking for. For that you
really need a database with record relationship links.

Helpful Harry   :o)

Back to comp.sys.apple2 | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Retro computer collection management database recommendations sought europlus <europlus@mcnamaras.id.au> - 2015-07-19 10:39 +0000
  Re: Retro computer collection management database recommendations sought TheJ <thej@shaw.ca> - 2015-07-19 14:53 +0000
    Re: Retro computer collection management database recommendations sought D Finnigan <dog_cow@macgui.com> - 2015-07-21 23:55 +0000
      Re: Retro computer collection management database recommendations sought TheJ <thej@shaw.ca> - 2015-07-22 19:54 +0000
        Re: Retro computer collection management database recommendations sought a2retro <a2retrosystems@gmail.com> - 2015-07-22 21:20 -0700
          Re: Retro computer collection management database recommendations sought Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-07-23 18:21 +1200
            Re: Retro computer collection management database recommendations sought a2retro <a2retrosystems@gmail.com> - 2015-07-23 15:25 -0700
              Re: Retro computer collection management database recommendations sought Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-07-24 18:18 +1200
        Re: Retro computer collection management database recommendations sought D Finnigan <dog_cow@macgui.com> - 2015-07-23 23:14 +0000
          My database schema, was Re: Retro computer collection... D Finnigan <dog_cow@macgui.com> - 2015-07-25 17:01 +0000
            Re: My database schema, was Re: Retro computer collection... Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-07-26 10:42 +1200
  Re: Retro computer collection management database recommendations sought Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-07-20 13:57 +1200
    Re: Retro computer collection management database recommendations sought europlus <europlus@mcnamaras.id.au> - 2015-07-30 07:24 +1000
      Re: Retro computer collection management database recommendations sought Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-07-30 14:09 +1200
        Re: Retro computer collection management database recommendations sought europlus <europlus@mcnamaras.id.au> - 2015-07-30 15:57 +1000

csiph-web