CRM CORE

CRM Database

Get Started. It's Free
or sign up with your email address
Rocket clouds
CRM CORE by Mind Map: CRM CORE

1. Field MUST have

1.1. created_by

1.2. created_on

1.3. modified_by

1.4. modified_on

1.5. status

1.6. If choose soft deleted

1.6.1. deleted_by

1.6.2. deleted_on

1.6.3. is_deleted

2. Menus

2.1. ain_menu_entities

2.1.1. menu_id

2.1.2. entity_id

2.2. ain_menus

2.2.1. id

2.2.2. name

2.2.3. url

2.2.4. order_by

2.2.5. menu_type

2.2.5.1. 1: modules

2.2.5.2. 2: group

2.2.5.3. 3: function

2.2.6. parent_id

2.2.7. icon

3. Options Set

3.1. ain_option_set_fields

3.1.1. id

3.1.2. option_set_pool_id

3.1.3. entity_field_id

3.1.4. entity_id

3.2. ain_option_set_pools

3.2.1. id

3.2.2. label - nvarchar (255)

3.2.3. value - bigint

3.2.4. order_by - smallint

4. Entities

4.1. ain_entity_fields

4.1.1. id

4.1.2. display_name

4.1.3. name

4.1.4. requirement_value

4.1.5. requirement_label

4.1.6. is_searchable - bit

4.1.7. field_security - bit

4.1.8. auditing - bit

4.1.9. description - nvarchar(2000)

4.1.10. data_type - smallint

4.1.10.1. single line of text

4.1.10.2. option set

4.1.10.3. two options

4.1.10.4. images

4.1.10.5. whole number

4.1.10.6. floating point number

4.1.10.7. decimal number

4.1.10.8. currency

4.1.10.9. multiple lines of text

4.1.10.10. date and time

4.1.10.11. lookup

4.1.11. format - smallint

4.1.11.1. text

4.1.11.2. email

4.1.11.3. text area

4.1.11.4. url

4.1.11.5. ticket symbol

4.1.11.6. phone

4.1.12. maximum_length

4.1.13. entity_id - guid

4.2. ain_entities

4.2.1. id

4.2.2. display_name - nvarchar(255)

4.2.3. plural_name - nvarchar

4.2.4. name_in_db

4.2.4.1. default: ain_

4.2.5. icon

4.2.5.1. upload file

4.2.6. owner_type - smallint

4.2.6.1. 1: user or team

4.2.6.2. 2: organization

4.2.7. description - nvarchar(2000)

4.2.8. business_process_flow - bit

4.2.9. note - bit

4.2.10. activities - bit

4.2.11. connections - bit

4.2.12. sending_email - bit

4.2.13. document_management - bit

4.2.14. knowledge_management - bit

4.2.15. enable_for_sla - bit

4.2.16. allow_quick_create - bit

4.2.17. duplicate_detection - bit

4.2.18. auditing - bit

4.2.19. is_system - bit

5. Products

5.1. ain_units

5.1.1. name - n - 255

5.1.2. quantity - decimal(18,5)

5.1.3. parent_id : guid

5.1.4. unit_group_id - guid

5.2. ain_unit_groups

5.2.1. name - n - 255

5.3. ain_notes

5.3.1. entity_id

5.3.2. entity_record_id

5.3.3. entity_type

5.3.4. title - n - 255

5.3.5. content - n - 2000

5.3.6. attachment - n - 1000 (url file)

5.4. ain_products

5.4.1. name - n - 255

5.4.2. product_code -n - 255

5.4.3. parent_id - guid

5.4.4. valid_from - bigint

5.4.5. valid_to - bigint

5.4.6. description - n - 2000

5.4.7. unit_group_id - guid

5.4.8. unit_id - guid

5.4.9. price_list_id - guid

5.4.10. decimal_supported - byte

5.4.11. subject - smallint (FE hardcode)

5.4.12. status_label

5.4.13. status_value

5.5. ain_properties

5.5.1. name -n 255

5.5.2. read_only - bit

5.5.3. required - bit

5.5.4. hidden - bit

5.5.5. regarding_product_id

5.5.6. decription - n 2000

5.5.7. datatype_value - smallint

5.5.8. datatype_label

5.5.9. min_value: decimal

5.5.10. max_value:decimal

5.5.11. default_value: decimal

5.5.12. precision:smallint

5.5.13. text_default: n 1000

5.5.14. max_length: smallint

5.6. ain_property_optionset

5.6.1. property_id

5.6.2. name

5.6.3. value

5.6.4. description: n 2000

5.6.5. is_default: bit

5.7. ain_product_properties

5.7.1. product_id

5.7.2. property_id

5.8. ain_territories

5.8.1. state_id

5.8.2. city_id

5.8.3. province_id

5.8.4. name

5.9. ain_price_list_territories

5.9.1. price_list_id

5.9.2. territory_id

5.10. ain_discount

5.10.1. name

5.10.2. discount_type_value

5.10.3. discount_type_label

5.10.4. currency_id

5.10.5. description: n 2000

5.11. ain_discount_details

5.11.1. begin_quantity: decimal

5.11.2. end_quantity: decimal

5.11.3. amount: money

5.11.4. percent: decimal

6. Competitors

6.1. ain_lead_competitors

6.2. ain_competitors

6.2.1. name - n - 255

6.2.2. website -n - 255

6.2.3. currency_id

6.2.4. address : same table account

6.2.5. strength -n - 2000

6.2.6. weakness - n - 2000

6.2.7. ticker_symbol -n - 50

6.2.8. reported_revenue - money

6.3. ain_opportunity_competitors

7. StackHolders

7.1. ain_lead_stackholders

7.1.1. lead_id

7.2. ain_opportunity_stackholders

7.2.1. opportunity_id

8. Opportunities

8.1. ain_opportunities

8.1.1. topic - n - 255

8.1.2. contact_id

8.1.3. account_id

8.1.4. purchase_time_frame_label

8.1.5. purchase_time_frame_value

8.1.6. currency_id

8.1.7. budget_amount - money

8.1.8. purchase_process_label

8.1.9. purchase_process_value

8.1.10. description

8.1.11. current_situation - n - 2000

8.1.12. customer_need - n - 2000

8.1.13. proposed_solution -n - 2000

8.1.14. price_list_id

8.1.15. revenue_label

8.1.16. revenue_value

8.1.17. detail_amount - money

8.1.18. discount_percent - decimal

8.1.19. discount - money

8.1.20. pre_freight_amount - money

8.1.21. total_tax - money

8.1.22. total_amount - money

8.1.23. est_close_date - bigint

8.1.24. est_revenue - money

8.1.25. owner_type

8.1.26. owner_id

8.1.27. status_label

8.1.28. status_value

8.2. ain_opportunity_saleteams

8.2.1. opportunity_id

8.2.2. user_id

8.2.3. sale_role_label

8.2.4. sale_role_value

8.3. ain_opportunity_products

8.3.1. opportunity_id

8.3.2. product_id

8.3.3. price_per_unit: money

8.3.4. quantity: int

8.3.5. discount: money

8.4. ain_price_list

8.4.1. name

8.4.2. start_date: bigint

8.4.3. end_date: bigint

8.4.4. currency_id

8.4.5. description: n 2000

8.5. ain_price_list_items

8.5.1. price_list_id

8.5.2. product_id

8.5.3. unit_id

8.5.4. currency_id

8.5.5. discount_id

8.5.6. quantity_selling_value

8.5.7. quantity_selling_label

8.5.8. pricing_method_value

8.5.9. pricing_method_label

8.5.10. amount: money

8.5.11. percentage: decimal

8.5.12. rounding_policy_value

8.5.13. rounding_policy_label

8.5.14. rounding_amount: money

8.6. ain_opportunity_quotes

8.6.1. opportunity_id

8.6.2. quote_id

8.6.3. name

8.6.4. status_value

8.6.5. status_label

8.6.6. total_amount: money

8.6.7. effect_from: bigint

8.6.8. effect_to: bigint

9. ain

10. LEAD

10.1. ain_leads

10.1.1. topic - nvarchar _ 255

10.1.2. first_name - n - 255

10.1.3. last_name - n - 255

10.1.4. full_name - n - 600

10.1.5. job_title - n - 255

10.1.6. business_phone - n - 30

10.1.7. mobile_phone - n - 30

10.1.8. email - n - 255

10.1.9. company_name - n - 255

10.1.10. address: same contact

10.1.11. description - n - 2000

10.1.12. industry_value

10.1.13. industry_label

10.1.14. annual_revenue - money

10.1.15. no_of_employees - int

10.1.16. sic_code - nvarchar(20)

10.1.17. currency_id

10.1.18. campaign_id

10.1.19. marketing_material - bit

10.1.20. last_campaign_date - big int

10.1.21. prefered_method_value

10.1.22. prefered_method_label

10.1.23. allow_send_email - bit

10.1.24. allow_follow_email

10.1.25. allow_bulk_email

10.1.26. allow_phone

10.1.27. allow_mail

10.1.28. lead_source_value

10.1.29. lead_source_label

10.1.30. rating_value

10.1.31. rating_label

10.1.32. lead_status_value

10.1.33. lead_status_label

10.1.34. owner_type

10.1.35. owner_id

10.1.36. business_process_flow_id

10.1.37. stage_pending_on

10.1.38. BUSINEES FLOW: phan tich sau

11. CASES

11.1. ain_cases

11.1.1. customer_entity_id

11.1.2. customer_entity_type

11.1.3. customer_entity_record_id

11.1.4. title - n - 255

11.1.5. subject - smallint (hard code FE)

11.1.6. case_type_value

11.1.7. case_type_label

11.1.8. contact_id

11.1.9. assign_id

11.1.10. assign_type

11.1.11. parent_id

11.1.12. origin_value

11.1.13. origin_label

11.1.14. product_id

11.1.15. entitlement_id

11.1.16. first_response_by_id

11.1.17. first_response_by_type

11.1.18. resolve_by_id

11.1.19. resolve_by_type

11.1.20. description

12. Contact

12.1. ain_contacts

12.1.1. dsads

12.1.2. full_name - nvarchar(600)

12.1.3. last_name - n - 255

12.1.4. fist_name - n - 255

12.1.5. job_title - n - 255

12.1.6. account_contact_id

12.1.7. email - n- 255

12.1.8. business_phone - n - 30

12.1.9. mobile_phone - n - 30

12.1.10. fax - n - 30

12.1.11. prefered_method_value: smallint

12.1.12. perfered_method_label - n - 255

12.1.13. address_stree_1(2)(3) - n - 1000

12.1.14. city (input ) - n - 255

12.1.15. state_id

12.1.16. province_id

12.1.17. country_id

12.1.18. postal_code - n - 10

12.1.19. lat - n - 50

12.1.20. lng - n - 50

12.1.21. company_record_id

12.1.22. company_entity_id

12.1.23. company_entity_type

12.1.24. gender_value

12.1.25. gender_label

12.1.26. marital_status_label

12.1.27. marital_status_value

12.1.28. partner_name - n - 255

12.1.29. birthday: bigint

12.1.30. anniversary: bigint

12.1.31. notes - n - 2000

12.1.32. original_lead_entity_id

12.1.33. original_lead_entity_type

12.1.34. original_lead_record_id

12.1.35. last_campaign_date: bigint

12.1.36. marketing_material: bit

12.1.37. currency_id

12.1.38. credit_limit :money

12.1.39. credit_hold: bit

12.1.40. payment_terms_value

12.1.41. payment_terms_label

12.1.42. shipping_method_value

12.1.43. shipping_method_label

12.1.44. contact_method_value

12.1.45. contact_method_label

12.1.46. allow_send_email - bit

12.1.47. allow_follow_email - bit

12.1.48. allow_bulk_email - bit

12.1.49. allow_phone - bit

12.1.50. allow_fax - bit

12.1.51. allow_mail - bit

12.1.52. owner_id

12.1.53. owner_type - smallint

12.1.54. follow - bit

12.1.55. lead_id

12.2. ain_contact_cases

12.2.1. ain_contact_id

12.2.2. ain_case_id

12.3. ain_contact_opportunities

12.3.1. ain_contact_id

12.3.2. ain_opportunity_id

12.4. ain_contact_entitilements

12.4.1. ain_contact_id

12.4.2. ain_entitilement_id

13. Dynamic

13.1. ain_dynamic_pages

13.1.1. id

13.1.2. title

13.1.3. url

13.1.4. layout - ntext

13.1.4.1. Definition Json

13.1.4.1.1. [1]: Component

14. BUSINESS FLOW

14.1. ain_business_process_flows

14.1.1. entity_id

14.1.2. name - n - 255

14.2. ain_business_process_stages

14.2.1. business_process_flow_id

14.2.2. name

14.2.3. stage_order - int

14.2.3.1. stage 1,2,3,4...

14.2.4. description

14.3. ain_business_process_steps

14.3.1. business_process_stage_id

14.3.2. entity_field_id

14.3.3. is_required - bit

14.4. ain_business_process_trackings

14.4.1. entity_id

14.4.2. business_process_flow_id

14.4.3. business_process_stage_id

14.4.4. entity_record_id

14.4.5. name_entity

15. Activities

15.1. ain_activities_appointment_detail

15.1.1. activities_appointment_id

15.1.2. entity_id

15.1.3. entity_type

15.1.4. entity_record_id

15.1.5. type

15.1.5.1. required

15.1.5.2. regarding

15.1.5.3. optional

15.2. ain_activities_task

15.2.1. subject

15.2.2. description

15.2.3. due_date

15.2.4. priority

15.2.4.1. normal

15.2.4.2. high

15.2.4.3. low

15.2.5. owner_type

15.3. ain_activities_phone_calls

15.3.1. description - nvarchar(2000)

15.3.2. due_date - bigint

15.3.3. call_with

15.3.4. entity_id

15.3.5. entity_type

15.3.6. entity_record_id

15.3.7. direction

15.3.7.1. incoming

15.3.7.2. outgoing

15.4. ain_activities_posts

15.4.1. post_content - nvarchar(1000)

15.4.2. entity_id

15.4.3. entity_type

15.4.4. entity_record_id

15.4.5. parent_id

15.5. ain_activities_email

15.5.1. from_email - (map with userID) - guid

15.5.2. subject_name

15.5.3. due_date: bigint

15.5.4. priority

15.5.5. owner_type

15.5.6. body - nvarchar(max)

15.5.7. regarding_entity_id

15.5.8. regarding_entity_type

15.5.9. regarding_entity_record_id

15.5.10. sender_id - guid

15.6. ain_activities_appointment

15.6.1. subject

15.6.2. location

15.6.3. priority

15.6.4. owner_type

15.6.5. start_time

15.6.6. end_time

15.6.7. duration_value

15.6.8. duration_label

15.6.9. description

15.7. ain_activities_email_header

15.7.1. activities_email_id

15.7.2. email

15.7.3. email_type

15.7.3.1. cc

15.7.3.2. to

15.7.3.3. bcc

15.7.4. entity_type

15.7.5. entity_id

15.8. ain_activities_attachment

15.8.1. file_name

15.8.2. file_size

15.8.3. file_path

15.8.4. type

15.8.4.1. activity_email

15.8.4.2. activity_appointment

15.8.5. activities_mail_id

15.9. ain_activities_appointment

15.9.1. subject

15.9.2. location

15.9.3. priority

15.9.4. owner_type

15.9.5. start_time

15.9.6. end_time

15.9.7. duration_value

15.9.8. duration_label

15.9.9. description

16. Database Convention

16.1. active = 1

16.2. deactive = 0

16.3. id : guid

16.4. date: timestamp

16.5. string: nvarchar

16.5.1. email,file: nvarchar(255)

16.6. avatar: base 64

16.7. ain_crm_[tablename]

16.8. colume name: use lower case

16.9. Words are separated with underscores

17. Relation Ship

17.1. Sites (1) - (n) User

17.2. Company (n) - (n) Site

17.3. Business_unit_id (1) - (0..n) User

17.4. User (1) - (0..1) Position

17.5. Security_role (1) - (1) Business Unit

18. Not Complete

18.1. ain_account_connection

18.2. ain_industries

18.3. ain_leads

18.4. ain_entititlements

18.5. ain_marketing_lists

18.6. ain_account_childs

19. Quotes

19.1. ain_quotes

19.1.1. quote_code: n 20

19.1.2. revision_id: int

19.1.3. name

19.1.4. currency_id

19.1.5. price_list_id

19.1.6. shipping_method_value

19.1.7. shipping_method_label

19.1.8. payment_terms_value

19.1.9. payment_terms_label

19.1.10. bill_to_address: same account address - 7 fields

19.1.11. ship_to_value

19.1.12. ship_to_label

19.1.13. ship_to_address: same bill_to_address above

19.1.14. detail_amount: same detail amount opportunity - 7 fields

19.1.15. total_amount: money

19.1.16. effective_from: bigint

19.1.17. effective_to: bigint

19.1.18. owner_id

19.1.19. owner_type: smallint

19.1.20. opportunity_id

19.1.21. potential_entity_id

19.1.22. potential_entity_type: smallint

19.1.23. potential_entity_recored_id

19.1.24. description: n 2000

19.2. ain_quote_products

19.2.1. product_id

19.2.2. unit_id

19.2.3. price_per_unit: money

19.2.4. quantity: decimal

19.2.5. discount: money

19.2.6. extend_amount: money

20. dsa

21. Assign & Follows

21.1. ain_user_follows

21.1.1. user_team_id - guid

21.1.2. entity_id - guid

21.1.2.1. Account, contact...., reference to table entity

21.1.3. entity_type - smallint

21.1.3.1. user or team

21.1.4. entity_record_id - guid

21.2. ain_user_assigns

21.2.1. user__team_id - guid

21.2.2. entity_id - guid

21.2.2.1. Account, contact...., reference to table entity

21.2.3. entity_type - smallint

21.2.3.1. user or team

21.2.4. entity_record_id - guid

22. Business

22.1. business_unit

22.1.1. id

22.1.2. name

22.1.3. parent_id

22.1.4. main_phone

22.1.5. other_phone

22.1.6. fax

22.1.7. email

22.1.8. website

22.1.9. bill_to_address_street_1

22.1.10. bill_to_address_street_2

22.1.11. bill_to_address_street_3

22.1.12. ship_to_address_street_1

22.1.13. ship_to_address_street_2

22.1.14. ship_to_address_street_3

22.1.15. status

22.1.15.1. active

22.1.15.2. deactive

22.1.16. team_id

22.1.17. (list_facility_equipment)

22.2. business_closure

22.2.1. id

22.2.2. name

22.2.3. start_time

22.2.4. end_time

22.2.5. duration

22.2.6. status

22.3. fiscal_year

22.3.1. id

22.3.2. fiscal_year

22.3.3. start_time

22.3.4. end_time

22.3.5. prefix

22.3.6. postfix

22.3.7. year_format (const)

22.3.7.1. YY

22.3.7.2. YYYY

22.3.8. period (const)

22.3.8.1. Q1

22.3.8.2. P1

22.3.9. display_format (const)

23. Common

23.1. timezones (gmt)

23.1.1. id

