unico_infotech - Laravel Schema Designer

tbl_user

user_id increments
user_mobile_country_code string (10)
user_mobile string (45)
password string
user_email string (100)
user_type_slug enum
user_status enum
otp_verified datetime
user_logindate datetime
user_ip string (39)
company_id ^FK integer
user_created datetime
user_updated datetime
user_deleted datetime

tbl_setting_equipment_category

equipment_category_id increments
equipment_category_priority integer
equipment_category_name string (100)
equipment_category_description text
equipment_category_status enum
equipment_category_created datetime
equipment_category_updated datetime
equipment_category_deleted datetime

tbl_setting_equipment_type

equipment_type_id increments
equipment_type_priority integer
equipment_category_id ^FK integer
equipment_type_name string (100)
equipment_type_description text
equipment_type_remark text
equipment_type_status enum
equipment_type_created datetime
equipment_type_updated datetime
equipment_type_deleted datetime

tbl_setting_particular

particular_id increments
particular_priority integer
particular_category_id ^FK integer
particular_name string (100)
particular_description text
particular_format enum
is_required_value tinyInteger
is_display_name tinyInteger
particular_properties json
particular_prefix string (45)
particular_postfix string (45)
particular_remark text
particular_status enum
particular_created datetime
particular_updated datetime
particular_deleted datetime

tbl_setting_particular_category

particular_category_id increments
particular_category_priority integer
particular_category_name string (100)
particular_category_status enum
particular_category_description text
particular_category_created datetime
particular_category_updated datetime
particular_category_deleted datetime

tbl_fleet

fleet_id increments
fleet_title string (100)
fleet_description text
fleet_remark text
owner_id ^FK integer
user_id ^FK integer
fleet_created datetime
fleet_updated datetime
fleet_deleted datetime

tbl_vessel

vessel_id increments
fleet_id ^FK integer
vessel_type_id ^FK integer
vessel_imo_code string (100)
vessel_name string (100)
vessel_remark text
vessel_description text
vessel_created datetime
vessel_updated datetime
vessel_deleted datetime

tbl_vessel_particular

vessel_particular_id increments
vessel_id ^FK integer
particular_id ^FK integer
vessel_particular_name string (100)
vessel_particular_value json
vessel_particular_created datetime
vessel_particular_updated datetime

tbl_vessel_equipment

vessel_equipment_id increments
vessel_equipment_type_id ^FK integer
equipment_id ^FK integer
vessel_equipment_name string (100)
vessel_equipment_value json
vessel_equipment_quantity integer
vessel_equipment_remark text
vessel_equipment_created datetime
vessel_equipment_updated timestamp

activity_log

tbl_fleet_pic

fleet_pic_id increments
user_id ^FK integer
fleet_id ^FK integer
role_id ^FK integer

tbl_vessel_pic

vessel_pic_id integer
user_id ^FK integer
vessel_id ^FK integer
role_id ^FK integer

tbl_company

company_id increments
company_name string (100)
company_address string (100)
company_address_2 string (100)
company_postcode string (45)
city_id integer
city_port_id ^FK integer
company_created timestamp
company_deleted timestamp

tbl_setting_city_port

city_port_id increments
city_port_code string
city_port_name string (100)
city_port_description text
country_id ^FK integer
city_port_status enum
city_port_updated timestamp
city_port_created timestamps
city_port_deleted timestamps

tbl_fleet_ownership_transfer

fleet_ownership_transfer_id increments
fleet_id ^FK integer
user_id_old ^FK integer
user_id_new ^FK integer
fleet_ownership_transfer_status enum
fleet_ownership_transfer_created timestamp
fleet_ownership_transfer_expired timestamp

tbl_setting_pic_role

pic_role_id increments
pic_role_name string (100)
pic_role_type enum
pic_role_status enum
pic_role_created timestamp
pic_role_updated timestamp
pic_role_deleted timestamp

tbl_setting_option

option_id increments
option_value string (100)
model_type string
model_id integer
option_properties json
parent_option_id integer
option_created timestamp
option_updated timestamp

tbl_setting_vessel_type

vessel_type_id increments
vessel_type_priority integer
vessel_type_name string (100)
vessel_type_status enum
form_id ^FK integer
vessel_type_created datetime
vessel_type_updated datetime
vessel_type_deleted datetime

tbl_setting_form

form_id increments
form_name string (100)
form_description text
form_status enum
form_created timestamp
form_updated timestamp
form_deleted timestamp

tbl_setting_form_particular

form_id ^FK integer
particular_id ^FK integer

tbl_company_user

company_user_id increments
company_id ^FK integer
user_id ^FK integer
is_owner tinyInteger

tbl_vessel_service_report

vessel_service_report_id increments
vessel_id ^FK integer
vessel_equipment_type_id ^FK integer
vessel_service_report_name string (100)
vessel_service_report_date date
vessel_service_report_created timestamp
vessel_service_report_updated timestamp
vessel_service_report_deleted timestamp

tbl_user_contact

user_contact_id increments
user_id ^FK integer
contact_id ^FK integer
user_contact_remark text

tbl_setting_equipment

equipment_id increments
equipment_type_id ^FK integer
equipment_name string (100)
equipment_description text
equipment_format enum
is_required_value tinyInteger
is_quantity tinyInteger
equipment_properties json

tbl_vessel_equipment_attention_date

vessel_equipment_attention_date_id increments
vessel_equipment_id ^FK integer
vessel_equipment_name string (100)
vessel_equipment_attention_date date
vessel_id ^FK integer
is_notified tinyInteger

tbl_vessel_equipment_type

vessel_equipment_type_id increments
vessel_id ^FK integer
equipment_type_id integer
equipment_category_id ^FK integer
vessel_equipment_type_name string (100)
warning_type enum
vessel_equipment_created datetime
vessel_equipment_updated datetime