Orbis

Tables (50)

alarm

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • receiver_id — uuid
  • sender_id — uuid

bid_result

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • sum_score — integer
  • project_opportunity_id — bigint

bid_result_competitor_score

  • bid_result_id — bigint — NOT NULL
  • sum_score — integer

billing

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • billing_amount — bigint
  • collected_at — date
  • invoice_image_id — bigint
  • issued_at — date
  • remarks — varchar(255)
  • requested_issue_date — date
  • status — varchar(255)
  • APPROVED::character — varying
  • ISSUED::character — varying
  • COLLECTED::character — varying)::text))
  • order_report_id — bigint
  • approval_status — smallint

chat_messages

  • id — uuid — NOT NULL
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • actions — text
  • answer_status — varchar(255)
  • content — text — NOT NULL
  • evidences — text
  • role — varchar(255) — NOT NULL
  • route — varchar(255)
  • thread_id — varchar(255)
  • typed_evidences — text
  • session_id — uuid — NOT NULL

chat_sessions

  • id — uuid — NOT NULL
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • last_message_at — timestamp(6)
  • last_thread_id — varchar(255)
  • title — varchar(255) — NOT NULL
  • user_id — varchar(255) — NOT NULL

collection

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • billing_id — bigint

company

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • address — varchar(255)
  • business_registration_number — varchar(255)
  • category — varchar(255)
  • SOLUTION::character — varying
  • ETC::character — varying)::text))
  • code — varchar(255) — NOT NULL
  • company_type — varchar(255) — NOT NULL
  • PARTNER::character — varying)::text))
  • name — varchar(100) — NOT NULL
  • sector — varchar(255)
  • PRIVATE::character — varying
  • OVERSEAS::character — varying)::text))

company_manager

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • department — varchar(50)
  • email — varchar(100) — NOT NULL
  • mobile_phone — varchar(255)
  • name — varchar(50) — NOT NULL
  • office_phone — varchar(255)
  • position — varchar(255)
  • role — varchar(255)
  • company_id — bigint

contract

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • contract_amount — bigint
  • contract_date — date
  • maintenance_condition — varchar(255)
  • proposal_type — varchar(255)
  • SI::character — varying)::text))
  • contract_file_id — bigint
  • order_report_id — bigint
  • sales_representative_id — uuid
  • status — varchar(255)
  • PENDING::character — varying
  • APPROVED::character — varying
  • REJECTED::character — varying
  • CANCELED::character — varying)::text))

contract_module_item

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • product_class — varchar(255)
  • DASHBOARD::character — varying
  • DATACENTER::character — varying
  • RCA::character — varying
  • DCA::character — varying
  • ITSM::character — varying
  • ITAM::character — varying
  • SUPPORTING_TOOLS::character — varying
  • CLOUD::character — varying
  • BSM::character — varying
  • E2E::character — varying
  • ETC::character — varying)::text))
  • product_module_name — varchar(255)
  • quantity — integer — NOT NULL
  • total_price — bigint — NOT NULL
  • unit_price — bigint — NOT NULL
  • contract_id — bigint — NOT NULL
  • product_module_id — bigint — NOT NULL

customer_support

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • activity_content — text
  • activity_end_time — timestamp(6)
  • activity_start_time — timestamp(6)
  • activity_type — varchar(255) — NOT NULL
  • REQUEST::character — varying)::text))
  • customer_company_code — bigint
  • registrant_id — uuid
  • remarks — varchar(1000)
  • maintenance_id — bigint
  • request_id — bigint
  • customer_company_id — bigint — NOT NULL

customer_support_activity_file

  • request_id — bigint — NOT NULL
  • upload_file_id — bigint — NOT NULL

customer_support_other_department_user

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • role_description — varchar(255)
  • user_id — uuid — NOT NULL
  • customer_support_id — bigint

customer_support_request

  • request_id — bigint
  • approval_status — varchar(255) — NOT NULL
  • PENDING::character — varying
  • APPROVED::character — varying
  • REJECTED::character — varying
  • CANCELED::character — varying)::text))
  • customer_company_code — bigint
  • registrant_id — uuid
  • remarks — varchar(1000)
  • request_content — text
  • request_end_date — date
  • request_start_date — date
  • requester_id — uuid
  • sales_rep_id — uuid
  • support_manager_id — uuid
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • customer_company_id — bigint — NOT NULL

customer_support_request_file

  • request_id — bigint — NOT NULL
  • upload_file_id — bigint — NOT NULL

department

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • headquarters — varchar(255)
  • team — varchar(255)

license

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • end_date — date
  • license_status — varchar(255)
  • DEACTIVE::character — varying
  • ISSUED::character — varying)::text))
  • license_type — varchar(255)
  • TEMPORARY::character — varying
  • TRIAL::character — varying)::text))
  • price — bigint
  • product_class — varchar(255)
  • DASHBOARD::character — varying
  • DATACENTER::character — varying
  • RCA::character — varying
  • DCA::character — varying
  • ITSM::character — varying
  • ITAM::character — varying
  • SUPPORTING_TOOLS::character — varying
  • CLOUD::character — varying
  • BSM::character — varying
  • E2E::character — varying
  • ETC::character — varying)::text))
  • product_group — varchar(255)
  • product_name — varchar(255)
  • quantity — integer
  • start_date — date
  • total_price — bigint
  • customer_company_id — bigint
  • order_report_id — bigint
  • product_module_id — bigint
  • status — varchar(255)
  • PENDING::character — varying
  • APPROVED::character — varying
  • REJECTED::character — varying
  • CANCELED::character — varying)::text))

maintenance

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • acl_patch_status — boolean — NOT NULL
  • annual_amount — bigint
  • ap_count — integer
  • ap_version — varchar(255)
  • category — varchar(255)
  • contract_amount — bigint
  • contract_date — date
  • db_ha_status — boolean — NOT NULL
  • db_version — varchar(255)
  • end_date — date
  • es_count — integer
  • es_version — varchar(255)
  • importance — varchar(255)
  • MEDIUM::character — varying
  • LOW::character — varying)::text))
  • inspection_cycle — varchar(255)
  • QUARTERLY::character — varying
  • SEMI_ANNUALLY::character — varying
  • NONE::character — varying)::text))
  • is_remote — boolean — NOT NULL
  • location — varchar(255)
  • product_family — varchar(255)
  • ITSM::character — varying
  • Automation::character — varying
  • WSS::character — varying)::text))
  • rate — double
  • remarks — text
  • report_submitted — boolean — NOT NULL
  • start_date — date
  • type — varchar(255)
  • PAID::character — varying)::text))
  • upgrade_plan — varchar(255)
  • vuln_patch_status — boolean — NOT NULL
  • manager_primary_id — uuid
  • manager_secondary_id — uuid
  • project_id — bigint
  • regular_pm_id — uuid
  • sales_rep_id — uuid
  • contract_file_id — bigint
  • status — varchar(255)
  • PENDING::character — varying
  • APPROVED::character — varying
  • REJECTED::character — varying
  • CANCELED::character — varying)::text))

maintenance_amount_reason

  • id — bigint
  • amount — bigint
  • months — integer
  • quantity — integer
  • remarks — varchar(255)
  • product_module_id — bigint
  • quotation_id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)

maintenance_quotation

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • end_date — date
  • monthly_supply_price — bigint
  • payment_terms — varchar(255)
  • quotation_date — date
  • ref_no — varchar(255) — NOT NULL
  • sp_maintenance_cost — bigint
  • special_notes — text
  • start_date — date
  • total_amount — bigint
  • total_quotation_amount — bigint
  • project_id — bigint
  • status — varchar(255)
  • PENDING::character — varying
  • APPROVED::character — varying
  • REJECTED::character — varying
  • CANCELED::character — varying)::text))

maintenance_service_info

  • id — bigint
  • category — varchar(255)
  • ADDITIONAL::character — varying
  • EDUCATIONAL::character — varying)::text))
  • content — varchar(255)
  • item — varchar(255)
  • EMERGENCY_SUPPORT::character — varying
  • REGULAR_CHECKUP::character — varying
  • PRODUCT_PATCH::character — varying
  • OZ_REPORT::character — varying
  • RECONSTRUCTION::character — varying
  • ENHANCEMENT::character — varying
  • OTHER_SUPPORT::character — varying
  • TRAINING::character — varying)::text))
  • product_module_id — bigint
  • quotation_id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)

