크레인2

테이블 (7)

alignment_table

  • Key (alignment_id) — INT — 기본 키 — NOT NULL
  • alignment_time — DATETIME
  • misalignment — FLOAT
  • danger — BOOLEAN
  • Key (crane_id) — VARCHAR(50) — 외래 키 → crane_table.Key — NOT NULL

crane_ship_relation

  • Key (crane_id) — VARCHAR(50) — 외래 키 → crane_table.Key — NOT NULL
  • Key (ship_id) — VARCHAR(50) — 외래 키 → ship_table.Key — NOT NULL
  • start_time — DATETIME
  • end_time — DATETIME

crane_table

  • Key (crane_id) — VARCHAR(50) — 기본 키 — NOT NULL
  • capacity — FLOAT — NOT NULL
  • height — FLOAT
  • quay — VARCHAR(50)
  • working — BOOLEAN

crane_worker_relation

  • Key (crane_id) — VARCHAR(50) — 외래 키 → crane_table.Key — NOT NULL
  • Key (worker_id) — VARCHAR(50) — 외래 키 → worker_table.Key — NOT NULL
  • start_time — DATETIME
  • end_time — DATETIME

sensor_table

  • Key (sensor_id) — INT — 기본 키 — NOT NULL
  • sensor_time — DATETIME
  • ax — FLOAT
  • ay — FLOAT
  • az — FLOAT
  • gx — FLOAT
  • gy — FLOAT
  • gz — FLOAT
  • distance — FLOAT
  • Key (crane_id) — VARCHAR(50) — 외래 키 → crane_table.Key — NOT NULL

ship_table

  • Key (ship_id) — VARCHAR(50) — 기본 키 — NOT NULL
  • ship_type — VARCHAR(50) — NOT NULL
  • capacity — FLOAT — NOT NULL
  • tonnage — FLOAT — NOT NULL
  • destination — VARCHAR(100)
  • working — BOOLEAN

worker_table

  • Key (worker_id) — VARCHAR(50) — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • working — BOOLEAN