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