졸작
테이블 (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