usage

Tables (13)

emails

  • id — int(11) — Primary key — NOT NULL
  • user_id — varchar(100)
  • email — varchar(100)

operation_details

  • id — int(11) — Primary key — NOT NULL
  • operation_id — int(11) — Foreign key → operations.id
  • status_id — int(11) — Foreign key → operation_status.id
  • status_msg — varchar(400)
  • image — varchar(200) — NOT NULL
  • gpu_type — varchar(100)
  • gpu_num — int(11)
  • replicas — int(11)
  • ready_replicas — int(11)
  • origin_replicas — int(11)
  • error_timestamp — int(11)
  • is_autoscale — tinyint(1)

operation_status

  • _id — int(11) — Primary key — NOT NULL
  • id — int(11) — NOT NULL
  • value — varchar(100) — NOT NULL
  • order_id — int(11)

operation_temps

  • id — int(11) — Primary key — NOT NULL
  • user — varchar(100)
  • updated_time — timestamp — NOT NULL
  • data — json

operations

  • id — int(11) — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • namespace — varchar(100) — NOT NULL
  • uid — varchar(100) — NOT NULL
  • project — varchar(100)
  • user — varchar(100)
  • created_at — int(11)
  • deleted_at — int(11)

pods

  • id — int(11) — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • namespace — varchar(100) — NOT NULL
  • uid — varchar(100) — NOT NULL
  • created_at — int(11)
  • deleted_at — int(11)
  • owner_type — varchar(100)
  • owner_name — varchar(100)
  • operation_id — int(11) — Foreign key → operations.id
  • workspace_id — int(11) — Foreign key → workspaces.id
  • gpu_uuid — text
  • project — varchar(100)
  • nodename — varchar(100)
  • is_error — tinyint(1)

ports

  • id — int(11) — Primary key — NOT NULL
  • operation_id — int(11) — Foreign key → operations.id
  • workspace_id — int(11) — Foreign key → workspaces.id
  • internal — int(11)
  • external — int(11)

resource_block

  • _id — int(11) — Primary key — NOT NULL
  • id — int(11)
  • cpu — decimal(10,3)
  • mem — decimal(10,3)
  • mem_unit — varchar(100)
  • gpu_type — varchar(100)
  • gpu_mem — decimal(10,3)
  • gpu_mem_unit — varchar(100)
  • gpu_per — int(11)
  • is_parted_gpu — tinyint(1)

resources

  • id — int(11) — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • value — varchar(100) — NOT NULL
  • pod_id — int(11) — Foreign key → pods.id — NOT NULL

status

  • id — int(11) — Primary key — NOT NULL
  • value — varchar(100) — NOT NULL
  • order_id — int(11)

transfer_history

  • id — int(11) — Primary key — NOT NULL
  • operation_id — int(11) — Foreign key → operations.id — NOT NULL
  • updated_time — timestamp — NOT NULL
  • transfer_from — varchar(100)
  • transfer_to — varchar(100)

workspace_details

  • id — int(11) — Primary key — NOT NULL
  • workspace_id — int(11) — Foreign key → workspaces.id
  • status_id — int(11) — Foreign key
  • resource_block_id — int(11) — Foreign key → resource_block._id — NOT NULL
  • status_msg — text
  • rgroup — varchar(100)
  • error_timestamp — int(11)
  • ssh_port — int(11)
  • jupyter_port — int(11)
  • is_jupyter — tinyint(1)
  • is_job — tinyint(1)
  • is_priority_pending — tinyint(1)
  • gpu_num — int(11)
  • cpu_num (Field2) — decimal(10,3)
  • mem_num (Field3) — decimal(10,3)
  • mem_unit (Field4) — decimal(10,3)
  • template_spec — json
  • image — varchar(200) — NOT NULL
  • reg_port (Field) — int(11)
  • image_digest (Field5) — varchar(100)

workspaces

  • id — int(11) — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • namespace — varchar(100) — NOT NULL
  • uid — varchar(100) — NOT NULL
  • user_id (Field) — varchar(100)
  • user_no (user) — int(11)
  • created_at — int(11)
  • deleted_at — int(11)