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