test diagram

Tables (11)

location (vl 단위)

  • id — id — Primary key — NOT NULL
  • 프로젝트 ID (project_id) — id — Foreign key → project.id — NOT NULL

location_vlmerge_storage (lvm)

  • id — id — Primary key — NOT NULL
  • id (location_id) — id — Foreign key → location.id — NOT NULL
  • Field

location_volume

  • id — id — Primary key — NOT NULL
  • id (location_id) — id — Foreign key → location.id — NOT NULL
  • id (vl_volume_id) — id — Foreign key → storage.id — NOT NULL
  • 계층 ID (id2) — id — Foreign key → spatial_structure.계층 ID — NOT NULL

location_workflow (lw)

  • id — id — Primary key — NOT NULL
  • 로케이션 ID (location_id) — id — Foreign key → location.id — NOT NULL
  • 워크플로우 ID (workflow_id) — id — Foreign key → workflow.워크플로우 ID — NOT NULL
  • 사용된 워크플로우 ID (used_workflow_id) — id — Foreign key → workflow.워크플로우 ID — NOT NULL
  • Field

project

  • id — id — Primary key — NOT NULL
  • Field

spatial_struct_dataset (location_dataset)

  • id — id — Primary key — NOT NULL
  • 계층 ID (spatial_structure_id) — id — Foreign key → spatial_structure.계층 ID — NOT NULL
  • raw 볼륨 ID (raw_volume_id) — id — Foreign key → storage.id — NOT NULL
  • data 볼륨 ID (data_volume_id) — id — Foreign key → storage.id — NOT NULL
  • graph 볼륨 ID (graph_volume_id) — id — Foreign key → storage.id — NOT NULL
  • map 볼륨 ID (map_volume_id) — id — Foreign key → storage.id — NOT NULL

spatial_structure (계층)

  • 계층 ID (id) — id — Primary key — NOT NULL
  • 프로젝트 ID (project_id) — id — Foreign key → project.id — NOT NULL
  • Field

spatial_structure_globalgraph (ssg)

  • id — id — Primary key — NOT NULL
  • id (spature_structure_id) — id — Foreign key → spatial_structure.계층 ID — NOT NULL
  • id (globalgraph_volume_id) — id — Foreign key → storage.id — NOT NULL

spatial_structure_workflow (spatial_structure)

  • id — id — Primary key — NOT NULL
  • 계층 ID (spatial_structure_id) — id — Foreign key → spatial_structure.계층 ID — NOT NULL
  • 워크플로우 ID (workflow_id) — id — Foreign key → workflow.워크플로우 ID — NOT NULL
  • 사용된 워크플로우 ID (used_workflow_id) — id — Foreign key → workflow.워크플로우 ID — NOT NULL

storage (volume)

  • id — id — Primary key — NOT NULL
  • project_id — id — Foreign key → project.id — NOT NULL
  • pvc 이름 (pvc_name) — varchar

workflow (워크플로우)

  • 워크플로우 ID (id) — id — Primary key — NOT NULL