i-bank (v3) 게시용

테이블 (15)

tb_department

  • department_id — BIGSERIAL — 기본 키
  • head_user_id — BIGSERIAL — 외래 키 → tb_user.user_id
  • department_name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

tb_file

  • file_id — BIGSERIAL — 기본 키
  • worklog_id — BIGINT — 외래 키 → tb_worklog.worklog_id — NOT NULL
  • uploaded_by — BIGINT — 외래 키 → tb_user.user_id — NOT NULL
  • original_name — VARCHAR(500) — NOT NULL
  • stored_path — VARCHAR(1000) — NOT NULL
  • file_extension — VARCHAR(20) — NOT NULL
  • file_size_bytes — BIGINT — NOT NULL
  • ai_summary — TEXT
  • ai_processing_status — VARCHAR(20) — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

tb_file_embedding

  • embedding_id — BIGSERIAL — 기본 키
  • file_id — BIGINT — 외래 키 → tb_file.file_id — NOT NULL
  • worklog_id — BIGINT — 외래 키 → tb_worklog.worklog_id — NOT NULL
  • chunk_index — INTEGER — NOT NULL
  • total_chunks — INTEGER — NOT NULL
  • chunk_content — TEXT — NOT NULL
  • embedding — VECTOR(768) — NOT NULL
  • source_location — VARCHAR(200)
  • author_id — BIGINT — 외래 키 → tb_user.user_id — NOT NULL
  • team_id — BIGINT — 외래 키 → tb_team.team_id — NOT NULL
  • department_id — BIGINT — 외래 키 → tb_department.department_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

tb_meta_tag

  • tag_id — BIGSERIAL — 기본 키
  • tag_name — VARCHAR(100) — NOT NULL
  • usage_count — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

tb_notification

  • notification_id — BIGSERIAL — 기본 키
  • user_id — BIGINT — 외래 키 → tb_user.user_id — NOT NULL
  • notification_type — VARCHAR(50) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT
  • reference_type — VARCHAR(50)
  • reference_id — BIGINT
  • is_read — BOOLEAN — NOT NULL
  • read_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

tb_team

  • team_id — BIGSERIAL — 기본 키
  • department_id — BIGINT — 외래 키 → tb_department.department_id — NOT NULL
  • team_name — VARCHAR(100) — NOT NULL
  • status_code — VARCHAR(20) — NOT NULL
  • description — TEXT
  • start_date — DATE
  • expected_end_date — DATE
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

tb_user

  • user_id — BIGSERIAL — 기본 키
  • department_id — BIGINT — 외래 키 → tb_department.department_id — NOT NULL
  • user_name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • position_name — VARCHAR(50)
  • title_name — VARCHAR(50)
  • join_date — DATE
  • role_code — VARCHAR(20) — NOT NULL
  • profile_image_url — VARCHAR(500)
  • phone — VARCHAR(20)
  • employment_status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

tb_user_evaluation

  • evaluation_id — BIGSERIAL — 기본 키
  • evaluatee_user_id — BIGINT — 외래 키 → tb_user.user_id — NOT NULL
  • evaluator_user_id — BIGINT — 외래 키 → tb_user.user_id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

tb_user_skill

  • user_skill_id — BIGSERIAL — 기본 키
  • skill_level — SMALLINT — NOT NULL
  • user_id — BIGINT — 외래 키 → tb_user.user_id — NOT NULL
  • skill_name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

tb_user_team

  • user_team_id — BIGSERIAL — 기본 키
  • user_id — BIGINT — 외래 키 → tb_user.user_id — NOT NULL
  • team_id — BIGINT — 외래 키 → tb_team.team_id — NOT NULL
  • team_role — VARCHAR(20) — NOT NULL
  • is_primary — BOOLEAN — NOT NULL
  • joined_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

tb_worklog

  • worklog_id — BIGSERIAL — 기본 키
  • author_id — BIGINT — 외래 키 → tb_user.user_id — NOT NULL
  • team_id — BIGINT — 외래 키 → tb_team.team_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • request_content — TEXT
  • work_content — TEXT — NOT NULL
  • status_code — VARCHAR(20) — NOT NULL
  • importance_code — VARCHAR(20) — NOT NULL
  • actual_hours — NUMERIC(5,1)
  • instruction_date — DATE
  • due_date — DATE
  • completion_date — DATE
  • ai_summary — TEXT
  • ai_summary_edited — BOOLEAN — NOT NULL
  • ai_processing_status — VARCHAR(20) — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

tb_worklog_dependency

  • dependency_id — BIGSERIAL — 기본 키
  • worklog_id — BIGINT — 외래 키 → tb_worklog.worklog_id — NOT NULL
  • depends_on_worklog_id — BIGINT — 외래 키 → tb_worklog.worklog_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

tb_worklog_embedding

  • embedding_id — BIGSERIAL — 기본 키
  • worklog_id — BIGINT — 외래 키 → tb_worklog.worklog_id — NOT NULL
  • chunk_index — INTEGER — NOT NULL
  • total_chunks — INTEGER — NOT NULL
  • chunk_content — TEXT — NOT NULL
  • embedding — VECTOR(768) — NOT NULL
  • author_id — BIGINT — 외래 키 → tb_user.user_id — NOT NULL
  • team_id — BIGINT — 외래 키 → tb_team.team_id — NOT NULL
  • department_id — BIGINT — 외래 키 → tb_department.department_id — NOT NULL
  • status_code — VARCHAR(20)
  • importance_code — VARCHAR(20)
  • created_at — TIMESTAMP — NOT NULL

tb_worklog_status_history

  • history_id — BIGSERIAL — 기본 키
  • worklog_id — BIGINT — 외래 키 → tb_worklog.worklog_id — NOT NULL
  • previous_status_code — VARCHAR(20)
  • new_status_code — VARCHAR(20) — NOT NULL
  • reason — TEXT
  • changed_at — TIMESTAMP — NOT NULL
  • changed_by — BIGINT — 외래 키 → tb_user.user_id — NOT NULL

tb_worklog_tag

  • worklog_tag_id — BIGSERIAL — 기본 키
  • worklog_id — BIGINT — 외래 키 → tb_worklog.worklog_id — NOT NULL
  • tag_id — BIGINT — 외래 키 → tb_meta_tag.tag_id — NOT NULL
  • is_ai_generated — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL