A description of the database model?
Development and Programming
Is there a description of the model of the database that EE uses? The tables use some very obscure names and the structures are sometimes difficult to read because of that. Development would be helped a lot if the idea behind the model would be documented somewhere.
Agreed .. I’ve seen something like this on a blog once, but I can’t find it :-( .. maybe someone else in here knows what I’m talking about.
Don’t take this the wrong way, please, but I am not sure there’s all that much to document? I mean, the db structure is rather self-evident, really. Also, just curious: obscure names? Which ones would that be?
Well the table channel_data contains the most mystery:
In my case field_ft_3 to field_ft_7 exist but there are no field_id_3 to field_id_7 after that there is field_id_8 which has some data in it and a field_ft_8 which says xhtml.
I understand that field_ft is the format, and the field_id is the value (maybe value would have been a better name 😊 ) but the numbering eludes me. I can probably mess around with it and figure it out, but a description of how it is build would be helpful and would speed things up.
Besides I have a really bad memory so once I have figured it out I’ll forget it if I don’t deal with it for a while and then I’ll have to retrace the id’s again. I would rather just read how it works.
exp_channel_data.field_id_1 contains the data of exp_channel_fields WHERE field_id = 1
That’s right, and the field_ft_ refers to the formatting. You seem to have deleted a few: I haven’t checked, but I don’t think that EE keeps the formatting info for deleted fields. Could those simply be some leftovers, as it were?
Maybe I should report that as a bug. Apparently the format fields don’t get deleted when the field gets deleted. I had started to think that those were the formatfields for the channel titles or something.
exp_channel_data.field_id_1 contains the data of exp_channel_fields WHERE field_id = 1
Yes that does seem clear enough, if I hadn’t had a list of id’s that didn’t match anything in exp_channel_fields I might have thought of that 😊 It just think that a simple picture that shows the relationships between the tables would be nice.