issue Project

Tables (5)

Attachment (Untitled5)

  • Attach_id (파일ID) — BIGINT — Primary key — NOT NULL
  • issue_id (이슈ID) — BIGINT — Foreign key → Issue.issue_id — NOT NULL
  • file_name (원본파일명) — VARCHAR(255)
  • file_path (저장위치) — VARCHAR(500)
  • file_type (확장자) — VARCHAR(50)
  • created_at (생성일) — DATETIME

Category (Untitled2)

  • category_id (카테고리ID) — BIGINT — Primary key — NOT NULL
  • name (카테고리명) — VARCHAR(50)
  • description (설명) — TEXT
  • created_at (생성일) — DATETIME
  • updated_at (수정일) — DATETIME

Comment (Untitled4)

  • comment_id (댓글ID) — BIGINT — Primary key — NOT NULL
  • issue_id (이슈ID) — BIGINT — Foreign key → Issue.issue_id — NOT NULL
  • user_id (유저ID) — BIGINT — Foreign key → User.user_id — NOT NULL
  • content (내용) — TEXT
  • created_at (생성일) — DATETIME
  • updated_at (수정일) — DATETIME

Issue (Untitled3)

  • issue_id (이슈ID) — BIGINT — Primary key — NOT NULL
  • category_id (카테고리ID) — BIGINT — Foreign key → Category.category_id — NOT NULL
  • issue_no (이슈번호) — VARCHAR(20)
  • title (제목) — VARCHAR(200)
  • description (설명) — TEXT
  • device (기종) — VARCHAR(50)
  • version (버전) — VARCHAR(50)
  • type (유형) — VARCHAR(30)
  • priority (우선순위) — VARCHAR(20)
  • status (상태) — VARCHAR(20)
  • precondition (사전조건) — TEXT
  • steps (진행절차) — TEXT
  • expected_result (예상결과) — TEXT
  • actual_result (현재결과) — TEXT
  • response (API response) — TEXT
  • external_ticket_id (외부티켓ID) — VARCHAR(50)
  • testcase_url (TC링크) — VARCHAR(500)
  • automation_satatus (자동화 상태) — VARCHAR(30)
  • assignee (담당자) — VARCHAR(30)
  • created_by (작성자) — BIGINT
  • updated_by (수정자) — BIGINT
  • created_at (생성일) — DATETIME
  • updated_at (최종수정일) — DATETIME

User (Untitled)

  • user_id (유저ID) — BIGINT — Primary key — NOT NULL
  • email (이메일) — VARCHAR(100)
  • password (비밀번호) — VARCHAR(255)
  • name (이름) — VARCHAR(50)
  • role (권한) — VARCHAR(20)
  • created_at (생성일) — DATETIME
  • updated_at (수정일) — DATETIME