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