order_report

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • additional_documents — varchar(255)
  • aiotion_summary — bigint
  • channel — boolean — NOT NULL
  • code_type — varchar(255)
  • GA::character — varying
  • JN::character — varying
  • JA::character — varying
  • MN::character — varying
  • MA::character — varying
  • GNMA::character — varying
  • GEMA::character — varying
  • GLMA::character — varying
  • MNMA::character — varying
  • MEMA::character — varying
  • MLMA::character — varying)::text))
  • contract_date — date
  • contract_end_date — date
  • contract_period_months — integer
  • contract_provided — boolean — NOT NULL
  • contract_start_date — date
  • dashboard_summary — bigint
  • ems_maintenance_summary — bigint
  • ems_summary — bigint
  • free_maintenance_period_months — integer
  • item_total_amount — bigint
  • item_total_license — bigint
  • item_total_maintenance — bigint
  • item_total_maintenance_rate — double
  • item_total_service — bigint
  • item_total_third_party — bigint
  • itg_maintenance_summary — bigint
  • itg_summary — bigint
  • ito_summary — bigint
  • license_total — bigint
  • maintenance_total — bigint
  • order_report_code — varchar(255) — NOT NULL
  • other_summary — bigint
  • other_total — bigint
  • payment_condition — varchar(255)
  • prb_report_provided — boolean — NOT NULL
  • purchase_order_provided — boolean — NOT NULL
  • purchase_total — bigint
  • quotation_provided — boolean — NOT NULL
  • remarks — varchar(255)
  • scope_of_work — varchar(255)
  • service_total — bigint
  • total_amount — bigint
  • type — varchar(255)
  • MAINTENANCE::character — varying
  • SERVICE::character — varying)::text))
  • contract_counterpart_company_id — bigint
  • contract_counterpart_manager_id — bigint
  • … +9

order_report_maintenance

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • content — varchar(255)
  • month — integer
  • price — bigint
  • total_price — bigint
  • visit_cycle — varchar(255)
  • QUARTERLY::character — varying
  • SEMI_ANNUAL::character — varying)::text))
  • order_report_id — bigint

order_report_maintenance_only_item

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • amount — bigint
  • license — bigint
  • maintenance — bigint
  • maintenance_rate — double
  • service — bigint
  • third_party — bigint
  • year — integer
  • order_report_id — bigint

order_report_other

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • content — varchar(255)
  • price — bigint
  • quantity — integer
  • total_price — bigint
  • order_report_id — bigint

order_report_purchase

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • content — varchar(255)
  • price — bigint
  • quantity — integer
  • total_price — bigint
  • order_report_id — bigint

order_report_service_item

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • content — varchar(255)
  • man_month — bigint
  • price — bigint
  • total_price — bigint
  • order_report_id — bigint

permission

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • department_id — bigint
  • action — varchar(255)
  • CREATE::character — varying
  • UPDATE::character — varying
  • DELETE::character — varying
  • APPROVE::character — varying
  • EXPORT::character — varying
  • MANAGE::character — varying)::text))
  • domain — varchar(255)
  • COMPANY::character — varying
  • SALES_ACTIVITY::character — varying
  • SALES_ACTIVITY_REQUEST::character — varying
  • QUOTATION::character — varying
  • RFP_ANALYSE_RESULT::character — varying
  • PRB::character — varying
  • PRB_RESULT::character — varying
  • BID_RESULT::character — varying
  • ORDER_REPORT::character — varying
  • CONTRACT::character — varying
  • LICENSE::character — varying
  • PROJECT::character — varying
  • PROJECT_RESULT::character — varying
  • BILLING::character — varying
  • PROJECT_RESULT_REPORT::character — varying
  • MAINTENANCE::character — varying
  • MAINTENANCE_QUOTATION::character — varying
  • CUSTOMER_SUPPORT::character — varying
  • PRODUCT_MODULE::character — varying
  • DEPARTMENT::character — varying
  • WORKFLOW::character — varying
  • PERMISSION::character — varying
  • USER::character — varying)::text))

prb

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • project_opportunity_id — bigint
  • sales_representative_id — uuid
  • general_overhead_total_amount — numeric(15, 2)
  • indirect_amount — numeric(15, 2)
  • indirect_base_amount — numeric(15, 2)
  • indirect_rate — numeric(5, 2)
  • maintenance_description — text
  • non_resident_total_amount — numeric(15, 2)
  • non_resident_total_man_month — numeric(7, 2)
  • resident_total_amount — numeric(15, 2)
  • resident_total_man_month — numeric(7, 2)
  • personnel_expense_total_amount — numeric(15, 2)
  • total_man_month — numeric(7, 2)
  • prb_code — varchar(50) — NOT NULL
  • prb_date — date — NOT NULL
  • total_list_price — numeric(15, 2)
  • total_product_cost — numeric(15, 2)
  • estimated_operating_profit — numeric(15, 2)
  • estimated_profit_margin — numeric(5, 2)
  • estimated_revenue — numeric(15, 2)
  • expected_win_rate — numeric(5, 2)
  • our_company_amount — numeric(15, 2)
  • total_project_amount — numeric(15, 2)
  • bid_type — varchar(50)
  • PROCUREMENT_BID_PROCUREMENT_EVAL::character — varying
  • PROCUREMENT_ENTRUST_SELF_EVAL::character — varying)::text))
  • official_notice_date — date
  • pre_spec_notice_date — date
  • price_bidding_datetime — timestamp(6)
  • price_eval_ratio — numeric(5, 2)
  • project_end_date — date
  • project_start_date — date
  • proposal_deadline_datetime — timestamp(6)
  • proposal_presentation_datetime — timestamp(6)
  • technical_eval_ratio — numeric(5, 2)
  • product_subtotal_amount — numeric(15, 2)
  • service_subtotal_amount — numeric(15, 2)
  • service_subtotal_man_month — numeric(7, 2)
  • total_purchase_amount — numeric(15, 2)
  • sales_representative_opinion — text
  • prb_total_cost — numeric(15, 2)

