sloshing_db

Tables (10)

TB_SLOSHING_DB_MODEL_TEST

  • model_test_idx — int — Primary key — NOT NULL — model_test_idx
  • pjt_idx — int — Foreign key → TB_SLOSHING_DB_PROJECT_SUMMARY.pjt_idx — NOT NULL — 프로젝트 자동 증가
  • pjt_no — varchar(20) — Foreign key → TB_SLOSHING_DB_PROJECT_SUMMARY.pjt_no — NOT NULL — 프로젝트 넘버
  • run_no — varchar(10) — run no
  • wd — varchar(100) — motion file name
  • pjt_nm — varchar(100) — 프로젝트명
  • proj — varchar(50) — proj
  • tank_filling — float — tank filling
  • vessel_lc — varchar(20) — vessel_lc
  • vessel_v_real — float — vessel_v_real
  • wave_spectrum — varchar(20) — wave_spectrum
  • wave_hdg — float — wave_hdg
  • wave_tz_encounter — float — wave_tz_encounter
  • wave_tz — float — wave_tz
  • wave_gam — float — wave_gam
  • wave_tp_tz — float — wave_tp_tz
  • wave_tp — float — wave_tp
  • wave_na — float — wave_na
  • wave_hs_na — float — wave_hs_na
  • spread — varchar(10) — spread
  • model_1ch — float — model_1ch
  • model_all — float — model_all
  • all_1ch — float — all_1ch
  • full_scale_1ch — float — full_scale_1ch
  • full_scale_ratio — float — full_scale_ratio
  • full_scale_all — float — full_scale_all
  • sensor — float — sensor
  • ch — float — ch
  • seed_variation_accum1 — float — Seed variation for Design cases 평균1
  • seed_variation_accum2 — float — Seed variation for Design cases 평균2
  • heavy_gas_accum1 — float — Heavy gas 평균1
  • heavy_gas_accum2 — float — Heavy gas 평균2
  • type — varchar(20) — part1/part2/part3

TB_SLOSHING_DB_PROJECT_CCS

  • ccs_idx — int — Primary key — NOT NULL — ccs 자동 증가
  • pjt_idx — int — Foreign key → TB_SLOSHING_DB_PROJECT_SUMMARY.pjt_idx — NOT NULL — 프로젝트 자동 증가
  • pjt_no — varchar(20) — Foreign key → TB_SLOSHING_DB_PROJECT_SUMMARY.pjt_no — NOT NULL — 프로젝트 넘버
  • st — varchar(20) — st
  • ref — varchar(20) — Ref
  • pjt_nm — varchar(100) — 프로젝트명
  • site — varchar(20) — Site
  • vessel_lbp — float — vessel_lbp
  • vessel_b — float — vessel_b
  • vessel_d — float — vessel_d
  • vessel_tdes — float — vessel_Tdes
  • vessel_tsct — float — vessel_Tsct
  • row — varchar(10) — row
  • shape — varchar(10) — shape
  • tank_l — float — tank_l
  • tank_b — float — tank_b
  • tank_h — float — tank_h
  • tank_uch_in — float — tank_uch_in
  • tank_ucb_in — float — tank_ucb_in
  • tank_uch — float — tank_uch
  • tank_ucb — float — tank_ucb
  • tank_lch_in — float — tank_lch_in
  • tank_lcb_in — float — tank_lcb_in
  • tank_lch — float — tank_lch
  • tank_lcb — float — tank_lcb
  • tank_ucl — float — tank_ucl
  • tank_swh — float — tank_swh
  • tank_lc_out_angle — float — tank_lc_out_angle

TB_SLOSHING_DB_PROJECT_CCS_HIDDEN

  • ccs_hidden_idx — int — Primary key — NOT NULL — ccs_hidden_idx 자동 증가
  • pjt_idx — int — Foreign key → TB_SLOSHING_DB_PROJECT_SUMMARY.pjt_idx — NOT NULL — 프로젝트 자동 증가
  • pjt_no — varchar(20) — Foreign key → TB_SLOSHING_DB_PROJECT_SUMMARY.pjt_no — NOT NULL — 프로젝트 넘버
  • type — varchar(20) — type
  • hidden1 — float — hidden1
  • hidden2 — float — hidden2
  • hidden3 — float — hidden3
  • hidden4 — float — hidden4
  • hidden5 — float — hidden5
  • hidden6 — float — hidden6
  • hidden7 — float — hidden7
  • hidden8 — float — hidden8
  • hidden9 — float — hidden9

TB_SLOSHING_DB_PROJECT_CCS_MODEL_SCALE

  • ccs_model_scale_idx — int — Primary key — NOT NULL — ccs_model_scale_idx 자동 증가
  • pjt_idx — int — Foreign key → TB_SLOSHING_DB_PROJECT_SUMMARY.pjt_idx — NOT NULL — 프로젝트 자동 증가
  • pjt_no — varchar(20) — Foreign key → TB_SLOSHING_DB_PROJECT_SUMMARY.pjt_no — NOT NULL — 프로젝트 넘버
  • tank_volume — float — tank_volume
  • x_cen — float — X Cen (AP)
  • y_cen — float — Y Cen (CL)
  • y_in — float — y in (CL)
  • tank_btm — float — tank Btm (BL)
  • scale — float — scale
  • tank_model_l — float — tank_model_l
  • tank_model_b — float — tank_model_b
  • tank_model_h — float — tank_model_h
  • tank_model_uch_in — float — tank_model_uch_in
  • tank_model_uch — float — tank_model_uch
  • tank_model_lch_in — float — tank_model_lch_in
  • tank_model_lch — float — tank_model_lch
  • tank_model_vol — float — tank_model_vol
  • on_off — int — on_off

TB_SLOSHING_DB_PROJECT_DETAIL_INFO

  • detail_idx — int — Primary key — NOT NULL — detail 테이블 자동 증가
  • pjt_idx — int — Foreign key → TB_SLOSHING_DB_PROJECT_SUMMARY.pjt_idx — NOT NULL — 프로젝트 자동 증가
  • pjt_no — varchar(20) — Foreign key → TB_SLOSHING_DB_PROJECT_SUMMARY.pjt_no — NOT NULL — 프로젝트 넘버
  • pjt_nm — varchar(100) — 프로젝트 명
  • year_ref — varchar(50) — year, ref
  • descript — varchar(50) — descript
  • no — varchar(10) — no
  • lbp — float — LBP
  • b — float — B
  • d — float — D
  • ap — float — AP
  • mid — float — MID
  • fp — float — FP
  • ap_f — float — AP'
  • trim — float — Trim
  • disp — float — Disp
  • cb — float — Cb
  • kmtcal — float — KMTcal
  • kmt — float — KMT
  • kg — float — KG
  • kgt — float — KG/T
  • kgd — float — KG/D
  • gmt — float — GMT
  • gmlcal — float — GMLcal
  • ggo — float — GGO
  • gom — float — GoM
  • kgo — float — KGo
  • kgt2 — float — KG-T
  • kgot — float — KGo-T
  • lcg — float — LCG
  • kxx — float — Kxx
  • kyy — float — Kyy
  • kzz — float — Kzz
  • kxxb — float — Kxx/B
  • kyyl — float — Kyy/L
  • kzzl — float — Kzz/L
  • bt — float — B/T
  • roll_damping — float — roll_damping
  • a44_l44 — float — a44/l44
  • troll_s_sec — float — troll_s_sec
  • troll_s_rad — float — troll_s_rad/s
  • troll_f_sec — float — troll_f_sec
  • troll_f_rad — float — troll_f_rad/s
  • tpitch_sec — float — tpitch_sec
  • tpitch_rad — float — tpitch_rad
  • pitch_sec — float — pitch forcing sec
  • pitch_rad — float — pitch forcing rad/s
  • theave_sec — float — theave_sec
  • theave_rad — float — theave_rad

TB_SLOSHING_DB_PROJECT_SUMMARY

  • pjt_idx — int — Primary key — NOT NULL — 프로젝트 자동 증가
  • pjt_no — varchar(20) — Primary key — NOT NULL — 프로젝트 넘버
  • model_no — varchar(20) — 모델 넘버
  • pjt_nm — varchar(100) — NOT NULL — 프로젝트명
  • ship_type — varchar(10) — ship type
  • capacity — varchar(20) — capacity
  • remarks — varchar(400) — 비고
  • reg_dt — datetime — 등록 일시
  • reg_id — varchar(20) — 등록자
  • upd_dt — datetime — 수정 일시
  • upd_id — varchar(20) — 수정자

tb_sloshing_db_model_test_file

  • model_test_file_idx — int — Primary key — NOT NULL — 파일 번호
  • pjt_idx — int — Foreign key → TB_SLOSHING_DB_PROJECT_SUMMARY.pjt_idx — NOT NULL — 프로젝트 자동 증가
  • pjt_no — varchar(20) — Foreign key → TB_SLOSHING_DB_PROJECT_SUMMARY.pjt_no — NOT NULL — 프로젝트 넘버
  • lgcl_file_nm — varchar(150) — 논리 파일 명
  • pscl_file_nm — varchar(150) — 물리 파일 명
  • file_pth — varchar(200) — 파일 경로
  • file_size — varchar(20) — 파일 크기
  • file_ext — varchar(20) — 파일 확장자
  • type — varchar(20) — type
  • description — varchar(200) — 이미지 설명

tb_sloshing_db_monitoring_file

  • monitoring_file_idx — int — Primary key — NOT NULL — 파일 번호
  • pjt_idx — int — Foreign key → TB_SLOSHING_DB_PROJECT_SUMMARY.pjt_idx — NOT NULL — 프로젝트 자동 증가
  • pjt_no — varchar(20) — Foreign key → TB_SLOSHING_DB_PROJECT_SUMMARY.pjt_no — NOT NULL — 프로젝트 넘버
  • lgcl_file_nm — varchar(150) — 논리 파일 명
  • pscl_file_nm — varchar(150) — 물리 파일 명
  • file_pth — varchar(200) — 파일 경로
  • file_size — varchar(20) — 파일 크기
  • file_ext — varchar(20) — 파일 확장자
  • type — varchar(20) — type
  • date — varchar(50) — 날짜

tb_sloshing_db_numerical_ai_db

  • ai_idx — int — Primary key — NOT NULL — 인덱스 자동증가
  • pjt_idx — int — Foreign key → TB_SLOSHING_DB_PROJECT_SUMMARY.pjt_idx — NOT NULL — 프로젝트 자동 증가
  • pjt_no — varchar(20) — Foreign key → TB_SLOSHING_DB_PROJECT_SUMMARY.pjt_no — NOT NULL — 프로젝트 넘버
  • no — int — no
  • pjt_nm — varchar(100) — filling
  • experiment10 — float — experiment10
  • experiment20 — float — experiment20
  • experiment30 — float — experiment30
  • experiment40 — float — experiment40
  • experiment50 — float — experiment50
  • experiment60 — float — experiment60
  • experiment70 — float — experiment70
  • experiment80 — float — experiment80
  • experiment95 — float — experiment95
  • manager — varchar(20) — 담당자
  • environment — varchar(20) — 환경
  • abs_slosh10 — float — abs_slosh10
  • abs_slosh20 — float — abs_slosh20
  • abs_slosh30 — float — abs_slosh30
  • abs_slosh40 — float — abs_slosh40
  • abs_slosh50 — float — abs_slosh50
  • abs_slosh60 — float — abs_slosh60
  • abs_slosh70 — float — abs_slosh70
  • abs_slosh80 — float — abs_slosh80
  • abs_slosh95 — float — abs_slosh95
  • abs_slosh_adj10 — float — abs_slosh_adj10
  • abs_slosh_adj20 — float — abs_slosh_adj20
  • abs_slosh_adj30 — float — abs_slosh_adj30
  • abs_slosh_adj40 — float — abs_slosh_adj40
  • abs_slosh_adj50 — float — abs_slosh_adj50
  • abs_slosh_adj60 — float — abs_slosh_adj60
  • abs_slosh_adj70 — float — abs_slosh_adj70
  • abs_slosh_adj80 — float — abs_slosh_adj80
  • abs_slosh_adj95 — float — abs_slosh_adj95
  • abs_slosh_cor10 — float — abs_slosh_cor10
  • abs_slosh_cor20 — float — abs_slosh_cor20
  • abs_slosh_cor30 — float — abs_slosh_cor30
  • abs_slosh_cor40 — float — abs_slosh_cor40
  • abs_slosh_cor50 — float — abs_slosh_cor50
  • abs_slosh_cor60 — float — abs_slosh_cor60
  • abs_slosh_cor70 — float — abs_slosh_cor70
  • abs_slosh_cor80 — float — abs_slosh_cor80
  • abs_slosh_cor95 — float — abs_slosh_cor95
  • tunning_fac10 — float — tunning_fac10
  • tunning_fac20 — float — tunning_fac20
  • tunning_fac30 — float — tunning_fac30
  • tunning_fac40 — float — tunning_fac40
  • tunning_fac50 — float — tunning_fac50
  • tunning_fac60 — float — tunning_fac60
  • tunning_fac70 — float — tunning_fac70
  • tunning_fac80 — float — tunning_fac80
  • tunning_fac95 — float — tunning_fac95
  • remarks — varchar(150) — remarks

tb_sloshing_db_resonance_db

  • resonance_idx — int — Primary key — NOT NULL — resonance_idx
  • pjt_idx — int — Foreign key → TB_SLOSHING_DB_PROJECT_SUMMARY.pjt_idx — NOT NULL — 프로젝트 자동 증가
  • pjt_no — varchar(20) — Foreign key → TB_SLOSHING_DB_PROJECT_SUMMARY.pjt_no — NOT NULL — 프로젝트 넘버
  • filling_height_per — float — filling height [%]
  • filling_height_met — float — filling_height [m]
  • longitudinal — float — longitudinal
  • transverse — float — transverse