스마트제조혁신V0.2

테이블 (20)

agent_document_maps

  • id — UUID
  • tenant_id — UUID — 외래 키 → tenants.id — NOT NULL
  • agent_id — UUID — 외래 키 → agents.id — NOT NULL
  • document_id — UUID — 외래 키 → knowledge_documents.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

agents

  • id — UUID
  • tenant_id — UUID — 외래 키 → tenants.id — NOT NULL
  • agent_name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • model_name — VARCHAR(100) — NOT NULL
  • system_prompt — TEXT — NOT NULL
  • task_template — TEXT
  • temperature — NUMERIC(4,2) — NOT NULL
  • max_tokens — INTEGER — NOT NULL
  • max_iterations — INTEGER — NOT NULL
  • allow_file_upload — BOOLEAN — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_by — UUID — 외래 키 → users.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

conversation_attachments

  • id — UUID
  • tenant_id — UUID — 외래 키 → tenants.id — NOT NULL
  • conversation_id — UUID — 외래 키 → conversations.id — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • storage_path — TEXT — NOT NULL
  • mime_type — VARCHAR(100) — NOT NULL
  • file_size — BIGINT — NOT NULL
  • created_by — UUID — 외래 키 → users.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

conversation_messages

  • id — UUID
  • tenant_id — UUID — 외래 키 → tenants.id — NOT NULL
  • conversation_id — UUID — 외래 키 → conversations.id — NOT NULL
  • sender_type — VARCHAR(20) — NOT NULL
  • sender_user_id — UUID — 외래 키 → users.id
  • content — TEXT — NOT NULL
  • content_type — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

conversations

  • id — UUID
  • tenant_id — UUID — 외래 키 → tenants.id — NOT NULL
  • created_by — UUID — 외래 키 → users.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • selected_model — VARCHAR(100)
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

features

  • id — UUID
  • service_id — UUID — 외래 키 → services.id — NOT NULL
  • feature_code — VARCHAR(100) — NOT NULL
  • feature_name — VARCHAR(100) — NOT NULL
  • resource_code — VARCHAR(100) — NOT NULL
  • action_code — VARCHAR(50) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

knowledge_document_files

  • id — UUID
  • tenant_id — UUID — 외래 키 → tenants.id — NOT NULL
  • document_id — UUID — 외래 키 → knowledge_documents.id — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • storage_path — TEXT — NOT NULL
  • mime_type — VARCHAR(100) — NOT NULL
  • file_size — BIGINT — NOT NULL
  • version_no — INTEGER — NOT NULL
  • uploaded_by — UUID — 외래 키 → users.id — NOT NULL
  • uploaded_at — TIMESTAMPTZ — NOT NULL

knowledge_documents

  • id — UUID
  • tenant_id — UUID — 외래 키 → tenants.id — NOT NULL
  • document_name — VARCHAR(255) — NOT NULL
  • folder_name — VARCHAR(200)
  • document_type — VARCHAR(50) — NOT NULL
  • description — TEXT
  • status — VARCHAR(20) — NOT NULL
  • created_by — UUID — 외래 키 → users.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

memo_template_versions

  • id — UUID
  • tenant_id — UUID — 외래 키 → tenants.id — NOT NULL
  • template_id — UUID — 외래 키 → memo_templates.id — NOT NULL
  • version_no — INTEGER — NOT NULL
  • content_json — JSONB — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_by — UUID — 외래 키 → users.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

memo_templates

  • id — UUID
  • tenant_id — UUID — 외래 키 → tenants.id — NOT NULL
  • template_name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • current_version_no — INTEGER — NOT NULL
  • created_by — UUID — 외래 키 → users.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

report_tasks

  • id — UUID
  • tenant_id — UUID — 외래 키 → tenants.id — NOT NULL
  • task_name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • feed_id — UUID — 외래 키 → rss_feeds.id — NOT NULL
  • report_type — VARCHAR(50) — NOT NULL
  • schedule_type — VARCHAR(30) — NOT NULL
  • cron_expr — VARCHAR(100)
  • status — VARCHAR(20) — NOT NULL
  • created_by — UUID — 외래 키 → users.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

role_features

  • id — UUID
  • role_id — UUID — 외래 키 → roles.id — NOT NULL
  • feature_id — UUID — 외래 키 → features.id — NOT NULL
  • is_allowed — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

roles

  • id — UUID
  • tenant_id — UUID — 외래 키 → tenants.id — NOT NULL
  • role_code — VARCHAR(50) — NOT NULL
  • role_name — VARCHAR(100) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

rss_feeds

  • id — UUID
  • tenant_id — UUID — 외래 키 → tenants.id — NOT NULL
  • feed_name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • rss_url — TEXT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_by — UUID — 외래 키 → users.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

services

  • id — UUID
  • service_code — VARCHAR(50) — NOT NULL
  • service_name — VARCHAR(100) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

tenant_services

  • id — UUID
  • tenant_id — UUID — 외래 키 → tenants.id — NOT NULL
  • service_id — UUID — 외래 키 → services.id — NOT NULL
  • is_enabled — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

tenant_users

  • id — UUID
  • tenant_id — UUID — 외래 키 → tenants.id — NOT NULL
  • user_id — UUID — 외래 키 → users.id — NOT NULL
  • display_name — VARCHAR(100)
  • is_tenant_admin — BOOLEAN — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • joined_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

tenants

  • id — UUID
  • tenant_code — VARCHAR(50) — NOT NULL
  • tenant_name — VARCHAR(200) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

user_roles

  • id — UUID
  • tenant_id — UUID — 외래 키 → tenants.id — NOT NULL
  • user_id — UUID — 외래 키 → users.id — NOT NULL
  • role_id — UUID — 외래 키 → roles.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

users

  • id — UUID
  • email — VARCHAR(255) — NOT NULL
  • password_hash — TEXT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • last_login_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL