erd_safety_ship

Tables (13)

Announcement

  • announcement_id — INTEGER — Primary key — NOT NULL
  • title — VARCHAR(255)
  • content — VARCHAR(2048)
  • created_at — DATETIME
  • updated_at — DATETIME

FishNet

  • fishnet_id — INTEGER — Primary key — NOT NULL
  • fish_category_id — VARCHAR(255) — Foreign key → FishNetCategory.fish_category_id — NOT NULL
  • ship_category_id — VARCHAR(255) — Foreign key → ShipCategory.ship_category_id — NOT NULL
  • year — INTEGER
  • month — INTEGER
  • lat — FLOAT
  • long — FLOAT
  • fishing_hour — FLOAT
  • amount — FLOAT
  • cpue — FLOAT

FishNetCategory

  • fish_category_id — VARCHAR(255) — Primary key — NOT NULL
  • category_name — VARCHAR(255)
  • category_description — VARCHAR(4096)
  • category_origin_name — VARCHAR(255)
  • category_appearance — VARCHAR(4096)
  • category_ecology — VARCHAR(4096)
  • category_habitat — VARCHAR(4096)

FishNetFishSpeciesRelation

  • fish_net_fish_species_id — VARCHAR(255) — Primary key — NOT NULL
  • fish_category_id — VARCHAR(255) — Foreign key → FishNetCategory.fish_category_id — NOT NULL
  • fish_id — VARCHAR(255) — Foreign key → FishSpecies.fish_id — NOT NULL

FishSpecies

  • fish_id — VARCHAR(255) — Primary key — NOT NULL
  • fish_name — VARCHAR(255)
  • fish_description — VARCHAR(1024)

Inquiry

  • inquiry_id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → User.user_id — NOT NULL
  • title — VARCHAR(255)
  • content — VARCHAR(8192)
  • reply_content — VARCHAR(8192)
  • is_reply — TINYINT(1)
  • created_at — DATETIME
  • updated_at — DATETIME

Location (location)

  • location_id — VARCHAR(255) — Primary key — NOT NULL
  • uid — VARCHAR(255) — Foreign key → User.user_id — NOT NULL
  • latitude — FLOAT
  • longitude — FLOAT
  • speed — FLOAT
  • bearing — FLOAT
  • device_id — VARCHAR
  • created_at — DATETIME
  • updated_at — DATETIME

ReadMember

  • read_member_id — VARCHAR(255) — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → User.user_id — NOT NULL
  • announcement_id — INTEGER — Foreign key → Announcement.announcement_id — NOT NULL
  • is_read — TINYINY(1)

Sensor (sensor)

  • sensor_id — VARCHAR(255) — Primary key — NOT NULL
  • uid — VARCHAR(255) — Foreign key → User.user_id — NOT NULL
  • sensor_name — VARCHAR
  • sensor_value_1 — FLOAT
  • sensor_value_2 — FLOAT
  • sensor_value_3 — FLOAT
  • sensor_device_name — VARCHAR
  • device_id — VARCHAR
  • created_at — DATETIME
  • updated_at — DATETIME

ShipCategory

  • ship_category_id — VARCHAR(255) — Primary key — NOT NULL
  • category_name — VARCHAR(255)

StabilityGroup

  • stability_group_id — VARCHAR(255) — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → User.user_id — NOT NULL
  • height_of_wave — VARCHAR(255)
  • progress_carrying — INTEGER
  • work_status — ENUM('none', 'throw', 'net')
  • created_at — DATETIME
  • updated_at — DATETIME

StabilityValue

  • stability_id — VARCHAR(255) — Primary key — NOT NULL
  • stability_group_id — VARCHAR(255) — Foreign key → StabilityGroup.stability_group_id — NOT NULL
  • timestamp — FLOAT
  • stability_value — FLOAT
  • created_at — DATETIME
  • updated_at — DATETIME

User (user)

  • user_id — INTEGER — Primary key — NOT NULL
  • id — VARCHAR(32)
  • password — VARCHAR(255)
  • mmsi — VARCHAR(255)
  • length — VARCHAR(255)
  • width — VARCHAR(255)
  • shipname — VARCHAR(255)
  • device_name — VARCHAR(255)
  • tonnage — VARCHAR(255)
  • callsign — VARCHAR(255)
  • fishing_ship_type — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME