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