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