HiNAS 365

Tables (20)

account

  • account_id — uuid — NOT NULL
  • email — character — NOT NULL
  • name — character — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

account_role

  • account_id — uuid — NOT NULL
  • role_id — integer — NOT NULL

alembic_version

  • version_num — character — NOT NULL

common_version

  • common_version_id — uuid — NOT NULL
  • version — character — NOT NULL
  • release_date — date — NOT NULL

control_option

  • control_option_id — uuid — NOT NULL
  • ship_id — uuid — NOT NULL
  • dnv_cert — boolean — NOT NULL — DNV
  • show_navigation — boolean — NOT NULL — Show

install_file_download_status

  • install_file_download_status_id — integer — NOT NULL
  • file_name — character — NOT NULL
  • status — public.installfiledownloadstatusenum — NOT NULL
  • requested_at — timestamp — NOT NULL
  • started_at — timestamp
  • completed_at — timestamp
  • error_message — text

navigation_option

  • ship_id — uuid — NOT NULL
  • display_count — integer — NOT NULL
  • use_mip — boolean — NOT NULL — Whether
  • use_nas — boolean — NOT NULL — Whether
  • navigation_option_id — uuid — NOT NULL

permission

  • id — integer — NOT NULL
  • name — character — NOT NULL
  • description — character

product_common_compatibility

  • id — uuid — NOT NULL
  • product_version_id — uuid — NOT NULL
  • common_version_id — uuid — NOT NULL
  • status — character
  • note — character

product_version

  • product_version_id — uuid — NOT NULL
  • product_name — public.product — NOT NULL
  • version — character — NOT NULL
  • release_date — date — NOT NULL

release_asset

  • asset_id — uuid — NOT NULL
  • release_note_id — uuid
  • name — character — NOT NULL
  • url — character — NOT NULL
  • file_size — integer

release_note

  • release_note_id — uuid — NOT NULL
  • product — character — NOT NULL
  • version — character — NOT NULL
  • release_date — date — NOT NULL
  • summary — character
  • detail — text
  • helm_modules — json

role

  • id — integer — NOT NULL
  • name — character — NOT NULL
  • description — character

role_permission

  • role_id — integer — NOT NULL
  • permission_id — integer — NOT NULL

ship

  • ship_id — uuid — NOT NULL
  • name — character
  • imo_number — character — NOT NULL
  • hull_number — character
  • ship_owner — character
  • is_delivery — boolean — NOT NULL
  • created_at — timestamp — NOT NULL
  • account_id — uuid

ship_common

  • ship_common_id — uuid — NOT NULL
  • ship_id — uuid — NOT NULL
  • common_version_id — uuid — NOT NULL
  • os_version — character
  • use_ur_e27 — boolean — NOT NULL
  • cloud_deploy — boolean — NOT NULL

ship_product

  • ship_product_id — uuid — NOT NULL
  • ship_id — uuid — NOT NULL
  • product_name — public.product — NOT NULL
  • product_version_id — uuid

ship_vsat

  • ship_vsat_id — uuid — NOT NULL
  • ship_id — uuid — NOT NULL
  • name — character — NOT NULL
  • ip_address — character — NOT NULL
  • subnet_mask — character — NOT NULL
  • gateway — character — NOT NULL
  • dns — character — NOT NULL
  • memo — character
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

svm_option

  • ship_id — uuid — NOT NULL
  • camera_count — integer — NOT NULL — Number
  • camera_provider — character — NOT NULL
  • svm_option_id — uuid — NOT NULL

update

  • update_id — uuid — NOT NULL
  • ship_id — uuid — NOT NULL
  • status — public.updatestatusenum — NOT NULL
  • start_time — timestamp — NOT NULL
  • end_time — timestamp
  • common_version_from — character — NOT NULL
  • common_version_to — character — NOT NULL
  • svm_version_from — character
  • svm_version_to — character
  • navigation_version_from — character
  • navigation_version_to — character
  • control_version_from — character
  • control_version_to — character