africaseeds
Member
I am really interested in seeds and always have been.
I would like to build something similiar to **********.eu.
This has led me to be more interested in different aspects of seeds for example:
1. What filial is this seed pack?
2. What were the parents?
3.
I would really like to make a site almost like seedfiner.eu
the only difference would be:
1. My site would have more detailed info and more info
2. My site would try and pair reviews of strains with seeds and breeder
3. My site will be used to keep track of strains in terms of what they are good for medically. e.g Afghan Kush is good for insomnia etc.
I would like to know the following from you guys:
1. What type of fields should I store for each type of data? Any of you who work as programmers or DB admins will know I basically want to know what column names
to give to each table.
2. Where can I get large amounts of data showing me all the info of each strain?
The tables I have:
Breeder (has the following columns):
-id
-breeder
-company
-logo
-website
-instagram
-specialization
Seedbank (has the following columns):
-id
-name
-logo
-website
-instagram
-focus
Strain (has the following columns):
-id
-name
-family
-breeder_id
-filial
-father
-mother
Clone: (has the following columns):
-id
-name
-strain_id
-finder
-clonenursery_id
CloneNursery: (has the following columns):
-name
-id
-logo
-website
-instagram
-menu
-country
-location
Seed: (has the following columns):
-id
-type (regular or feminised)
-strain_id
-flowering_type (photo sensitive or autoflower)
SeedPack (has the following columns):
-id
-quantity
-year
-packaging
-breeder_id
-image
-seed_id
-strain_id
Thanks for your input.
I would like to build something similiar to **********.eu.
This has led me to be more interested in different aspects of seeds for example:
1. What filial is this seed pack?
2. What were the parents?
3.
I would really like to make a site almost like seedfiner.eu
the only difference would be:
1. My site would have more detailed info and more info
2. My site would try and pair reviews of strains with seeds and breeder
3. My site will be used to keep track of strains in terms of what they are good for medically. e.g Afghan Kush is good for insomnia etc.
I would like to know the following from you guys:
1. What type of fields should I store for each type of data? Any of you who work as programmers or DB admins will know I basically want to know what column names
to give to each table.
2. Where can I get large amounts of data showing me all the info of each strain?
The tables I have:
Breeder (has the following columns):
-id
-breeder
-company
-logo
-website
-specialization
Seedbank (has the following columns):
-id
-name
-logo
-website
-focus
Strain (has the following columns):
-id
-name
-family
-breeder_id
-filial
-father
-mother
Clone: (has the following columns):
-id
-name
-strain_id
-finder
-clonenursery_id
CloneNursery: (has the following columns):
-name
-id
-logo
-website
-menu
-country
-location
Seed: (has the following columns):
-id
-type (regular or feminised)
-strain_id
-flowering_type (photo sensitive or autoflower)
SeedPack (has the following columns):
-id
-quantity
-year
-packaging
-breeder_id
-image
-seed_id
-strain_id
Thanks for your input.