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