Issue Tracker
Tables (9)
Comment (comment)
- Comment ID (id) — BIGSERIAL — Primary key — PK
- Issue ID (issue_id) — BIGINT — Foreign key → Issue.Issue ID — FK referencing issue(id)
- User ID (user_ID) — BIGINT
- Content (content) — TEXT — Comment text
- Created At (created_at) — TIMESTAMP — Timestamp of comment creation
Issue (issue)
- Issue ID (id) — BIGSERIAL — Primary key — PK
- Project ID (project_id) — BIGINT — Foreign key → Project.Project ID — NOT NULL — FK referencing project(id)
- Title (title) — VARCHAR(200) — Issue title
- Description (description) — TEXT — NOT NULL — Issue detail
- Status (status) — VARCHAR(20) — 'OPEN', 'IN_PROGRESS', 'CLOSED'
- Priority (priority) — VARCHAR(20) — 'LOW', 'MEDIUM', 'HIGH'
- Due Date (due_date) — DATE — NOT NULL — Target due date
- Asssinee ID (assingee_id) — BIGINT — NOT NULL
- Created At (created_at) — TIMESTAMP — Timestamp of creation
- Created By (created_by) — BIGINT
- Last Updated At (updated_at) — TIMESTAMP — NOT NULL — Timestamp of last update
- Last Updated By (updated_by) — BIGINT — NOT NULL
Issue Attachment (issue_attachment)
- Issue Attachment ID (id) — BIGSERIAL — Primary key — 첨부파일 고유 ID
- Issue ID (issue_id) — BIGSINT — Foreign key → Issue.Issue ID
- File Name (file_name) — VARCHAR(255) — 실제 파일 이름
- File URL (file_url) — VARCHAR(255)
- File Size (file_size) — BIGINT — NOT NULL — 파일 크기(바이트 단위)
- Uploaded At (uploaded_at) — TIMESTAMP
Project (project)
- Project ID (id) — BIGSERIAL — Primary key — PK
- Project Name (name) — VARCHAR(100) — Name of the project
- Description (description) — TEXT — NOT NULL — Project description
- Created At (created_at) — TIMESTAMP — Timestamp of project creation
- Created By (created_by) — BIGINT
- Last Updated At (updated_at) — TIMESTAMP — NOT NULL — Timestamp of the most recent update
- Last Updated By (updated_by) — BIGINT — NOT NULL
- Category (category) — VARCHAR(50) — NOT NULL — 프로젝트 설정, 분류 등
- Is Public (is_public) — BOOLEAN — 프로젝트 공개여부
Project Member (project_member)
- Project ID (id) — BIGINT — Foreign key → Project.Project ID — PK
- User ID (user_id) — BIGINT — Foreign key → Users.User ID — PK
- Joined At (joind_at) — TIMESTAMP
Role (role)
- Role ID (id) — SERIAL — Primary key — PK
- Role Name (name) — VARCHAR(30) — e.g. 'USER', 'ADMIN'
Tag (tag)
- Tag ID (id) — BIGSERIAL — Primary key — PK
- Tag Name (name) — VARCHAR(50) — e.g. bug, feature, etc.
- Color Code (color) — VARCHAR(10) — NOT NULL — e.g. #FF0000
User Role (user_role)
- User ID (id) — BIGINT — Foreign key → Users.User ID — PK
- Role ID (rold_ID) — INT
Users (users)
- User ID (id) — BIGSERIAL — Primary key — PK
- Username (username) — VARCHAR(50) — display name
- Email (email) — VARCHAR(100) — Unique email address
- Password (password) — VARCHAR(255) — Encrypted password
- Profile Image URL (profile_image_url) — VARCHAR(255) — NOT NULL — 사용자 프로필 이미지 url