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