23.1.2. name

23.1.3. display_order

23.1.4. status

23.1.4.1. active

23.1.4.2. deactive

23.1.5. Country

24. Facility Equipment

24.1. facility_equipment_detail

24.1.1. id

24.1.2. date

24.1.3. work_hour_from / work_hour_to (unixtime)

24.1.3.1. case one day

24.1.3.1.1. Minwork: 1h

24.1.3.1.2. Validate

24.1.3.1.3. Break: 15' <= time <= minwork

24.1.3.2. case same working day

24.1.3.3. case not same working day

24.1.4. type (constant)

24.1.4.1. WORKING_HOUR

24.1.4.2. BREAK_TIME

24.1.5. timezone

24.2. facility_equipments

24.2.1. id

24.2.2. name

24.2.3. site_id

24.2.4. business_unit_id

24.2.5. primary_email

24.2.6. timezone

24.2.7. description

24.2.8. status

25. Security

25.1. role_field_member (step 3)

25.1.1. id

25.1.2. role_field_id

25.1.3. user_id

25.2. security_role_field_action (step 2)

25.2.1. id

25.2.2. role_field_id

25.2.3. resource_name

25.2.4. field_name

25.2.5. permission (bitwise)

25.2.6. status

25.3. user_security_roles

25.3.1. id

25.3.2. user_id

25.3.3. security_role_id

25.4. security_role_fields (step 1)

25.4.1. id

25.4.2. name

25.4.3. status

25.5. security_role_permission_action

25.5.1. id

25.5.2. security_role_id

25.5.3. resource_name

25.5.4. entity_id

25.5.5. permission (bitwise)

25.5.6. status

25.5.6.1. active

25.5.6.2. deactive

25.6. security_roles

25.6.1. id

25.6.2. name

25.6.3. status

25.6.3.1. active

25.6.3.2. deactive

26. Accounts

26.1. ain_account_entitlements

26.1.1. account_id

26.1.2. entitlement_id

26.2. ain_account

26.2.1. 1. id (nvarchar(160))

26.2.2. 2. name (nvarchar)

26.2.3. 3. phone - nvarchar(50)

26.2.4. 4. fax - nvarchar(50)

26.2.5. 5. website - nvarchar(255)

26.2.6. 6. account_parent_id - guid

26.2.7. 7. ticket_symbol - nvarchar(10)

26.2.8. 8. address_street_1 - nvarchar(1000)

26.2.9. 9. address_street_2 - varchar(1000)

26.2.10. 10. address_street_3 - varchar(1000)

26.2.11. 11. city (input) - nvarchar(255)

26.2.12. 12. state_id - guid

26.2.13. 13. province_id - guid

26.2.14. 14. postal_code - nvarchar(10)

26.2.15. 15. country_id - guid

26.2.16. 16. lat - nvarchar(50)

26.2.17. 17. lng - nvarchar(50)

26.2.18. 18. industry_value

26.2.19. 19. industry_label

26.2.20. 20. sic_code - nvarchar(20)

26.2.21. 21. description - nvarchar(1000)

26.2.22. 22. annual_revenue - money

26.2.23. 23. number_of_employees - int

26.2.24. 24. owner - guid

26.2.25. 25. owner_type - smallint

26.2.25.1. 1: user

26.2.25.1.1. 2: team

26.2.26. 26. primary_contact_id - guid

26.2.27. 27. email - nvarchar(255)

26.2.28. 28. business_phone - nvarchar(50)

26.2.29. 29. lead_id - guid

26.2.30. 30. last_campaign_date - bigint

26.2.31. 31. marketing_materials - bit

26.2.32. 32. contact_method_value - bigint

26.2.33. 33. contact_method_label - nvarchar(300)

26.2.34. 34. payment_term_value - bigint

26.2.35. 35. payment_term_label - nvarchar(255)

26.2.36. 36. shipping_method_value - bigint

26.2.37. 37. shipping_method_label - nvarchar(255)

