스마트제조혁신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