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