roadmap-buddy

Tables (18)

AI_GENERATED_CONTENTS (AI_생성_답변)

  • ID (Key) — NUM — Primary key — NOT NULL
  • FULL_RESPONSE (Field) — JSONB — Claude API 전체 응답 원본 (JSON)
  • OVERVIEW (Field9) — VARCHAR2
  • QUARTERLY (Field10) — VARCHAR2
  • MONTHLY (Field11) — VARCHAR2
  • WEEKLY (Field12)
  • USED_PROMPT (Field2) — VARCHAR2
  • MODEL_VERSION (Field3) — VARCHAR2 — 예 : claude-sonnet-4-20250514
  • USED_TOKEN (Field4) — INT
  • GENERATED_METADATA (Field5) — JSONB — latency, temperature 등
  • VERSION (Field6) — NUM — 재생성 시 증가
  • CREATED_AT (Field7) — TIMESTAMP
  • CREATED_BY (Field8) — VARCHAR2

CATEGORY_GROUP (카테고리_그룹)

  • ID (Key) — NUM — Primary key — NOT NULL
  • NAME (Field) — VARCHAR2
  • DESCRIPTION (Field2) — VARCHAR2
  • DISPLAY_ORDER (Field3) — INT
  • CREATED_AT (Field4) — TIMESTAMP
  • CREATED_BY (Field5) — VARCHAR2
  • LAST_MODIFIED_AT (Field6) — TIMESTAMP
  • LAST_MODIFIED_BY (Field7) — VARCHAR2

CATEGORY_ITEM (카테고리_항목)

  • ID (Key) — NUM — Primary key — NOT NULL
  • CATEGORY_GROUP_ID (Field) — NUM
  • NAME (Field2) — VARCHAR2
  • DESCRIPTION (Field3) — VARCHAR2
  • DISPLAY_ORDER (Field4) — INT
  • CREATED_AT (Field5) — TIMESTAMP
  • CREATED_BY (Field6) — VARCHAR2
  • LAST_MODIFIED_AT (Field7) — TIMESTAMP
  • LAST_MODIFIED_BY (Field8) — VARCHAR2

DAILY_TASK (일_작업)

  • ID (Key) — NUM — Primary key — NOT NULL
  • ROADMAP_WEEKLY_ID (Field) — NUM
  • ROADMAP_ID (Field15) — NUM
  • TITLE (Field3) — VARCHAR2
  • DESCRIPTION (Field4) — VARCHAR2
  • FOCUS_AREA (Field8) — VARCHAR2
  • SCHEDULE_DATE (Field5) — DATE
  • ORDER (Field2) — NUM
  • ESTIMATED_HOURS (Field17) — NUM
  • DIFFICULTY (Field18) — VARCHAR2
  • PRIORITY (Field16) — NUM
  • STATUS (Field10) — VARCHAR2 — 시작 전, 진행 중
  • NOTES (Field19) — VARCHAR2
  • CREATED_AT (Field11) — TIMESTAMP
  • CREATED_BY (Field12) — VARCHAR2
  • LAST_MODIFIED_AT (Field13) — TIMESTAMP
  • LAST_MODIFIED_BY (Field14) — VARCHAR2

DAILY_TASK_DELAY (일_작업_연기)

  • ID (Key) — NUM — Primary key — NOT NULL
  • DAILY_TASK_ID (Field) — NUM
  • OLD_SCHEDULED_DATE (Field2) — DATE
  • NEW_SCHEDULED_DATE (Field3) — DATE
  • REASON (Field4) — VARCHAR2
  • CREATED_AT (Field5) — TIMESTAMP
  • CREATED_BY (Field6) — VARCHAR2
  • LAST_MODIFIED_AT (Field7) — TIMESTAMP
  • LAST_MODIFIED_BY (Field8) — VARCHAR2

DAILY_TASK_HISTORY (일_작업_이력)

  • ID (Key) — NUM — Primary key — NOT NULL
  • DAILY_TASK_ID (Field2) — NUM
  • SCHEDULED_DATE (Field3) — DATE
  • COMPLETED_DATE (Field) — DATE
  • ESTIMATED_HOURS (Field4) — NUM
  • ACTUAL_HOURS (Field5) — NUM
  • CREATED_AT (Field6) — TIMESTAMP
  • CREATED_BY (Field7) — VARCHAR2

LEARNING_RESOURCE (학습 자료)

  • ID (Key) — NUM — Primary key — NOT NULL
  • ROADMAP_MONTHLY_ID (Field) — NUM
  • ORDER (Field2) — NUM
  • TYPE (Field3) — VARCHAR2
  • TITLE (Field4) — VARCHAR2
  • URL (Field5) — VARCHAR2
  • AUTHOR (Field6) — VARCHAR2
  • COMPLETED_YN (Field7) — CHAR
  • COMPLETED_DATE (Field8) — DATE
  • CREATED_AT (Field9) — TIMESTAMP
  • CREATED_BY (Field10) — VARCHAR2
  • LAST_MODIFIED_AT (Field11) — TIMESTAMP
  • LAST_MODIFIED_BY (Field12) — VARCHAR2

ROADMAP (로드맵)

  • ID (Key) — NUM — Primary key — NOT NULL
  • USER_ID (Field) — NUM
  • AI_GENERATED_CONTENT_ID (Field9) — NUM
  • OVERVIEW (Field10) — VARCHAR2 — 전체 개요 (AI 생성)
  • TITLE (Field2) — VARCHAR2
  • CATEGORY_GROUP_ID (Field3) — NUM
  • CATEGORY_ITEM_ID (Field4) — NUM
  • START_DATE (Field5) — DATE
  • END_DATE (Field6) — DATE
  • DIFFICULTY (Field8) — VARCHAR2
  • STATUS (Field7) — VARCHAR2
  • CREATED_AT (Field11) — TIMESTAMP
  • CREATED_BY (Field12) — VARCHAR2
  • LAST_MODIFIED_AT (Field13) — TIMESTAMP
  • LAST_MODIFIED_BY (Field14) — VARCHAR2

ROADMAP_CATEGORY_GROUP_MAP (로드맵_카테고리_그룹_매핑)

  • ID (Key) — NUM — Primary key — NOT NULL
  • ROADMAP_ID (Field) — NUM
  • CATEGORY_GROUP_ID (Field2) — NUM
  • CREATED_AT (Field3) — TIMESTAMP
  • CREATD_BY (Field4) — VARCHAR2

ROADMAP_CATEGORY_ITEM_MAP (로드맵_카테고리_항목_매핑)

  • ID (Key) — NUM — Primary key — NOT NULL
  • ROADMAP_ID (Field) — NUM
  • CATEGORY_ITEM_ID (Field2) — NUM
  • CREATED_AT (Field3) — TIMESTAMP
  • CREATD_BY (Field4) — VARCHAR2

ROADMAP_GOAL (로드맵_목표)

  • ID (Key) — NUM — Primary key — NOT NULL
  • ROADMAP_ID (Field) — NUM
  • ORDER (Field2) — NUM
  • GOAL (Field3) — VARCHAR2
  • DESCRIPTION (Field4) — VARCHAR2
  • STATUS (Field5) — VARCHAR2
  • CREATED_AT (Field6) — TIMESTAMP
  • CREATED_BY (Field7) — VARCHAR2
  • LAST_MODIFIED_AT (Field8) — TIMESTAMP
  • LAST_MODIFIED_BY (Field9) — VARCHAR2

ROADMAP_MONTHLY (로드맵_월)

  • ID (Key) — NUM — Primary key — NOT NULL
  • ROADMAP_QUARTERLY_ID (Field) — NUM
  • ROADMAP_ID (Field15) — NUM
  • AI_GENERATED_CONTENT_ID (Field2) — NUM
  • TITLE (Field3) — VARCHAR2
  • DESCRIPTION (Field4) — VARCHAR2
  • MONTH (Field5) — NUM
  • START_DATE (Field6) — DATE
  • END_DATE (Field7) — DATE
  • FOCUS_AREA (Field8) — VARCHAR2
  • PROGRESS_PERCENT (Field9) — NUM
  • STATUS (Field10) — VARCHAR2
  • CREATED_AT (Field11) — TIMESTAMP
  • CREATED_BY (Field12) — VARCHAR2
  • LAST_MODIFIED_AT (Field13) — TIMESTAMP
  • LAST_MODIFIED_BY (Field14) — VARCHAR2

ROADMAP_MONTHLY_GOAL (로드맵_월_목표)

  • ID (Key) — NUM — Primary key — NOT NULL
  • ROADMAP_MONTHLY_ID (Field) — NUM
  • ORDER (Field2) — NUM
  • GOAL (Field3) — VARCHAR2
  • DESCRIPTION (Field4) — VARCHAR2
  • STATUS (Field5) — VARCHAR2
  • CREATED_AT (Field6) — TIMESTAMP
  • CREATED_BY (Field7) — VARCHAR2
  • LAST_MODIFIED_AT (Field8) — TIMESTAMP
  • LAST_MODIFIED_BY (Field9) — VARCHAR2

ROADMAP_QUARTERLY (로드맵_분기)

  • ID (Key) — NUM — Primary key — NOT NULL
  • ROADMAP_ID (Field) — NUM
  • AI_GENERATED_CONTENT_ID (Field2) — NUM
  • TITLE (Field3) — VARCHAR2
  • DESCRIPTION (Field4) — VARCHAR2
  • QUARTER (Field5) — NUM
  • START_DATE (Field6) — DATE
  • END_DATE (Field7) — DATE
  • FOCUS_AREA (Field8) — VARCHAR2
  • PROGRESS_PERCENT (Field9) — NUM
  • STATUS (Field10) — VARCHAR2
  • CREATED_AT (Field11) — TIMESTAMP
  • CREATED_BY (Field12) — VARCHAR2
  • LAST_MODIFIED_AT (Field13) — TIMESTAMP
  • LAST_MODIFIED_BY (Field14) — VARCHAR2

ROADMAP_QUARTERLY_GOAL (로드맵_분기_목표)

  • ID (Key) — NUM — Primary key — NOT NULL
  • ROADMAP_QUARTERLY_ID (Field) — NUM
  • ORDER (Field2) — NUM
  • GOAL (Field3) — VARCHAR2
  • DESCRIPTION (Field4) — VARCHAR2
  • STATUS (Field5) — VARCHAR2
  • CREATED_AT (Field6) — TIMESTAMP
  • CREATED_BY (Field7) — VARCHAR2
  • LAST_MODIFIED_AT (Field8) — TIMESTAMP
  • LAST_MODIFIED_BY (Field9) — VARCHAR2

ROADMAP_WEEKLY (로드맵_주)

  • ID (Key) — NUM — Primary key — NOT NULL
  • ROADMAP_MONTHLY_ID (Field) — NUM
  • ROADMAP_ID (Field15) — NUM
  • AI_GENERATED_CONTENT_ID (Field2) — NUM
  • TITLE (Field3) — VARCHAR2
  • DESCRIPTION (Field4) — VARCHAR2
  • WEEK (Field5) — NUM
  • START_DATE (Field6) — DATE
  • END_DATE (Field7) — DATE
  • FOCUS_AREA (Field8) — VARCHAR2
  • PROGRESS_PERCENT (Field9) — NUM
  • STATUS (Field10) — VARCHAR2
  • CREATED_AT (Field11) — TIMESTAMP
  • CREATED_BY (Field12) — VARCHAR2
  • LAST_MODIFIED_AT (Field13) — TIMESTAMP
  • LAST_MODIFIED_BY (Field14) — VARCHAR2

ROADMAP_WEEKLY_GOAL (로드맵_주_목표)

  • ID (Key) — NUM — Primary key — NOT NULL
  • ROADMAP_WEEKLY_ID (Field) — NUM
  • ORDER (Field2) — NUM
  • GOAL (Field3) — VARCHAR2
  • DESCRIPTION (Field4) — VARCHAR2
  • STATUS (Field5) — VARCHAR2
  • CREATED_AT (Field6) — TIMESTAMP
  • CREATED_BY (Field7) — VARCHAR2
  • LAST_MODIFIED_AT (Field8) — TIMESTAMP
  • LAST_MODIFIED_BY (Field9) — VARCHAR2

USER (사용자)

  • ID (Key) — NUM — Primary key — NOT NULL
  • EMAIL (Field) — VARCHAR2
  • PASSWORD (Field2) — VARCHAR2
  • NAME (Field3) — VARCHAR2
  • CREATED_AT (Field4) — TIMESTAMP
  • CREATED_BY (Field5) — VARCHAR2
  • LAST_MODIFIED_AT (Field6) — TIMESTAMP
  • LAST_MODIFIED_BY (Field7) — VARCHAR2