Good Ground
Tables (27)
counsel.career (Untitled7)
- id (Key3) — Primary key — NOT NULL
- career_year (Field)
- company_name (Field2)
- career_description (Field3)
- partner_id (Key) — Foreign key → res.partner.id — NOT NULL
counsel.certificate (Untitled8)
- id (Key3) — Primary key — NOT NULL
- certificate_name (Field)
- publisher_name (Field2)
- attachment_id (Field3)
- partner_id (Key) — Foreign key → res.partner.id — NOT NULL
counsel.detail_field (Untitled5)
- id (Key2) — Primary key — NOT NULL
- detail_field (Field)
- partner_id (Key) — Foreign key → res.partner.id — NOT NULL
counsel.education (Untitled6)
- id (Key3) — Primary key — NOT NULL
- education_category (Field)
- education_state (Field2)
- school_name (Field3)
- major_name (Field4)
- partner_id (Key) — Foreign key → res.partner.id — NOT NULL
counsel.field_partner_rel (Untitled4)
- field_id (Key) — Foreign key → counsel.fleld.id — NOT NULL
- partner_id (Key2) — Foreign key → res.partner.id — NOT NULL
counsel.fleld (Untitled3)
- id (Key) — Primary key — NOT NULL
- field_id (Field)
- field_name (Field2)
counsel.location (Untitled9)
- id (Key3) — Primary key — NOT NULL
- address (Field)
- longitude (Field2)
- latitude (Field3)
- buffer_km (Field4)
- partner_id (Key) — Foreign key → res.partner.id — NOT NULL
counsel.note (Untitled25)
- id (Key3) — Primary key — NOT NULL
- name (Field)
- sequence (Field2)
- counsel_hour (Field3)
- counsel_type (Field4)
- counsel_place (Field8)
- counsel_date (Field9)
- state (Field10)
- counsel_note1 (Field11)
- counsel_note2 (Field12)
- counsel_note3 (Field13)
- counsel_note4 (Field14)
- next_date (Field15)
- next_time (Field16)
- tag_ids (Field17)
- note_topic_id (Key) — Foreign key → crm.lead.id — NOT NULL
counsel.schedule (Untitled10)
- id (Key2) — Primary key — NOT NULL
- schedule_type (Field)
- day (Field2)
- start_time (Field3)
- end_time (Field4)
- parnter_id (Key3) — Foreign key → res.partner.id — NOT NULL
counseldesk.session (Untitled14)
- id (Key) — Primary key — NOT NULL
- team_id (Field2)
- description (Field3)
- active (Field4)
- session_type_id (Field5)
- tag_ids (Field6)
- color (Field8)
- kanban_state (Field9)
- partner_sessions (Field12)
- attachment_number (Field13)
- priority (Field17)
- stage_id (Field18)
- assign_date (Field19)
- assign_hours (Field20)
- close_date (Field21)
- close_hours (Field22)
- sla_id (Field23)
- sla_name (Field24)
- deadline (Field25)
- sla_active (Field26)
- sla_fail (Field27)
- website_message_ids (Field28)
counseldesk.session.type (Untitled13)
- id (Key) — Primary key — NOT NULL
- name (Field)
- sequence (Field2)
counseldesk.tag (Untitled12)
- id (Key) — Primary key — NOT NULL
- name (Field)
- description (Field2)
- color (Field3)
crm.lead (Untitled30)
- id (Key) — Primary key — NOT NULL
- consult_status (Field4)
- consult_title (Field5)
- consult_contents (Field6)
- consult_date (Field7)
- partner_counselee_id (Key2) — Foreign key → res.partner.id — NOT NULL
- partner_counsellor_id (Key3) — Foreign key → res.partner.id — NOT NULL
digest.digest (Untitled11)
- kpi_counseldesk_sessions_closed (Field)
- kpi_counseldesk_sessions_closed_value (Field2)
forum.forum (Untitled29)
- id (Key) — Primary key — NOT NULL
- name (Field)
forum.post (Untitled31)
- id (Key) — Primary key — NOT NULL
- name (Field3)
- content (Field)
- plain_content (Field2)
- views (Field4)
- child_count (Field5)
- self_reply (Field6)
- forum_id (Key3) — Foreign key → forum.forum.id — NOT NULL
- parent_id (Key2) — Foreign key → forum.post.id — NOT NULL
- write_uid (Key4) — Foreign key → res.users.id — NOT NULL
forum.tag (Untitled15)
- id (Key) — Primary key — NOT NULL
- name (Field)
- posts_count (Field2)
- forum_id (Key2) — Foreign key → forum.forum.id — NOT NULL
res.company (Untitled27)
- id (Key) — Primary key — NOT NULL
- name (Field)
- partner_id (Key2) — Foreign key → res.partner.id — NOT NULL
res.company_users_rel (Untitled28)
- cid (Key) — Foreign key → res.company.id — NOT NULL
- user_id (Key2) — Foreign key → res.users.id — NOT NULL
res.partner (Untitled2)
- id (Key) — Primary key — NOT NULL
- email (Field3)
- phone (Field4)
- user_gb (Field5)
- gender (Field7)
- newsletter (Field8)
- session_count (Field9)
- total_session (Field10)
- last_session (Field11)
- counsellor_id (Field12)
- current_counsel_id (Field13)
- counsel_session (Field14)
- birthday (Field15)
- company_id (Key2) — Foreign key → res.company.id — NOT NULL
- user_id (Key3) — Foreign key → res.users.id — NOT NULL
res.users (Untitled)
- id (Key) — Primary key — NOT NULL
- active (Field)
- login (Field2)
- password (Field3)
- social_id (Field6)
- social_name (Field7)
- counseldesk_target_closed (Field8)
- counseldesk_target_rating (Field9)
- counseldesk_target_success (Field10)
- company_id (Key2) — Foreign key → res.company.id — NOT NULL
- partner_id (Key3) — Foreign key → res.partner.id — NOT NULL
sms.auth (Untitled20)
- id (Key2) — Primary key — NOT NULL
- name (Field)
- number (Field2)
- user_input (Field3)
- date (Field4)
- check (Field5)
- partner_id (Key) — Foreign key → res.partner.id — NOT NULL
survey.label (Untitled24)
- id (Key2) — Primary key — NOT NULL
- value (Field3)
- description (Field)
- question_id (Key) — Foreign key → survey.question.id — NOT NULL
survey.page (Untitled26)
- id (Key2) — Primary key — NOT NULL
- title (Field)
- description (Field3)
- survey_id (Key) — Foreign key → survey.survey.id — NOT NULL
survey.question (Untitled23)
- id (Key) — Primary key — NOT NULL
- is_reverse (Field)
- answer_type (Field2)
- question (Field4)
- description (Field5)
- answer_type (Field6)
- page_id (Key2) — Foreign key → survey.page.id — NOT NULL
survey.survey (Untitled22)
- id (Key) — Primary key — NOT NULL
- caution_description (Field)
- title (Field2)
- users_can_go_back (Field3)
- description (Field4)
survey.user_input (Untitled21)
- id (Key3) — Primary key — NOT NULL
- marry (Field)
- city (Field2)
- county (Field3)
- token (Field6)
- surver_id (Key2) — Foreign key → survey.survey.id — NOT NULL
- write_uid (Key) — Foreign key → res.users.id — NOT NULL