SSAFYHUB

Tables (8)

artifacts

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • artifact_type — VARCHAR(30) — NOT NULL
  • original_file_name — VARCHAR(255) — NOT NULL
  • bucket — VARCHAR(255) — NOT NULL
  • object_key — VARCHAR(500) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • expires_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

deployment_diagnoses

  • id — BIGINT — Primary key — NOT NULL
  • deployment_id — BIGINT — Foreign key → deployments.id — NOT NULL
  • source_log_id — BIGINT — Foreign key → deployment_logs.id — NOT NULL
  • payload_json — TEXT — NOT NULL
  • model — VARCHAR(60)
  • input_tokens — INT
  • output_tokens — INT
  • created_at — DATETIME(6) — NOT NULL

deployment_envs

  • id — BIGINT — Primary key — NOT NULL
  • deployment_id — BIGINT — Foreign key → deployments.id — NOT NULL
  • env_key — VARCHAR(100) — NOT NULL
  • encrypted_value — TEXT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

deployment_logs

  • id — BIGINT — Primary key — NOT NULL
  • deployment_id — BIGINT — Foreign key → deployments.id — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • log_message — TEXT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

deployment_outbox

  • id — BIGINT — Primary key — NOT NULL
  • deployment_id — BIGINT — Foreign key → deployments.id — NOT NULL
  • event_type — VARCHAR(50) — NOT NULL
  • payload — TEXT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • attempt_count — INT — NOT NULL
  • next_attempt_at — DATETIME(6) — NOT NULL
  • last_error — VARCHAR(500)
  • processed_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

deployments

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • backend_artifact_id — BIGINT — Foreign key → artifacts.id
  • frontend_artifact_id — BIGINT — Foreign key → artifacts.id
  • schema_artifact_id — BIGINT — Foreign key → artifacts.id
  • project_name — VARCHAR(100) — NOT NULL
  • slug — VARCHAR(150) — NOT NULL
  • runtime_version — VARCHAR(20)
  • tech_stack — VARCHAR(30)
  • internal_port — INT
  • database_name — VARCHAR(100)
  • encrypted_database_password — TEXT
  • database_engine — VARCHAR(20)
  • db_host_env_key — VARCHAR(100)
  • db_port_env_key — VARCHAR(100)
  • db_name_env_key — VARCHAR(100)
  • db_username_env_key — VARCHAR(100)
  • db_password_env_key — VARCHAR(100)
  • needed_services — VARCHAR(200)
  • endpoint_url — VARCHAR(500)
  • description — TEXT
  • visibility — VARCHAR(20) — NOT NULL
  • requested_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

members

  • id — BIGINT — Primary key — NOT NULL
  • student_number — VARCHAR(30) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • team_name — VARCHAR(50) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

refresh_tokens

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.id — NOT NULL
  • token_hash — VARCHAR(255) — NOT NULL
  • expires_at — DATETIME(6) — NOT NULL
  • revoked — TINYINT(1) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL