GOMGOM
테이블 (12)
execution_co_executors
- co_executor_id — INT — 기본 키 — NOT NULL
- report_id — INT — NOT NULL
- assigned_date — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
마일리지 부여 (mileages)
- mileage_id — INT — 기본 키 — NOT NULL
- idea_id — INT — NOT NULL
- employee_id — NVARCHAR(50) — NOT NULL
- points — INT — NOT NULL
- award_date — DATETIME
- reason — NVARCHAR(500)
- created_at — DATETIME
- updated_at — DATETIME
마일리지 출금관리 (mileage_withdrawals)
- withdrawal_id — INT — 기본 키 — NOT NULL
- employee_id — NVARCHAR(50) — NOT NULL
- request_points — INT — NOT NULL
- request_date — DATETIME
- status — NVARCHAR(50)
- processed_date — DATETIME
- processed_by — NVARCHAR(50)
- admin_comment — NVARCHAR(500) — VARCHAR(500) NUL
- created_at — DATETIME
- updated_at — DATETIME
부문별 심사 지정 (section_reviewers)
- section_reviewer_id — INT — 기본 키 — NOT NULL
- section_name — NVARCHAR(100) — NOT NULL
- reviewer_employee_id — NVARCHAR(50) — NOT NULL
- assigned_date — DATETIME
- is_active — BIT
- assigned_by — NVARCHAR(50)
- created_at — DATETIME
- updated_at — DATETIME
사용자 (users)
- employee_id — NVARCHAR(50) — 기본 키 — NOT NULL
- name — NVARCHAR(100) — NOT NULL
- email — NVARCHAR(255) — NOT NULL
- password_hash — NVARCHAR(255) — NOT NULL
- department — NVARCHAR(100)
- section — NVARCHAR(100)
- is_admin — BIT
- total_mileage — INT
- created_at — DATETIME
- updated_at — DATETIME
- last_sync_at — DATETIME
실행레포트 (execution_reports)
- report_id — INT — 기본 키 — NOT NULL
- idea_id — INT — NOT NULL
- schedule — NVARCHAR(500)
- content — NVARCHAR(MAX) — NOT NULL
- report_date — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
아이디어 (ideas)
- idea_id — INT — 기본 키 — NOT NULL
- title — NVARCHAR(200) — NOT NULL
- problem — NVARCHAR(MAX)
- description — NVARCHAR(MAX) — NOT NULL
- category_id — INT
- submit_date — DATETIME
- status — NVARCHAR(50)
- mileage_points — INT
- security — NVARCHAR(1)
- created_at — DATETIME
- updated_at — DATETIME
아이디어 or 레포트별 첨부 파일 (attachments)
- attachment_id — INT — 기본 키 — NOT NULL
- report_id — INT
- idea_id — INT
- file_name — NVARCHAR(255) — NOT NULL
- file_path — NVARCHAR(500) — NOT NULL
- uploaded_by — NVARCHAR(50) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
아이디어 승인 (idea_approvers)
- idea_approver_id — INT — 기본 키 — NOT NULL
- idea_id — INT — NOT NULL
- approver_id — NVARCHAR(50) — NOT NULL
- assigned_date — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
아이디어 승인 상태 (approvals)
- approval_id — INT — 기본 키 — NOT NULL
- idea_id — INT — NOT NULL
- approver_id — NVARCHAR(50) — NOT NULL
- status_yn — NVARCHAR(50) — NOT NULL
- comment — NVARCHAR(MAX) — NOT NULL — VARCHAR(MAX) NOT NUL
- approval_date — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
아이디어 카테고리 (categories)
- category_id — INT — 기본 키 — NOT NULL
- category_name — NVARCHAR(100) — NOT NULL
- description — NVARCHAR(500)
- display_order — INT
- is_active — BIT
- created_at — DATETIME
- updated_at — DATETIME
아이디어별 댓글 (comments)
- comment_id — INT — 기본 키 — NOT NULL
- idea_id — INT — NOT NULL
- user_id — NVARCHAR(50) — NOT NULL
- comment — NVARCHAR(MAX) — NOT NULL — VARCHAR(MAX) NOT NUL
- created_at — DATETIME
- updated_at — DATETIME