Documentation of table

  • lecebri
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
15 years 6 months ago #1 by lecebri
Documentation of table was created by lecebri
please can i have a document which explains the meaning and purpose of every field of the database tables of joomdle?
i've look in my database and i have 3 tables in joomla :
- joomdle_fields_mapping: this table is alright
- joomdle_profilestype: i don't really understand how it works
- joomdle_purchased_courses: don't understand the role of the last fiel of the table


and 1 on moodle that i don't understand

can i please have a little documentation on this?

Please Log in or Create an account to join the conversation.

More
15 years 6 months ago #2 by Antonio Durán
Replied by Antonio Durán on topic Re: Documentation of table
Hi. Sorry, but there is no docs on the data model, as it is fairly simple.

- joomdle_profilestype: only used if you use XIPT component
- num is the number of purchased courses

On moodle we have no joomdle tables (aside from the dummy one)

Please Log in or Create an account to join the conversation.

  • lecebri
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
15 years 6 months ago #3 by lecebri
Replied by lecebri on topic Re: Documentation of table
please that dummytable have any role in the integration.
Thank for the this great component and support you give to the user.

Please Log in or Create an account to join the conversation.

More
15 years 6 months ago #4 by Antonio Durán
Replied by Antonio Durán on topic Re: Documentation of table
Nope, the table is only there because you cannot insert rows in another table we need to, without declaring some table to be created (at install time)

Please Log in or Create an account to join the conversation.

  • lecebri
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
15 years 6 months ago #5 by lecebri
Replied by lecebri on topic Re: Documentation of table
concerning the purchased_courses table it looks like the courseid field will always take the value of the categories id of the e-commerce extensions which was set while joomdle installation. and the num of courses purchased by a user in that category!!!
is it it?

Please Log in or Create an account to join the conversation.

More
15 years 6 months ago #6 by Antonio Durán
Replied by Antonio Durán on topic Re: Documentation of table
That table is only used when you set "purchase for children".

Courseid is the ID of the course.

Please Log in or Create an account to join the conversation.