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