Questions tagged [data-model]
Questions about how to use CiviCRM feature to model real-life situations.
10 questions
4
votes
2
answers
88
views
What table and column contain the date a contact was added?
I'm trying to determine the correct table and column to check the data a contact was added to the civicrm-contact table. What is the best method for doing this?
- 996
3
votes
1
answer
185
views
How do user permissions work for multi-level organizations?
We are currently using Action Network for our CRM (even though it is not designed for that), marketing and digital mobilising tools.
We moved to them because of their system of parent/sibling/child ...
3
votes
1
answer
27
views
adding extra info to relations
I'm setting up CiviCRM for an animal charity organisation. Beside some problems to set up animal master data derived from an individual (e.g. animals usually don't have last names, etc.), I'm stuck ...
- 29
3
votes
2
answers
59
views
How to handle irrelevant employers we don't really want as separate contacts?
So, sometimes a contact's employer is entirely irrelevant, we have basically no value in keeping that information. Or maybe there's no reason not to note it, but it's not an organization we care about....
- 153
2
votes
1
answer
83
views
What are the files and fields in CiviCRM?
An organization I volunteer for is considering this software solution. I need to see the files and fields in those files to see how they match to our current system. A brief description of the purpose ...
- 21
2
votes
3
answers
49
views
using CiviCRM like Access?
I am new to CiviCRM. Is it possible for me to use CiviCRM like MS Access?
I really don't need all the fields CiviCRM is offering.
All I need is the fields shown as below:
First Name
Last Name
State
...
- 123
2
votes
1
answer
64
views
information about the underlying data-model behind civicrm (version 4.6)
where can I find that? I have a good knowledge of databases, so this information would help me a lot in modeling the civicrm-data with either contact-tags, groups.
- 21
2
votes
1
answer
42
views
Enforcing the uniqueness of fields/entities (e.g. phone numbers)
I'd like to ensure that phone numbers of a certain type (let's say Mobile) are unique across our Civi instance. A given contact should be able to have no more than one Mobile number, and no two ...
- 1,057
1
vote
1
answer
177
views
What is the database schema for groups and parent groups?
I need to manually delete a group that is corrupt. Already tried a few things. This corrupt group assigned itself as the parent to other groups and continues to add additional children groups every ...
- 754
0
votes
2
answers
123
views
How will I maintain a hierarchical structure in civicrm?
I want to maintain a following hierarchical structure for different user.How can I do that?
If any extension is available then let me know.
- 183