26.2.38. 38. allow_send_email - bit

26.2.39. 39. allow_follow_email - bit

26.2.40. 40. allow_bulk_email - bit

26.2.41. 41. allow_phone - bit

26.2.42. 42. allow_fax - bit

26.2.43. 43. allow_mail - bit

26.2.44. 44. currency_id - guid

26.2.45. 45. credit_limit - money

26.2.46. 46. credit_hold - bit

26.2.47. 49. follow - bit

26.3. ain_account_contacts

26.3.1. account_id

26.3.2. contact_id

26.4. ain_account_opportunities

26.4.1. account_id

26.4.2. oppotunity_id

26.5. ain_account_cases

26.5.1. account_id

26.5.2. case_id

27. Country

27.1. provinces

27.1.1. id

27.1.2. name

27.1.3. code

27.1.4. lat

27.1.5. long

27.1.6. status

27.1.6.1. active

27.1.6.2. deactive

27.1.7. country_id

27.2. wards

27.2.1. id

27.2.2. name

27.2.3. status

27.2.4. district_id

27.3. districts

27.3.1. id

27.3.2. name

27.3.3. status

27.3.3.1. active

27.3.3.2. deactive

27.3.4. province_id

27.4. states

27.4.1. id

27.4.2. name

27.4.3. code

27.4.4. lat

27.4.5. long

27.4.6. status

27.4.6.1. active

27.4.6.2. deactive

27.4.7. country_id

27.5. countries

27.5.1. id

27.5.2. name

27.5.3. code

27.5.4. lat

27.5.5. long

27.5.6. status

27.5.6.1. active

27.5.6.2. deactive

27.5.7. is_has_state

27.5.8. is_has_province

27.6. sites

27.6.1. name

27.6.2. main_phone

27.6.3. other_phone

27.6.4. fax

27.6.5. timezone

27.6.6. address_street_1

27.6.7. address_street_2

27.6.8. address_street_3

27.6.9. city (input)

27.6.10. state/province

27.6.11. country_id

27.6.12. postcode

27.6.13. status

27.6.13.1. active

27.6.13.2. deactive

27.6.14. email

27.6.15. id

28. Currencies

28.1. currencies

28.1.1. currency_master_data_id

28.1.2. id

28.1.3. exchange_rate

28.2. currency_master_data

28.2.1. id

28.2.2. country

28.2.3. code

28.2.4. name

28.2.5. symbol

28.2.6. currency_precision

29. Organization

29.1. positions

29.1.1. id

29.1.2. name

29.1.3. parent_id

29.1.4. description

29.1.5. status

29.1.5.1. active

29.1.5.2. deactive

29.2. companies

29.2.1. id

29.2.2. name

29.2.3. address

29.2.4. prefer_address

29.2.5. other_address

29.2.6. main_phone

29.2.7. fax

29.2.8. status

29.2.8.1. active

29.2.8.2. deactive

29.3. user_profiles

29.3.1. id

29.3.2. username

29.3.3. fullname

29.3.4. title

29.3.5. primary_email

29.3.6. mobile_phone

29.3.7. main_phone

29.3.8. home_phone

29.3.9. order_phone

29.3.10. second_email

29.3.11. prefered_phone

29.3.12. fax

29.3.13. avatar

29.3.13.1. scale image?

29.3.14. address

29.3.15. prefer_address

29.3.16. other_address

29.3.17. company_id

29.3.18. sites_id

29.3.19. business_unit_id

29.3.20. manager_id

29.3.21. *teams: save to list/json, reference to table TEAM

29.3.22. *roles: save to list/json, reference to table ROLE

29.3.23. last_login_on

29.3.24. status

29.3.24.1. active

29.3.24.2. deactive

29.4. users

29.4.1. id

29.4.2. user_domain

29.5. teams

29.5.1. id

29.5.2. name

29.5.3. business_unit_id

29.5.4. administrator_user_id

29.5.5. description