Skip to content

Drop all Gauzy tables in PostgreSQL manually

RAHUL RATHORE edited this page Jan 16, 2022 · 45 revisions
drop table if exists "accounting_template" cascade;
drop table if exists "appointment_employee" cascade;
drop table if exists "approval_policy" cascade;
drop table if exists "availability_slot" cascade;
drop table if exists "candidate_criterion_rating" cascade;
drop table if exists "candidate_document" cascade;
drop table if exists "candidate_education" cascade;
drop table if exists "candidate_experience" cascade;
drop table if exists "candidate_feedback" cascade;
drop table if exists "candidate_interview" cascade;
drop table if exists "candidate_interviewer" cascade;
drop table if exists "candidate_personal_quality" cascade;
drop table if exists "candidate_skill" cascade;
drop table if exists "candidate_source" cascade;
drop table if exists "candidate_technology" cascade;
drop table if exists "candidate" cascade;
drop table if exists "contact" cascade;
drop table if exists "country" cascade;
drop table if exists "currency" cascade;
drop table if exists "custom_smtp" cascade;
drop table if exists "deal" cascade;
drop table if exists "email_template" cascade;
drop table if exists "email_sent" cascade;
drop table if exists "employee_appointment" cascade;
drop table if exists "employee_award" cascade;
drop table if exists "employee_upwork_job_search_criterion" cascade;
drop table if exists "job_preset_upwork_job_search_criterion" cascade;
drop table if exists "job_preset" cascade;
drop table if exists "job_search_category" cascade;
drop table if exists "job_search_occupation" cascade;
drop table if exists "employee_proposal_template" cascade;
drop table if exists "employee_recurring_expense" cascade;
drop table if exists "employee_setting" cascade;
drop table if exists "employee" cascade;
drop table if exists "equipment_sharing_policy" cascade;
drop table if exists "equipment_sharing" cascade;
drop table if exists "equipment" cascade;
drop table if exists "estimate_email" cascade;
drop table if exists "event_type" cascade;
drop table if exists "expense_category" cascade;
drop table if exists "expense" cascade;
drop table if exists "feature_organization" cascade;
drop table if exists "feature" cascade;
drop table if exists "goal_general_setting" cascade;
drop table if exists "goal_kpi_template" cascade;
drop table if exists "goal_kpi" cascade;
drop table if exists "goal_template" cascade;
drop table if exists "goal_time_frame" cascade;
drop table if exists "goal" cascade;
drop table if exists "image_asset" cascade;
drop table if exists "income" cascade;
drop table if exists "integration_entity_setting_tied" cascade;
drop table if exists "integration_entity_setting" cascade;
drop table if exists "integration_map" cascade;
drop table if exists "integration_setting" cascade;
drop table if exists "integration_tenant" cascade;
drop table if exists "integration_type" cascade;
drop table if exists "integration" cascade;
drop table if exists "invite" cascade;
drop table if exists "invoice_estimate_history" cascade;
drop table if exists "invoice_item" cascade;
drop table if exists "invoice" cascade;
drop table if exists "key_result_template" cascade;
drop table if exists "key_result_update" cascade;
drop table if exists "key_result" cascade;
drop table if exists "language" cascade;
drop table if exists "employee_level" cascade;
drop table if exists "organization_award" cascade;
drop table if exists "organization_contact" cascade;
drop table if exists "organization_department" cascade;
drop table if exists "organization_document" cascade;
drop table if exists "organization_employment_type" cascade;
drop table if exists "organization_language" cascade;
drop table if exists "organization_position" cascade;
drop table if exists "organization_project" cascade;
drop table if exists "organization_recurring_expense" cascade;
drop table if exists "organization_sprint" cascade;
drop table if exists "organization_team_employee" cascade;
drop table if exists "organization_team" cascade;
drop table if exists "organization_vendor" cascade;
drop table if exists "organization" cascade;
drop table if exists "payment" cascade;
drop table if exists "pipeline_stage" cascade;
drop table if exists "pipeline" cascade;
drop table if exists "product_category_translation" cascade;
drop table if exists "product_category" cascade;
drop table if exists "product_option_group" cascade;
drop table if exists "product_option" cascade;
drop table if exists "product_option_group_translation" cascade;
drop table if exists "product_option_translation" cascade;
drop table if exists "product_variant_setting" cascade;
drop table if exists "merchant" cascade;
drop table if exists "product_type_translation" cascade;
drop table if exists "product_type" cascade;
drop table if exists "product_variant_price" cascade;
drop table if exists "product_variant" cascade;
drop table if exists "product" cascade;
drop table if exists "product_translation" cascade;
drop table if exists "proposal" cascade;
drop table if exists "report_category" cascade;
drop table if exists "report_organization" cascade;
drop table if exists "report" cascade;
drop table if exists "request_approval_employee" cascade;
drop table if exists "request_approval_team" cascade;
drop table if exists "request_approval" cascade;
drop table if exists "role_permission" cascade;
drop table if exists "role" cascade;
drop table if exists "skill" cascade;
drop table if exists "tag" cascade;
drop table if exists "task" cascade;
drop table if exists "tenant_setting" cascade;
drop table if exists "tenant" cascade;
drop table if exists "time_off_policy" cascade;
drop table if exists "time_off_request" cascade;
drop table if exists "activity" cascade;
drop table if exists "screenshot" cascade;
drop table if exists "time_log" cascade;
drop table if exists "time_slot" cascade;
drop table if exists "time_slot_minute" cascade;
drop table if exists "timesheet" cascade;
drop table if exists "user_organization" cascade;
drop table if exists "password_reset" cascade;
drop table if exists "user" cascade;
drop table if exists "warehouse_product" cascade;
drop table if exists "warehouse" cascade;
drop table if exists "warehouse_product_variant" cascade;
drop table if exists "import-record" cascade;
drop table if exists "import-history" cascade;
drop table if exists "knowledge_base" cascade;
drop table if exists "knowledge_base_article" cascade;
drop table if exists "knowledge_base_author" cascade;
drop table if exists "changelog" cascade;
drop table if exists "tag_candidate" cascade;
drop table if exists "employee_job_preset" cascade;
drop table if exists "organization_project_employee" cascade;
drop table if exists "tag_employee" cascade;
drop table if exists "organization_contact_employee" cascade;
drop table if exists "time_off_policy_employee" cascade;
drop table if exists "time_off_request_employee" cascade;
drop table if exists "employee_tasks_task" cascade;
drop table if exists "equipment_shares_employees" cascade;
drop table if exists "equipment_shares_teams" cascade;
drop table if exists "tag_equipment" cascade;
drop table if exists "tag_event_type" cascade;
drop table if exists "tag_organization_expense_category" cascade;
drop table if exists "tag_expense" cascade;
drop table if exists "tag_income" cascade;
drop table if exists "integration_integration_type" cascade;
drop table if exists "tag_integration" cascade;
drop table if exists "invite_organization_project" cascade;
drop table if exists "invite_organization_contact" cascade;
drop table if exists "invite_organization_department" cascade;
drop table if exists "tag_invoice" cascade;
drop table if exists "tag_employee_level" cascade;
drop table if exists "tag_organization_contact" cascade;
drop table if exists "tag_organization_department" cascade;
drop table if exists "organization_department_employee" cascade;
drop table if exists "candidate_department" cascade;
drop table if exists "tag_organization_employment_type" cascade;
drop table if exists "organization_employment_type_employee" cascade;
drop table if exists "candidate_employment_type" cascade;
drop table if exists "tag_organization_position" cascade;
drop table if exists "tag_organization_project" cascade;
drop table if exists "tag_organization_team" cascade;
drop table if exists "organization_team_tasks_task" cascade;
drop table if exists "tag_organization_vendor" cascade;
drop table if exists "tag_organization" cascade;
drop table if exists "tag_payment" cascade;
drop table if exists "tag_merchant" cascade;
drop table if exists "warehouse_merchant" cascade;
drop table if exists "product_variant_options_product_option" cascade;
drop table if exists "tag_product" cascade;
drop table if exists "product_gallery_item" cascade;
drop table if exists "tag_proposal" cascade;
drop table if exists "tag_request_approval" cascade;
drop table if exists "skill_employee" cascade;
drop table if exists "skill_organization" cascade;
drop table if exists "tag_task" cascade;
drop table if exists "task_employee" cascade;
drop table if exists "task_team" cascade;
drop table if exists "time_slot_time_logs" cascade;
drop table if exists "tag_user" cascade;
drop table if exists "tag_warehouse" cascade;