![]() |
|
|||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
| Forum | Gallery | Weather | Journals | Links | Webring | Wiki | NEW:Shop |
| Articles | Opinion | T.O.D. | NEW:Radio | Contests | Humor | NEW: Auctions! | Donate |
![]() |
|
|
Thread Tools | Display Modes | ||
|
| ||||
|
|
#41 |
|
bonsaiTALK Master
|
For those of you who may be sufficiently familiar with relational databases, or could use the diagram to visualize the relationships verbally described above, here is a picture.
Brian
__________________
Everything on all planes of existence is interconnected - you and your tree are one! __________________________________________
Download information for the Bonsai Management System: http://home.comcast.net/~BrianP03103/BonsaiManagementSystem.txt |
|
|
|
|
|
#42 |
|
bonsaiTALK Master
|
Well, there it is. Have I forgotten or misunderstood anything?
![]() Please ask as many questions as you'd like to tease out accurate answers to uncertainties. ![]() Brian
__________________
Everything on all planes of existence is interconnected - you and your tree are one! __________________________________________
Download information for the Bonsai Management System: http://home.comcast.net/~BrianP03103/BonsaiManagementSystem.txt |
|
|
|
|
|
#43 |
|
Tips:5¢ Advice:Free
|
hmm. maybe pots? (kiln style color construction, glaze, hxwxd, cost, value?) the acquisition property would apply there too.
__________________
Want to be a seller on bonsaiAUCTIONS? Get authorized today!
bonsaiTALK: Over 100,005.36 Megabytes Served this Month!
|
|
|
|
|
|
#44 | |
|
bonsaiTALK Master
|
Quote:
![]()
__________________
Everything on all planes of existence is interconnected - you and your tree are one! __________________________________________
Download information for the Bonsai Management System: http://home.comcast.net/~BrianP03103/BonsaiManagementSystem.txt |
|
|
|
|
|
|
#45 |
|
just me :)
|
Maybe I missed it somewhere in this nice long thread, but has there been thought as to a "sort by" function?
I.e. I want to sort and see which plants are in the same soil.. or which plants are in different pot styles...? Also, is there a place to put lighting requirements? Like, shade loving, under the bench, desert sun, etc? |
|
|
|
|
|
#46 | ||
|
bonsaiTALK Master
|
Quote:
Quote:
Thanks very much for your insightful comments. Brian
__________________
Everything on all planes of existence is interconnected - you and your tree are one! __________________________________________
Download information for the Bonsai Management System: http://home.comcast.net/~BrianP03103/BonsaiManagementSystem.txt |
||
|
|
|
|
|
#47 |
|
bonsaiTALK Craftsman
|
Well done Brian! Just a few suggestions, could you include age, height and maybe trunk diameter for the trees and pot dimensions.
/Magnus |
|
|
|
|
|
#48 | |
|
bonsaiTALK Master
|
Being Done
Quote:
Age, however will remain a calculated value, based on age at acquisition plus the difference between today and the date of acquisition. OK? THANK YOU ALL for your thoughtful and insightful comments!
__________________
Everything on all planes of existence is interconnected - you and your tree are one! __________________________________________
Download information for the Bonsai Management System: http://home.comcast.net/~BrianP03103/BonsaiManagementSystem.txt |
|
|
|
|
|
|
#49 |
|
bonsaiTALK Master
|
OK, folks. Based on the collective input, I have made significant enhancements to the database structure. tblStylingPhotos has been deleted, replace by joinProgressPhotos. tblTreeSpecies and tblSpecimens have been modified; new/modified fields are denoted by a leading "* ". Several other new tables have been added to hold requested data.
Below is the new Relationship Diagram. Thanks again for your communal assistance. Brian
__________________
Everything on all planes of existence is interconnected - you and your tree are one! __________________________________________
Download information for the Bonsai Management System: http://home.comcast.net/~BrianP03103/BonsaiManagementSystem.txt |
|
|
|
|
|
#50 |
|
bonsaiTALK Master
|
TreeSpecies
Table defining Specie of a bonsai TreeType - Link - Pointer to TreeTypes record, categorizing the Specie CommonName - 50 Character Text - The Common Name of the Tree Specie BotanicalName - 50 Character Text - The Botanical (Latin) Name of the Tree Specie Description - Memo - Freeform definition of the Tree Specie * LightingRequirements - Number - Brief, NON-MODIFIABLE list of Lighting Requirements * WateringRequirements - Number - Brief, NON-MODIFIABLE list of Watering Requirements * FertilizingRequirements - Number - Brief, NON-MODIFIABLE list of Fertilizing Requirements Photo - Link - Pointer to BLOB in specialized Linked Database for Photos
__________________
Everything on all planes of existence is interconnected - you and your tree are one! __________________________________________
Download information for the Bonsai Management System: http://home.comcast.net/~BrianP03103/BonsaiManagementSystem.txt |
|
|
|
![]() |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| New Bonsai Management Software | BrianP03103 | Product Showcase | 0 | 23-Jan-2007 09:44 PM |
| GSBF-North Bonsai Pin Collection | TreeBay | General | 9 | 15-Feb-2006 12:31 PM |
| Musical Bonsai Composition | K.A. Rutledge | Opinion | 10 | 18-Jan-2006 04:18 PM |
| Bonsai Humor | Chip Smith | bonsaiQUOTES | 0 | 8-Nov-2004 05:08 PM |
| Andy's Bonsai Palaver | Ron Martin | General | 25 | 18-Aug-2004 12:31 AM |