×
Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues
Designating a Primary Key
Robert Garza
New Member
Posts: 2
9 года 3 мес. назад #913
от Robert Garza
Robert Garza создал тему: Designating a Primary Key
I have imported a SQL Script into Component Creator but how do I know that the fields I created to be primary keys are actually primary keys.
Or...how do I designate a primary key in an imported table?
Am I stuck using "id" as the only field name for a primary key?
Thanks
Or...how do I designate a primary key in an imported table?
Am I stuck using "id" as the only field name for a primary key?
Thanks
Пожалуйста Войти или Регистрация, чтобы присоединиться к беседе.
Walt Sorensen
Senior Member
Posts: 54
9 года 3 мес. назад #919
от Walt Sorensen
Walt Sorensen ответил в теме Designating a Primary Key
Generally speaking when working with Joomla components you will want to use `id` as your table's unique primary key field.
Without getting into a lot of explanation as to why, or identifying exceptions to this rule of thumb; I would say that you will likely save yourself from a lot of headaches by sticking with this general convention.
Without getting into a lot of explanation as to why, or identifying exceptions to this rule of thumb; I would say that you will likely save yourself from a lot of headaches by sticking with this general convention.
Спасибо сказали: Andres Maeso, Robert Garza
Пожалуйста Войти или Регистрация, чтобы присоединиться к беседе.
Robert Garza
New Member
Posts: 2
9 года 3 мес. назад #920
от Robert Garza
Robert Garza ответил в теме Designating a Primary Key
Thanks!! Also, just wondering....
Are there any other preferred names for other fields/columns - created_by, active, checked_out_by, ..etc...
Are there any other preferred names for other fields/columns - created_by, active, checked_out_by, ..etc...
Пожалуйста Войти или Регистрация, чтобы присоединиться к беседе.
Walt Sorensen
Senior Member
Posts: 54
9 года 3 мес. назад #922
от Walt Sorensen
Walt Sorensen ответил в теме Designating a Primary Key
Yes there are "reserved" field names for the table
There is some information in the JTable tutorial docs.joomla.org/Using_the_JTable_class
(The tutorial does need some technical review, but will give you some good general direction)
There is also a way to specify custom names for fields documented in the API api.joomla.org/cms-3/classes/JTable.html
There is some information in the JTable tutorial docs.joomla.org/Using_the_JTable_class
(The tutorial does need some technical review, but will give you some good general direction)
There is also a way to specify custom names for fields documented in the API api.joomla.org/cms-3/classes/JTable.html
Спасибо сказали: Andres Maeso, Robert Garza
Пожалуйста Войти или Регистрация, чтобы присоединиться к беседе.
Время создания страницы: 0.055 секунд