pmp

Tables (18)

billing_plan (Untitled8)

  • billing_plan_id (Key) — Primary key — NOT NULL
  • name (Field)
  • meta (Field2)

billing_status (Untitled9)

  • billing_status_id (Key) — Primary key — NOT NULL
  • org_id (Key2) — Foreign key → org.org_id — NOT NULL
  • billing_plan_id (Key3) — Foreign key → billing_plan.billing_plan_id — NOT NULL
  • start_date (Field)
  • end_date (Field2)

credential (Untitled6)

  • credential_id (Key2) — Primary key — NOT NULL
  • org_id (Key) — Foreign key → org.org_id — NOT NULL
  • credential_type_id (Key3) — Foreign key → credential_type.credential_type_id — NOT NULL
  • credential (JSONField)
  • platform (Field2)
  • name (Field3)
  • description (Field4)

credential_type (Untitled15)

  • credential_type_id (Key) — Primary key — NOT NULL
  • name (Field)
  • form (Field2)

invitation (Untitled13)

  • invite_id (Key) — Primary key — NOT NULL
  • org_id (Key2) — Foreign key → user-org.org_id — NOT NULL
  • user_id (Key22) — Foreign key → user-org.user_id — NOT NULL
  • permission_id (Key3) — Foreign key → user-org.permission_id — NOT NULL
  • target_user_id (Key4) — Foreign key → user.user_id — NOT NULL
  • invitation_key (Field)

keyword_analysis (Untitled17)

  • keyword_analysis_id (Key) — Primary key — NOT NULL
  • org_id (Key2) — Foreign key → org.org_id — NOT NULL
  • keywords (Field)
  • result_s3_path (Field2)
  • status (Field3)
  • status_message (Field4)

mapped_catalog (Untitled19)

  • mapped_catalog_id (Key) — Primary key — NOT NULL
  • credential_type_id (Key2) — Foreign key → credential_type.credential_type_id — NOT NULL
  • name (Field)
  • type (Field2)

mapped_destination (Untitled16)

  • mapped_destination_id (Key) — Primary key — NOT NULL
  • org_id (Key2) — Foreign key → org.org_id — NOT NULL
  • credential_id (Key22) — Foreign key → credential.credential_id — NOT NULL
  • name (Field)
  • job_meta (Field2)

mapped_source (Untitled11)

  • mapped_source_id (Key) — Primary key — NOT NULL
  • org_id (Key2) — Foreign key → org.org_id — NOT NULL
  • credential_id (Key22) — Foreign key → credential.credential_id — NOT NULL
  • name (Field)
  • job_meta (Field2)

mapped_source_destination (Untitled18)

  • id (Key4) — Primary key — NOT NULL
  • org_id (Key) — Foreign key → org.org_id — NOT NULL
  • mapped_source_id (Key2) — Foreign key → mapped_source.mapped_source_id — NOT NULL
  • mapped_destination_id (Key3) — Foreign key → mapped_destination.mapped_destination_id — NOT NULL
  • status (Field2)
  • job_meta (Field3)

org (Untitled3)

  • org_id (Key) — Primary key — NOT NULL
  • name (Field)
  • image (Field3)
  • description (Field2)

permission (Untitled5)

  • permission_id (Key) — Primary key — NOT NULL
  • name (Field)
  • value (Field2)

report (Untitled12)

  • Key — Primary key — NOT NULL
  • report_group_id (Key2) — Foreign key → report_group.report_group_id — NOT NULL
  • status (Field)
  • status_message (Field4)
  • result_s3_path (Field3)
  • meta (JSONField)

report_creds (Untitled14)

  • Key — Primary key — NOT NULL
  • credential_id (Key2) — Foreign key → credential.credential_id — NOT NULL
  • report_id (Key3) — Foreign key → report_run_info.report_id — NOT NULL
  • credential_type_id (Key32) — Foreign key → credential.credential_type_id — NOT NULL

report_group (Untitled2)

  • report_group_id (Key) — Primary key — NOT NULL
  • org_id (Key2) — Foreign key → org.org_id — NOT NULL
  • name (Field)
  • Field2

report_run_info (Untitled7)

  • report_id (Key) — Primary key — NOT NULL
  • start_date (Field)
  • end_date (Field2)
  • job_info (JSONField)
  • report_group_id (Key3) — Foreign key → report_group.report_group_id — NOT NULL

user (Untitled)

  • user_id (Key) — Primary key — NOT NULL
  • username (Field)
  • password (Field2)
  • first_name (Field3)
  • surname (Field5)

user-org (Untitled4)

  • org_id (Key) — Foreign key → org.org_id — NOT NULL
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL
  • permission_id (Key3) — Foreign key → permission.permission_id — NOT NULL