prb_general_overhead_expense

  • prb_id — bigint — NOT NULL
  • price — integer
  • general_overhead_amount — numeric(15, 2)
  • details_and_basis — text
  • major_category — varchar(50)
  • minor_category — varchar(50)
  • unit_price — numeric(15, 2)

prb_personnel_expense

  • prb_id — bigint — NOT NULL
  • price — integer

prb_purchase_human_resource

  • prb_id — bigint — NOT NULL
  • price — integer
  • human_resource_base_amount — numeric(15, 2)
  • human_resource_end_date — date
  • grade — varchar(20)
  • ADVANCED::character — varying
  • INTERMEDIATE::character — varying
  • BEGINNER::character — varying)::text))
  • input_man_month — numeric(5, 2)
  • human_resource_start_date — date
  • human_resource_total_amount — numeric(15, 2)

prb_purchase_product

  • prb_id — bigint — NOT NULL
  • price — integer
  • purchase_product_name — varchar(255)
  • purchase_product_quantity — integer
  • purchase_product_total_amount — numeric(15, 2)
  • vendor_name — varchar(255)

prb_result

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • prb_id — bigint
  • prb_result_id — bigint
  • comprehensive_opinion — text
  • meeting_date_time — timestamp(6)
  • meeting_location — varchar(255)
  • risk_factors — text

prb_result_attendee_opinion

  • prb_result_id — bigint — NOT NULL
  • opinion — varchar(255)
  • approval_status — varchar(20) — NOT NULL
  • REJECTED::character — varying
  • APPROVED::character — varying
  • CONDITIONAL::character — varying)::text))
  • attendee_user_id — uuid — NOT NULL
  • attendee_opinion — text

product_module

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • license_standard — varchar(255)
  • license_unit — varchar(255)
  • product_class — varchar(255) — NOT NULL
  • DASHBOARD::character — varying
  • DATACENTER::character — varying
  • RCA::character — varying
  • DCA::character — varying
  • ITSM::character — varying
  • ITAM::character — varying
  • SUPPORTING_TOOLS::character — varying
  • CLOUD::character — varying
  • BSM::character — varying
  • E2E::character — varying
  • ETC::character — varying)::text))
  • product_group — varchar(255) — NOT NULL
  • product_name — varchar(255) — NOT NULL
  • unit_price — bigint

project

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • code — varchar(255)
  • GA::character — varying
  • JN::character — varying
  • JA::character — varying
  • MN::character — varying
  • MA::character — varying
  • GN_MA::character — varying
  • GE_MA::character — varying
  • GL_MA::character — varying
  • MN_MA::character — varying
  • ME_MA::character — varying
  • ML_MA::character — varying
  • SERVICE::character — varying)::text))
  • end_date — date
  • pjt_number — varchar(255) — NOT NULL
  • start_date — date
  • type — varchar(255)
  • MAINTENANCE::character — varying
  • SERVICE::character — varying)::text))
  • manager_id — uuid
  • order_report_id — bigint
  • pjt_name — varchar(255) — NOT NULL
  • total_amount — bigint
  • sales_representative_id — uuid

project_opportunity

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • competition_status — varchar(255)
  • description — oid
  • expected_bid_date — date
  • expected_budget — numeric(15, 2)
  • opportunity_code — varchar(255) — NOT NULL
  • opportunity_name — varchar(255) — NOT NULL
  • project_type — varchar(255)
  • DASHBOARD::character — varying
  • DATACENTER::character — varying
  • RCA::character — varying
  • DCA::character — varying
  • ITSM::character — varying
  • ITAM::character — varying
  • SUPPORTING_TOOLS::character — varying
  • CLOUD::character — varying
  • BSM::character — varying
  • E2E::character — varying
  • ETC::character — varying)::text))
  • stage — varchar(255) — NOT NULL
  • ACTIVITY::character — varying
  • BID::character — varying
  • CONTRACT::character — varying
  • PROJECT::character — varying
  • MAINTENANCE::character — varying
  • POST_SALES::character — varying)::text))
  • customer_company_id — bigint
  • sales_representative_id — uuid

