FlowyPro

Tables (24)

alembic_version

  • version_num — varchar(32) — Primary key — NOT NULL

calendar

  • calendar_id — uuid — Primary key — NOT NULL
  • user_id — uuid — Foreign key → flowy_user.user_id — NOT NULL
  • project_id — uuid — Foreign key → project.project_id — NOT NULL
  • title — varchar(100) — NOT NULL
  • start — timestamp — NOT NULL
  • end — timestamp
  • calendar_type — varchar(100) — NOT NULL
  • completed — bool — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp

company

  • company_id — uuid — Primary key — NOT NULL
  • company_name — varchar(150) — NOT NULL
  • company_scale — varchar(100)
  • service_startdate — timestamp
  • service_enddate — timestamp
  • service_status — bool — NOT NULL

company_position

  • position_id — uuid — Primary key — NOT NULL
  • position_company_id — uuid — Foreign key → company.company_id — NOT NULL
  • position_code — varchar(50) — NOT NULL
  • position_name — varchar(100) — NOT NULL
  • position_detail — text

draft_log

  • draft_id — uuid — Primary key — NOT NULL
  • meeting_id — uuid — Foreign key → meeting.meeting_id
  • draft_trigger — text
  • docs_source_type — public."docs_source_type"
  • ref_interdoc_id — varchar(512)
  • ref_external_link — text
  • draft_title — varchar(100)
  • draft_url — text
  • draft_ref_reason — text — NOT NULL
  • draft_created_date — timestamp — NOT NULL

feedback

  • feedback_id — uuid — Primary key — NOT NULL
  • meeting_id — uuid — Foreign key → meeting.meeting_id — NOT NULL
  • feedbacktype_id — uuid — Foreign key → feedbacktype.feedbacktype_id — NOT NULL
  • feedback_detail — jsonb — NOT NULL
  • feedback_created_date — timestamp — NOT NULL

feedbacktype

  • feedbacktype_id — uuid — Primary key — NOT NULL
  • feedbacktype_name — varchar(100) — NOT NULL

flowy_user

  • user_id — uuid — Primary key — NOT NULL
  • user_name — varchar(50) — NOT NULL
  • user_email — varchar(255) — NOT NULL
  • user_login_id — varchar(50) — NOT NULL
  • user_password — varchar(255) — NOT NULL
  • user_phonenum — varchar(20) — NOT NULL
  • user_company_id — uuid — Foreign key → company.company_id — NOT NULL
  • user_dept_name — varchar(100)
  • user_team_name — varchar(100)
  • user_position_id — uuid — Foreign key → company_position.position_id — NOT NULL
  • user_jobname — varchar(100)
  • user_sysrole_id — uuid — Foreign key → sysrole.sysrole_id — NOT NULL
  • user_login_type — varchar(20) — NOT NULL

interdocs

  • interdocs_id — uuid — Primary key — NOT NULL
  • interdocs_type_name — varchar(50) — NOT NULL
  • interdocs_filename — varchar(100) — NOT NULL
  • interdocs_contents — varchar(255) — NOT NULL
  • interdocs_vector — public.vector — NOT NULL
  • interdocs_path — text — NOT NULL
  • interdocs_uploaded_date — timestamp — NOT NULL
  • interdocs_updated_date — timestamp
  • interdocs_update_user_id — uuid — Foreign key → flowy_user.user_id — NOT NULL

langchain_pg_collection

  • uuid — uuid — Primary key — NOT NULL
  • name — varchar
  • cmetadata — json

langchain_pg_embedding

  • uuid — uuid — Primary key — NOT NULL
  • collection_id — uuid — Foreign key → langchain_pg_collection.uuid
  • embedding — public.vector
  • document — varchar
  • cmetadata — json
  • custom_id — varchar
  • id — serial4 — NOT NULL

meeting

  • meeting_id — uuid — Primary key — NOT NULL
  • project_id — uuid — Foreign key → project.project_id — NOT NULL
  • meeting_title — varchar(150) — NOT NULL
  • meeting_agenda — varchar(1000)
  • meeting_date — timestamp — NOT NULL
  • meeting_audio_path — text — NOT NULL

meeting_user

  • meeting_user_id — uuid — Primary key — NOT NULL
  • user_id — uuid — Foreign key → flowy_user.user_id — NOT NULL
  • meeting_id — uuid — Foreign key → meeting.meeting_id — NOT NULL
  • role_id — uuid — Foreign key → role.role_id — NOT NULL

profile_img

  • profile_img_id — uuid — Primary key — NOT NULL
  • user_id — uuid — Foreign key → flowy_user.user_id — NOT NULL
  • profile_img_name — varchar(100) — NOT NULL
  • profile_img_path — text — NOT NULL
  • profile_img_uploaded_date — timestamp — NOT NULL

project

  • project_id — uuid — Primary key — NOT NULL
  • company_id — uuid — Foreign key → company.company_id — NOT NULL
  • project_name — varchar(200) — NOT NULL
  • project_detail — text
  • project_created_date — timestamp — NOT NULL
  • project_updated_date — timestamp
  • project_end_date — timestamp
  • project_status — bool — NOT NULL

project_user

  • project_user_id — uuid — Primary key — NOT NULL
  • user_id — uuid — Foreign key → flowy_user.user_id — NOT NULL
  • project_id — uuid — Foreign key → project.project_id — NOT NULL
  • role_id — uuid — Foreign key → role.role_id — NOT NULL

prompt_log

  • prompt_id — uuid — Primary key — NOT NULL
  • prompt_meeting_id — uuid — Foreign key → meeting.meeting_id — NOT NULL
  • agent_type — public."agent_type_enum" — NOT NULL
  • prompt_output — text — NOT NULL
  • prompt_input_date — timestamptz — NOT NULL
  • prompt_output_date — timestamptz — NOT NULL

prompts

  • id — uuid — Primary key — NOT NULL
  • title — text
  • content — text
  • prompt_type — public."prompt_type_enum"

role

  • role_id — uuid — Primary key — NOT NULL
  • role_name — varchar(50) — NOT NULL
  • role_detail — varchar(1000)

scenarios

  • uuid — uuid — Primary key — NOT NULL
  • scenario_name — text
  • content — text
  • embedding — public.vector
  • id — serial4 — NOT NULL

signup_log

  • signup_log_id — uuid — Primary key — NOT NULL
  • signup_request_user_id — uuid — Foreign key → flowy_user.user_id — NOT NULL
  • signup_update_user_id — uuid — Foreign key → flowy_user.user_id — NOT NULL
  • signup_status_changed_date — timestamp
  • signup_completed_status — varchar(20) — NOT NULL

summary_log

  • summary_log_id — uuid — Primary key — NOT NULL
  • meeting_id — uuid — Foreign key → meeting.meeting_id — NOT NULL
  • updated_summary_contents — jsonb — NOT NULL
  • updated_summary_date — timestamp — NOT NULL

sysrole

  • sysrole_id — uuid — Primary key — NOT NULL
  • sysrole_name — varchar(50) — NOT NULL
  • sysrole_detail — varchar(1000) — NOT NULL
  • permissions — text — NOT NULL

task_assign_log

  • task_assign_log_id — uuid — Primary key — NOT NULL
  • meeting_id — uuid — Foreign key → meeting.meeting_id — NOT NULL
  • updated_task_assign_contents — jsonb — NOT NULL
  • updated_task_assign_date — timestamp — NOT NULL