tilda

Tables (10)

AnalyticsQuery

  • 분석쿼리ID (id) — INTEGER — Primary key — NOT NULL
  • 유저ID (user_id) — INTEGER — Foreign key → User.유저ID — NOT NULL
  • 쿼리타입 (query_type) — VARCHAR(30)
  • 타겟테이블 (target_table) — VARCHAR(50)
  • 쿼리문 (sql_query) — TEXT
  • 실행일 (executed_at) — TIMESTAMP
  • 실행시간 (execution_time) — INTERVAL
  • 결과횟수 (result_count) — INTEGER

Dataset

  • 데이터셋ID (id) — INTEGER — Primary key — NOT NULL
  • 유저ID (user_id) — INTEGER — Foreign key → User.유저ID — NOT NULL
  • 데이터셋이름 (name) — VARCHAR(100)
  • 데이터셋버전 (version) — VARCHAR(10)
  • 파일경로 (file_path) — VARCHAR(255)
  • 파일타입 (file_type) — VARCHAR(20)
  • 파일크기 (file_size) — BIGINT
  • 생성일 (created_at) — TIMESTAMP
  • 수정일 (updated_at) — TIMESTAMP

GpuResource

  • GPUID (id) — INTEGER — Primary key — NOT NULL
  • GPU이름 (name) — VARCHAR(50)
  • 상태 (status) — VARCHAR(20)
  • 할당정보 (allocated_to) — INTEGER
  • 생성일 (created_at) — TIMESTAMP
  • 수정일 (updated_at) — TIMESTAMP

InferenceRequest

  • 추론ID (id) — INTEGER — Primary key — NOT NULL
  • 유저ID (user_id) — INTEGER — Foreign key → User.유저ID — NOT NULL
  • 훈련ID (training_job_id) — INTEGER — Foreign key → ModelVersion.훈련ID — NOT NULL
  • 입력데이터 (input_data) — JSONB
  • 출력데이터 (output_data) — JSONB
  • 분석메타데이터 (analytics_metadata) — JSONB
  • 생성일 (created_at) — TIMESTAMP

Model

  • 모델ID (id) — INTEGER — Primary key — NOT NULL
  • 유저ID (user_id) — INTEGER — Foreign key → User.유저ID — NOT NULL
  • 데이터셋ID (dataset_id) — INTEGER — Foreign key → Dataset.데이터셋ID — NOT NULL
  • 모델이름 (name) — VARCHAR(100)
  • 삭제여부 (deleted) — BOOLEAN
  • 삭제일 (deleted_at) — TIMESTAMP
  • 저장기한 (restore_until) — TIMESTAMP
  • 생성일 (created_at) — TIMESTAMP
  • 수정일 (updated_at) — TIMESTAMP

ModelSchema

  • 훈련ID (training_job_id) — INTEGER — Foreign key → ModelVersion.훈련ID — NOT NULL
  • 입력스키마 (input_schema) — JSONB
  • 출력스키마 (output_schema) — JSONB
  • 생성일 (created_at) — TIMESTAMP

ModelVersion

  • 훈련ID (training_job_id) — INTEGER — Foreign key → TrainingJob.훈련ID — NOT NULL
  • 모델ID (model_id) — INTEGER — Foreign key → Model.모델ID — NOT NULL
  • 모델버전 (version) — VARCHAR(10)
  • 메트릭값 (metrics) — JSONB
  • 모델경로 (model_file_path) — VARCHAR(255)
  • 생성일 (created_at) — TIMESTAMP

Role

  • 역할ID (id) — INTEGER — Primary key — NOT NULL
  • 역할이름 (name) — VARCHAR(50)
  • 권한 (permissions) — JSONB
  • 생성일 (created_at) — TIMESTAMP

TrainingJob

  • 훈련ID (id) — INTEGER — Primary key — NOT NULL
  • 데이터셋ID (dataset_id) — INTEGER — Foreign key → Dataset.데이터셋ID — NOT NULL
  • 모델ID (model_id) — INTEGER — Foreign key → Model.모델ID — NOT NULL
  • GPUID (gpu_resource_id) — INTEGER — Foreign key → GpuResource.GPUID
  • 상태 (status) — VARCHAR(20)
  • 시작일 (started_at) — TIMESTAMP
  • 완료일 (completed_at) — TIMESTAMP
  • 생성일 (created_at) — TIMESTAMP

User

  • 유저ID (id) — INTEGER — Primary key — NOT NULL
  • 역할ID (role_id) — INTEGER — Foreign key → Role.역할ID — NOT NULL
  • 유저이름 (name) — VARCHAR(100)
  • 생성일 (created_at) — TIMESTAMP
  • 수정일 (updated_at) — TIMESTAMP