Welcome Guest, Not a member yet? Register   Sign In
Request for advice how to structure a table with possible relationship
#3

[eluser]gbar[/eluser]
then you split the table into two parts, books and meta_books, if I understand it ... (English is not my first language)

Code:
---------------------------------------------------------------------------------------
| id_book | author_id | category_id | publisher_id | book | price | synopsis | status |
---------------------------------------------------------------------------------------
|   int   |    int    |     int     |     int      |varcha| float |   text   |   int  |
---------------------------------------------------------------------------------------

and

Code:
------------------------------------------------------
| id_meta | book_id | Title | Description | keywords |
------------------------------------------------------
|   int   |   int   |varchar|   varchar   | varchar  |
------------------------------------------------------

Is correct?
Thanks for the clarification


Messages In This Thread
Request for advice how to structure a table with possible relationship - by El Forum - 06-13-2011, 04:17 AM



Theme © iAndrew 2016 - Forum software by © MyBB