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