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)