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