크레인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