Databases
StackOverflow2013
Postsdbo
POA database Schema to store a content type and a sub content (ANDROID _ SQLITE :)
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POA database Schema to store a content type and a sub content (ANDROID _ SQLITE :)
    primarykey
    data
    text
    <p><strong>WHAT I WANT TO ACHIEVE</strong></p> <p>=> Create an ANDROID app that shows the list of car manufacturers and the type of models they make. So when the user opens the app they see list of manufacturers. (ALL THIS DATA WILL BE LOADED FROM A DATABASE)</p> <p>Like</p> <p>1.Toyota</p> <p>2.GMC etc..</p> <p>So when they click on Toyota they will see the different cars Toyota makes (BY LOADING THEM FROM DATABASES). There would be sequence of screens displaying the different models .</p> <p>SCREEN 1: Toyota Camry[A PICTURE , LITTLE DETAIL , AND A (VIDEO OR AUDIO) ]</p> <p>SCREEN 2: Toyota Carina II[SAME THING HERE, (VIDEO OR AUDIO) , PICTURE AND DETAILS ABOUT CAR] etc...</p> <p>So in each SCREEN there would be some kind of media related to THE CAR MODEL as shown above. A video or an audio promoting the car and some kind of text related to that model. </p> <p>Now I'm downloading this information and want to save this kind of information of manufacturers and their cars in a database . I just cant come up with a good DB schema that let me safe this kind of data and let me load back to the screens .</p> <p>--> If you can give me a general database schema like the number of tables I should have etc.. i would really appreciate.</p> <p><strong>SCHEMA I THOUGHT OF BUT DOESN'T LOOK GOOD</strong></p> <p>==><strong>MANUFACTURERS TABLE</strong>[*MANUFACTURERS _ID , COMPANY_NAME , *<em>MODELS ???HERE WHAT AM I MISSING ???</em> **]</p> <p>==><strong>MODELS_TABLE</strong> [*MANUFACTURERS _ID , MODEL_ID ,MODEL_NAME*]</p> <p>==><strong>RELATED MEDIA</strong> [*MODEL_ID , VIDEO_LOCATION , AUDIO_LOCATION , DETAILS_ABOUT_THE_CAR*]</p> <p>AS YOU SEE AM JUST NOT GOOD WITH THE DESIGN :/ SO PLEASE HELP , <strong>THANKS IN ADVANCE</strong> </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USuser1013008
    1. USuser1013008
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POA database Schema to store a content type and a sub content (ANDROID _ SQLITE :)
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POA database Schema to store a content type and a sub content (ANDROID _ SQLITE :)
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload