ff
Tables (9)
files
- id — CHAR(24)
- project_id — CHAR(24) — NOT NULL
- folder_id — CHAR(24)
- path — VARCHAR(500) — NOT NULL
- latest_version_id — CHAR(24)
- created_at — DATETIME
- updated_at — DATETIME
folders
- id — CHAR(24)
- project_id — CHAR(24) — NOT NULL
- parent_folder_id — CHAR(24)
- name — VARCHAR(255) — NOT NULL
- path — VARCHAR(500) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
invitations
- id — CHAR(24)
- project_id — CHAR(24) — NOT NULL
- inviter_id — CHAR(24) — NOT NULL
- invitee_id — CHAR(24)
- invitee_email — VARCHAR(255)
- token — VARCHAR(255)
- status — ENUM('pending', 'accepted', 'declined', 'expired')
- expires_at — DATETIME
- responded_at — DATETIME
- created_at — DATETIME
previews
- id — CHAR(24)
- project_id — CHAR(24) — NOT NULL
- file_id — CHAR(24)
- version_id — CHAR(24) — NOT NULL
- preview_url — TEXT
- generated_at — DATETIME
- INDEX — (version_id)
project_members
- id — CHAR(24)
- project_id — CHAR(24) — NOT NULL
- user_id — CHAR(24) — NOT NULL
- role — ENUM('owner', 'maintainer', 'member')
- joined_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
projects
- id — CHAR(24)
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- owner_id — CHAR(24) — NOT NULL
- repo_path — TEXT
- status — ENUM('active', 'archived')
- created_at — DATETIME
- updated_at — DATETIME
rollbacks
- id — CHAR(24)
- project_id — CHAR(24) — NOT NULL
- target_commit_id — VARCHAR(255) — NOT NULL
- initiator_id — CHAR(24) — NOT NULL
- status — ENUM('pending', 'completed', 'failed')
- note — TEXT
- completed_at — DATETIME
- created_at — DATETIME
users
- id — CHAR(24)
- kakao_id — VARCHAR(255)
- google_id — VARCHAR(255)
- email — VARCHAR(255)
- name — VARCHAR(255)
- role — ENUM('user', 'admin')
- avatar_url — TEXT
- created_at — DATETIME
- last_login_at — DATETIME
versions
- id — CHAR(24)
- project_id — CHAR(24) — NOT NULL
- file_id — CHAR(24)
- commit_id — VARCHAR(255) — NOT NULL
- parent_commit_ids — JSON
- branch — VARCHAR(255)
- message — TEXT
- author_id — CHAR(24) — NOT NULL
- status — ENUM( 'draft', 'pending_review', 'approved', 'rejected', 'merged', 'rolled_back' )
- review_required_approvals — INT
- review_approvals — JSON
- artifact_storage_key — VARCHAR(255)
- artifact_diff — JSON
- artifact_preview_url — TEXT
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — (project_id, branch)