project_opportunity_contact_route

  • id — bigint
  • sequence — integer — NOT NULL
  • company_id — bigint
  • project_opportunity_id — bigint

project_opportunity_partner_company

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • company_id — bigint
  • project_opportunity_id — bigint

project_opportunity_product_module

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • product_module_id — bigint
  • project_opportunity_id — bigint

project_result_report

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • content — text
  • end_date — date
  • start_date — date
  • manager_id — uuid
  • project_id — bigint — NOT NULL
  • result_report_file_id — bigint

proposal

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • status — varchar(255) — NOT NULL
  • COMPLETED::character — varying)::text))
  • project_opportunity_id — bigint — NOT NULL
  • sales_activity_request_id — bigint

rfp_analyze_result

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • project_opportunity_id — bigint
  • budget_amount — numeric(15, 2)
  • expected_duration — varchar(100)
  • hardware_provider — varchar(100)
  • project_description — text
  • project_location — varchar(255)
  • project_name — varchar(255) — NOT NULL
  • proposal_deadline — timestamp(6)
  • proposal_type — varchar(20)
  • SELF::character — varying)::text))
  • status — varchar(20) — NOT NULL
  • ANALYZING::character — varying
  • COMPLETED::character — varying)::text))
  • assignee_id — uuid

sales_activity

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • activity_content — text
  • activity_date_time — timestamp(6)
  • activity_purpose — varchar(255) — NOT NULL
  • PRODUCT_INTRODUCTION::character — varying
  • DEMO::character — varying
  • POC::character — varying
  • BMT::character — varying
  • DOCUMENT_DELIVERY::character — varying
  • RFP_ANALYSIS::character — varying
  • PROPOSAL_WRITING::character — varying
  • SI_PROPOSAL_WRITING::character — varying
  • ETC::character — varying)::text))
  • activity_type — varchar(255) — NOT NULL
  • CALL::character — varying
  • VIDEO_MEETING::character — varying
  • OFFLINE_MEETING::character — varying
  • ETC::character — varying)::text))
  • customer_interest — text
  • issue — text
  • location — varchar(255)
  • next_activity — text
  • status — varchar(255) — NOT NULL
  • PLANNED::character — varying
  • IN_PROGRESS::character — varying
  • COMPLETED::character — varying
  • CANCELED::character — varying)::text))
  • project_opportunity_id — bigint

sales_activity_attendee

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • sales_activity_id — bigint
  • user_id — uuid

sales_activity_request

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • activity_date_time — timestamp(6)
  • activity_purpose — varchar(255) — NOT NULL
  • PRODUCT_INTRODUCTION::character — varying
  • DEMO::character — varying
  • POC::character — varying
  • BMT::character — varying
  • DOCUMENT_DELIVERY::character — varying
  • RFP_ANALYSIS::character — varying
  • PROPOSAL_WRITING::character — varying
  • SI_PROPOSAL_WRITING::character — varying
  • ETC::character — varying)::text))
  • activity_type — varchar(255) — NOT NULL
  • CALL::character — varying
  • VIDEO_MEETING::character — varying
  • OFFLINE_MEETING::character — varying
  • ETC::character — varying)::text))
  • request_content — varchar(255)
  • sales_activity_id — bigint
  • target_user_id — uuid — NOT NULL
  • title — varchar(255)
  • request_user_id — uuid — NOT NULL

upload_file

  • id — bigint
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • content_type — varchar(255) — NOT NULL
  • file_size — bigint — NOT NULL
  • object_key — varchar(255) — NOT NULL
  • original_file_name — varchar(255) — NOT NULL
  • proposal_id — bigint

users

  • id — uuid — NOT NULL
  • created_at — timestamp(6)
  • created_by — varchar(255)
  • deleted — boolean — NOT NULL
  • deleted_at — timestamp(6)
  • deleted_by — varchar(255)
  • updated_at — timestamp(6)
  • updated_by — varchar(255)
  • email — varchar(255) — NOT NULL
  • employee_number — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • phone — varchar(255)
  • position — varchar(255) — NOT NULL
  • role — varchar(255)
  • ADMIN::character — varying)::text))
  • status — varchar(255) — NOT NULL
  • LEAVE::character — varying
  • RESIGNED::character — varying)::text))
  • department_id — bigint