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