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