KTB_AI_Hackerthon
Tables (7)
Meeting (Untitled5)
- id (Key) — LONG — Primary key — NOT NULL — 회의록(프로젝트) ID
- record (Field) — VARCHAR(10000) — NOT NULL — 회의록 (최대 10000자)
- script (Field2) — VARCHAR(2000) — NOT NULL — AI-generated 프로젝트 설명
- notion_page_url_desc (Field3) — VARCHAR(200)
- notion_page_url_task (Field6) — VARCHAR(200)
- notion_database_id (Field4) — VARCHAR(1000)
- title (Field5) — VARCHAR(100) — NOT NULL — 회의 제목
Stack (Untitled2)
- id (Key) — LONG — Primary key — NOT NULL
- stack_name (Field) — VARCHAR(50) — NOT NULL
Task_List (Untitled6)
- id (Key) — LONG — Primary key — NOT NULL
- meeting_id (Key2) — LONG — Foreign key → Meeting.id — NOT NULL — 어떤 프로젝트껀지
- title (Field) — VARCHAR(30) — NOT NULL
- works_id (Key3) — Foreign key → Works.id — 어떤 워크그룹인지
- task_order (Field3) — INT — NOT NULL — 워크그룹 내에서의 태스크 순서
- status (Field5) — ENUM — NOT NULL — 진행상태
- notion_task_id (Field6) — VARCHAR(200)
Team (Untitled4)
- id (Key) — LONG — Primary key — NOT NULL
- team_name (Field) — VARCHAR(20) — NOT NULL
- notion_key (Field2) — VARCHAR(200) — NOT NULL
- notion_page_url_base (Field3) — VARCHAR(200) — NOT NULL
User (Untitled)
- id (Key) — LONG — Primary key — NOT NULL
- name (Field) — VARCHAR(20) — NOT NULL
- level (Field3) — INT — NOT NULL — 숙련도
- exp_cnt (Field4) — INT — 프젝 경험횟수
- field (Field5) — ENUM — NOT NULL — 분야
- email (Field2) — VARCHAR(50)
- password (Field6) — VARCHAR(100)
- role (Field7) — ENUM — NOT NULL
User_Stack (-)
- id (Key) — LONG — Primary key — NOT NULL
- user_id (Key2) — LONG — Foreign key → User.id — NOT NULL
- stack_id (Key3) — LONG — Foreign key → Stack.id — NOT NULL
Works (Untitled3)
- id (Key) — Primary key — NOT NULL
- field (Field) — ENUM — NOT NULL
- title (Field2) — VARCHAR(30) — NOT NULL
- assignee (Key2) — LONG — Foreign key → User.id — 워크 담당자
- works_order (Field4) — INT — NOT NULL — 워크끼리의 순서
- level (Field3) — INT — NOT NULL