보영

테이블 (8)

TB_AUTO_MODEL_RESULTS

  • RESULT_ID — UUID — 기본 키 — NOT NULL
  • WORK_RESULT_ID — UUID — 외래 키 → TB_WORKLOG_AUTO_MODEL.WORK_RESULT_ID — NOT NULL
  • MODEL_ID — UUID — 외래 키 → TB_MODELS.MODEL_ID — NOT NULL
  • MODEL_RESULT — JSONB
  • IS_SAVED — BOOLEAN

TB_DATASETS

  • DATASET_ID — UUID — 기본 키 — NOT NULL
  • PATH — TEXT
  • NAME — VARCHAR(50)
  • INFO — JSONB
  • FILE_EXTENSION — FILEEXTENSION
  • DATASET_STATUS — UPLOADSTATUS
  • UPLOAD_AT — TIMESTAMP
  • DELETED_AT — TIMESTAMP

TB_MODELS

  • MODEL_ID — UUID — 기본 키 — NOT NULL
  • NAME — VARCHAR(100)
  • MODEL_TYPE — MODELTYPE
  • TASK_TYPE — TASKTYPE
  • INFO — JSONB
  • HYPERPARAMETER — JSONB
  • FILE_PATH — TEXT
  • FILE_EXTENSION — FILEEXTENSION
  • MODEL_STATUS — MODELSTATUS
  • CREATE_AT — TIMESTAMP
  • IS_DELETED — BOOLEAN
  • DELETED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP

TB_PROJECTS

  • PROJECT_ID — UUID — 기본 키 — NOT NULL
  • DATASET_NAME — VARCHAR(50)
  • PROJECT_NAME — VARCHAR(50)
  • PROJECT_TYPE — PROJECTTYPE
  • PROJECT_STATUS — PROJECTSTATUS
  • CREATE_AT — TIMESTAMP
  • STARTED_AT — TIMESTAMP
  • COMPLETE_AT — TIMESTAMP
  • DELETED_AT — TIMESTAMP

TB_WORKLOGS_OPTIMIZATION

  • WORK_RESULT_ID — UUID — 기본 키 — NOT NULL
  • DATASET_ID — UUID — 외래 키 → TB_DATASETS.DATASET_ID — NOT NULL
  • MODEL_ID — UUID — 외래 키 → TB_MODELS.MODEL_ID — NOT NULL
  • TASK_ID — TEXT — NOT NULL
  • INDEPENDENT_VARIABLE — JSONB
  • DEPENDENT_VARIABLE — JSONB
  • OPTIMIZATION_RESULT — JSONB
  • STARTED_AT — TIMESTAMP
  • COMPLETE_AT — TIMESTAMP

TB_WORKLOGS_SIMULATION

  • WORK_RESULT_ID — UUID — 기본 키 — NOT NULL
  • DATASET_ID — UUID — 외래 키 → TB_DATASETS.DATASET_ID — NOT NULL
  • MODEL_ID — UUID — 외래 키 → TB_MODELS.MODEL_ID — NOT NULL
  • TASK_ID — TEXT — NOT NULL
  • INDEPENDENT_VARIABLE — JSONB
  • DEPENDENT_VARIABLE — JSONB
  • STARTED_AT — TIMESTAMP
  • COMPLETED_AT — TIMESTAMP

TB_WORKLOG_AUTO_MODEL

  • WORK_RESULT_ID — UUID — 기본 키 — NOT NULL
  • DATASET_ID — UUID — 외래 키 → TB_DATASETS.DATASET_ID — NOT NULL
  • PROJECT_ID — UUID — 외래 키 → TB_PROJECTS.PROJECT_ID — NOT NULL
  • TASK_TYPE — TASKTYPE
  • INDEPENDENT_VARIABLE — JSONB
  • DEPENDENT_VARIABLE — JSONB

TB_WORKLOG_AUTO_TUNING

  • WORK_RESULT_ID — UUID — 기본 키 — NOT NULL
  • DATASET_ID — UUID — 외래 키 → TB_DATASETS.DATASET_ID — NOT NULL
  • PROJECT_ID — UUID — 외래 키 → TB_PROJECTS.PROJECT_ID — NOT NULL
  • MODEL_ID — UUID — 외래 키 → TB_MODELS.MODEL_ID — NOT NULL
  • INDEPENDENT_VARIABLE — JSONB
  • DEPENDENT_VARIABLE — JSONB
  • MODEL_RESULT — JSONB
  • IS_SAVED — BOOLEAN — NOT NULL