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