Skip to content

Instantly share code, notes, and snippets.

@kodi
Created September 22, 2009 22:38
Show Gist options
  • Save kodi/191510 to your computer and use it in GitHub Desktop.
Save kodi/191510 to your computer and use it in GitHub Desktop.
1)tabela tipovi-karakteristika
id |ime
---------------------------
1 |proizvodjac
2 |rezolucija
3 |color spaces
2)tabekla karakteristike
-------------------------
id |tip_id |ime
---------------------------------
1 |1 |canon
2 |1 |nicon
.
.
.
.
34 |3 |Adobe RGB
35 |3 |sRGB
.
.
.
.
i tako u nedogled
.
.
.
.
3) tabela aparati
|id | model |price | description
------------------------------------------------------
|1 | eos 7d | 9999$ | jebe keve
.
.
.
.
.
.
4) tabela karakteristike aparata
// to je glavna kvaka
// tu cepaju samo id_jevi
|id | id_aparata | id_karakteristike
-------------------------------------------
1 |1 |1
2 |1 |34
ovo bi znacilo da id_aparata 1 - a to je eos 7D -> canon i moze da podrzi adobe rbg profil
// napomena polja id u svim tabelama su autoincrement
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment