Class: PlanTable

URI: img_proteome:PlanTable

classDiagram class PlanTable click PlanTable href "../PlanTable/" PlanTable : access_predicates PlanTable : bytes PlanTable : cardinality PlanTable : cost PlanTable : cpu_cost PlanTable : depth PlanTable : distribution PlanTable : filter_predicates PlanTable : id PlanTable : io_cost PlanTable : object_alias PlanTable : object_instance PlanTable : object_name PlanTable : object_node PlanTable : object_owner PlanTable : object_type PlanTable : operation PlanTable : optimizer PlanTable : options PlanTable : other PlanTable : other_tag PlanTable : other_xml PlanTable : parent_id PlanTable : partition_id PlanTable : partition_start PlanTable : partition_stop PlanTable : plan_id PlanTable : position PlanTable : projection PlanTable : qblock_name PlanTable : remarks PlanTable : search_columns PlanTable : statement_id PlanTable : temp_space PlanTable : time PlanTable : timestamp

Slots

Name	Cardinality and Range	Inheritance
statement_id	0..1 String	direct
plan_id	0..1 Float	direct
timestamp	0..1 Datetime	direct
remarks	0..1 String	direct
operation	0..1 String	direct
options	0..1 String	direct
object_node	0..1 String	direct
object_owner	0..1 String	direct
object_name	0..1 String	direct
object_alias	0..1 String	direct
object_instance	0..1 Float	direct
object_type	0..1 String	direct
optimizer	0..1 String	direct
search_columns	0..1 Float	direct
id	0..1 Float	direct
parent_id	0..1 Float	direct
depth	0..1 Float	direct
position	0..1 Float	direct
cost	0..1 Float	direct
cardinality	0..1 Float	direct
bytes	0..1 Float	direct
other_tag	0..1 String	direct
partition_start	0..1 String	direct
partition_stop	0..1 String	direct
partition_id	0..1 Float	direct
other	0..1 String	direct
distribution	0..1 String	direct
cpu_cost	0..1 Float	direct
io_cost	0..1 Float	direct
temp_space	0..1 Float	direct
access_predicates	0..1 String	direct
filter_predicates	0..1 String	direct
projection	0..1 String	direct
time	0..1 Float	direct
qblock_name	0..1 String	direct
other_xml	0..1 String	direct

Identifier and Mapping Information

Schema Source

from schema: https://w3id.org/jgi/img_proteome

Mappings

Mapping Type	Mapped Value
self	img_proteome:PlanTable
native	img_proteome:PlanTable

LinkML Source

Direct

name: plan_table
from_schema: https://w3id.org/jgi/img_proteome
attributes:
  statement_id:
    name: statement_id
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: string
    required: false
  plan_id:
    name: plan_id
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: float
    required: false
  timestamp:
    name: timestamp
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: datetime
    required: false
  remarks:
    name: remarks
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: string
    required: false
  operation:
    name: operation
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: string
    required: false
  options:
    name: options
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: string
    required: false
  object_node:
    name: object_node
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: string
    required: false
  object_owner:
    name: object_owner
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: string
    required: false
  object_name:
    name: object_name
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: string
    required: false
  object_alias:
    name: object_alias
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: string
    required: false
  object_instance:
    name: object_instance
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: float
    required: false
  object_type:
    name: object_type
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: string
    required: false
  optimizer:
    name: optimizer
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: string
    required: false
  search_columns:
    name: search_columns
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: float
    required: false
  id:
    name: id
    from_schema: https://w3id.org/jgi/img_proteome
    domain_of:
    - ms_experiment_ext_links
    - ms_sample_ext_links
    - plan_table
    range: float
    required: false
  parent_id:
    name: parent_id
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: float
    required: false
  depth:
    name: depth
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: float
    required: false
  position:
    name: position
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: float
    required: false
  cost:
    name: cost
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: float
    required: false
  cardinality:
    name: cardinality
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: float
    required: false
  bytes:
    name: bytes
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: float
    required: false
  other_tag:
    name: other_tag
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: string
    required: false
  partition_start:
    name: partition_start
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: string
    required: false
  partition_stop:
    name: partition_stop
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: string
    required: false
  partition_id:
    name: partition_id
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: float
    required: false
  other:
    name: other
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: string
    required: false
  distribution:
    name: distribution
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: string
    required: false
  cpu_cost:
    name: cpu_cost
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: float
    required: false
  io_cost:
    name: io_cost
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: float
    required: false
  temp_space:
    name: temp_space
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: float
    required: false
  access_predicates:
    name: access_predicates
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: string
    required: false
  filter_predicates:
    name: filter_predicates
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: string
    required: false
  projection:
    name: projection
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: string
    required: false
  time:
    name: time
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: float
    required: false
  qblock_name:
    name: qblock_name
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: string
    required: false
  other_xml:
    name: other_xml
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    domain_of:
    - plan_table
    range: string
    required: false

Induced

name: plan_table
from_schema: https://w3id.org/jgi/img_proteome
attributes:
  statement_id:
    name: statement_id
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: statement_id
    owner: plan_table
    domain_of:
    - plan_table
    range: string
    required: false
  plan_id:
    name: plan_id
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: plan_id
    owner: plan_table
    domain_of:
    - plan_table
    range: float
    required: false
  timestamp:
    name: timestamp
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: timestamp
    owner: plan_table
    domain_of:
    - plan_table
    range: datetime
    required: false
  remarks:
    name: remarks
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: remarks
    owner: plan_table
    domain_of:
    - plan_table
    range: string
    required: false
  operation:
    name: operation
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: operation
    owner: plan_table
    domain_of:
    - plan_table
    range: string
    required: false
  options:
    name: options
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: options
    owner: plan_table
    domain_of:
    - plan_table
    range: string
    required: false
  object_node:
    name: object_node
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: object_node
    owner: plan_table
    domain_of:
    - plan_table
    range: string
    required: false
  object_owner:
    name: object_owner
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: object_owner
    owner: plan_table
    domain_of:
    - plan_table
    range: string
    required: false
  object_name:
    name: object_name
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: object_name
    owner: plan_table
    domain_of:
    - plan_table
    range: string
    required: false
  object_alias:
    name: object_alias
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: object_alias
    owner: plan_table
    domain_of:
    - plan_table
    range: string
    required: false
  object_instance:
    name: object_instance
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: object_instance
    owner: plan_table
    domain_of:
    - plan_table
    range: float
    required: false
  object_type:
    name: object_type
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: object_type
    owner: plan_table
    domain_of:
    - plan_table
    range: string
    required: false
  optimizer:
    name: optimizer
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: optimizer
    owner: plan_table
    domain_of:
    - plan_table
    range: string
    required: false
  search_columns:
    name: search_columns
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: search_columns
    owner: plan_table
    domain_of:
    - plan_table
    range: float
    required: false
  id:
    name: id
    from_schema: https://w3id.org/jgi/img_proteome
    alias: id
    owner: plan_table
    domain_of:
    - ms_experiment_ext_links
    - ms_sample_ext_links
    - plan_table
    range: float
    required: false
  parent_id:
    name: parent_id
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: parent_id
    owner: plan_table
    domain_of:
    - plan_table
    range: float
    required: false
  depth:
    name: depth
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: depth
    owner: plan_table
    domain_of:
    - plan_table
    range: float
    required: false
  position:
    name: position
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: position
    owner: plan_table
    domain_of:
    - plan_table
    range: float
    required: false
  cost:
    name: cost
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: cost
    owner: plan_table
    domain_of:
    - plan_table
    range: float
    required: false
  cardinality:
    name: cardinality
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: cardinality
    owner: plan_table
    domain_of:
    - plan_table
    range: float
    required: false
  bytes:
    name: bytes
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: bytes
    owner: plan_table
    domain_of:
    - plan_table
    range: float
    required: false
  other_tag:
    name: other_tag
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: other_tag
    owner: plan_table
    domain_of:
    - plan_table
    range: string
    required: false
  partition_start:
    name: partition_start
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: partition_start
    owner: plan_table
    domain_of:
    - plan_table
    range: string
    required: false
  partition_stop:
    name: partition_stop
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: partition_stop
    owner: plan_table
    domain_of:
    - plan_table
    range: string
    required: false
  partition_id:
    name: partition_id
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: partition_id
    owner: plan_table
    domain_of:
    - plan_table
    range: float
    required: false
  other:
    name: other
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: other
    owner: plan_table
    domain_of:
    - plan_table
    range: string
    required: false
  distribution:
    name: distribution
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: distribution
    owner: plan_table
    domain_of:
    - plan_table
    range: string
    required: false
  cpu_cost:
    name: cpu_cost
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: cpu_cost
    owner: plan_table
    domain_of:
    - plan_table
    range: float
    required: false
  io_cost:
    name: io_cost
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: io_cost
    owner: plan_table
    domain_of:
    - plan_table
    range: float
    required: false
  temp_space:
    name: temp_space
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: temp_space
    owner: plan_table
    domain_of:
    - plan_table
    range: float
    required: false
  access_predicates:
    name: access_predicates
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: access_predicates
    owner: plan_table
    domain_of:
    - plan_table
    range: string
    required: false
  filter_predicates:
    name: filter_predicates
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: filter_predicates
    owner: plan_table
    domain_of:
    - plan_table
    range: string
    required: false
  projection:
    name: projection
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: projection
    owner: plan_table
    domain_of:
    - plan_table
    range: string
    required: false
  time:
    name: time
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: time
    owner: plan_table
    domain_of:
    - plan_table
    range: float
    required: false
  qblock_name:
    name: qblock_name
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: qblock_name
    owner: plan_table
    domain_of:
    - plan_table
    range: string
    required: false
  other_xml:
    name: other_xml
    from_schema: https://w3id.org/jgi/img_proteome
    rank: 1000
    alias: other_xml
    owner: plan_table
    domain_of:
    - plan_table
    range: string
    required: false