졸작

테이블 (10)

document_version

  • version_id — BIGINT — 기본 키 — NOT NULL
  • artifact_id — BIGINT — 외래 키 → pipeline_artifact.artifact_id — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • content — TEXT — NOT NULL
  • change_summary — VARCHAR(500)
  • created_at — TIMESTAMP — NOT NULL

member

  • member_id — BIGINT — 기본 키 — NOT NULL
  • member_name — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(30)
  • profile_image_url — VARCHAR(500)
  • role — ENUM('USER', 'ADMIN') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP
  • provider — ENUM('LOCAL', 'GOOGLE', 'GITHUB')
  • provider_id — BIGNT

notification

  • notification_id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • type — ENUM('PIPELINE_COMPLETE', 'PIPELINE_FAILED', 'TEAM_INVITE', 'MENTION') — NOT NULL
  • title — VARCHAR(300) — NOT NULL
  • content — TEXT
  • reference_type — ENUM('PIPELINE', 'PROJECT', 'TEAM')
  • reference_id — BIGINT
  • is_read — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

pipeline_artifact

  • artifact_id — BIGINT — 기본 키 — NOT NULL
  • execution_id — BIGINT — 외래 키 → pipeline_execution.execution_id — NOT NULL
  • artifact_type — ENUM('PRD', 'DB_SCHEMA', 'API_SPEC', 'FEATURE_LIST', 'MARKET_RESEARCH', 'QA_REPORT') — NOT NULL
  • content — TEXT — NOT NULL
  • version — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

pipeline_execution

  • execution_id — BIGINT — 기본 키 — NOT NULL
  • pipeline_id — VARCHAR(36) — NOT NULL
  • requirement_id — BIGINT — 외래 키 → requirement.requirement_id — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • user_query — TEXT
  • status — ENUM('RUNNING', 'COMPLETED', 'FAILED', 'RETRYING') — NOT NULL
  • retry_count — INT — NOT NULL
  • error_message — TEXT
  • started_at — TIMESTAMP
  • completed_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

project

  • project_id — BIGINT — 기본 키 — NOT NULL
  • team_id — BIGINT — 외래 키 → team.team_id — NOT NULL
  • project_name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • status — ENUM('PLANNING', 'IN_PROGRESS', 'COMPLETED') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

project_member

  • project_member_id — BIGINT — 기본 키 — NOT NULL
  • project_id — BIGINT — 외래 키 → project.project_id — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • project_role — ENUM('PM', 'BACKEND', 'FRONTEND', 'DESIGNER', 'INFRA') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

requirement

  • requirement_id — BIGINT — 기본 키 — NOT NULL
  • project_id — BIGINT — 외래 키 → project.project_id — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • title — VARCHAR(300) — NOT NULL
  • content — TEXT — NOT NULL
  • status — ENUM('DRAFT', 'SUBMITTED', 'PROCESSING', 'COMPLETED', 'FAILED') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

team

  • team_id — BIGINT — 기본 키 — NOT NULL
  • team_name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • invite_code — VARCHAR(20)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

team_member

  • team_member_id — BIGINT — 기본 키 — NOT NULL
  • team_id — BIGINT — 외래 키 → team.team_id — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • team_role — ENUM('OWNER', 'MEMBER') — NOT NULL
  • joined_at — TIMESTAMP — NOT NULL