Suggestion on Database Schema / Database Design

[Jonathan Seni]

Hello,

I want to create a component, but am not sure if there is a particula guidelines / approach of designing a database.

Please advise any reading or approach.

Thanks. 

[Prasit Gebsaap]

Hi,

A simple guideline is adding your component (without com_) to your tables. If your component is com_test then your "articles" table will named "#__test_articles". #__ is  Joomla table prefix. I prefer using plural name (articles not article) for table name.

This is only one guideline I use.

--
You received this message because you are subscribed to the Google Groups "Joomla! General Development" group.
To view this discussion on the web, visit https://groups.google.com/d/msg/joomla-dev-general/-/GdANVEqXPHkJ.
To post to this group, send an email to joomla-de...@googlegroups.com.
To unsubscribe from this group, send email to joomla-dev-gene...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/joomla-dev-general?hl=en-GB.

--

Prasit Gebsaap

 

Nonthaburi, Thailand

http://www.joomlant.com, http://www.joomlant.org

http://ktdms.blogspot.com, http://lowcost-it.blogspot,com

 

[Sloan]

There are a few other things to be aware of that are specific to
Joomla! tables.

You should define several fields that Joomla will manage:
id - an auto increment field, and primary key
ordering - a field that controls or at least specifies the ordering of
rows for display
published - indicates whether the row is published or not. Allows the
admin to make a row disappear without deleting it

Take a look at some of the table in Joomla to see the type on the last
two (I can't remember off the top of my head).

[Prasit Gebsaap]

Yes, you have to define that fields if you need them. Joomla! check for it before perform action. However, for checked_out and checked_out_time, they are mandatory requirements. 

--
You received this message because you are subscribed to the Google Groups "Joomla! General Development" group.

To post to this group, send an email to joomla-de...@googlegroups.com.
To unsubscribe from this group, send email to joomla-dev-gene...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/joomla-dev-general?hl=en-GB.

[Jonathan Seni]

Okay, so which ones are mandatory to all every database in Joomla?

ie. id, checked_out, checked_out_time, etc....?

Jonathan Seni.

There are 10 kinds of people in this world,

Those who knows numbers, and

Those who wait for the other 8 people to be listed
----------------------------------------------------
SimplyMepis, SuSE 9.2, openSuSE 10.2 /10.3/11.0/11.1/11.2 /11.3/11.4(x86-64).