ㄱㄱㅂㅈ
Tables (8)
cruise
- cruise_no — INT — Primary key — NOT NULL
- proj_no — INT — Foreign key → project.proj_no — NOT NULL
- cruise_nm — VARCHAR(255) — NOT NULL
- start_dt — TIMESTAMP
- end_dt — TIMESTAMP
- area — VARCHAR(255)
- timezone — VARCHAR(255)
- docfile_nm — VARCHAR(255)
- docfile_savenm — VARCHAR(255)
- docfile_path — VARCHAR(255)
- ref_nm — VARCHAR(255)
- ref_savenm — VARCHAR(255)
- ref_path — VARCHAR(255)
- reg_nm — VARCHAR(255)
- reg_dt — TIMESTAMP
- mod_nm — VARCHAR(255)
- mod_dt — TIMESTAMP
- crt_dt — TIMESTAMP
project
- proj_no — INT — Primary key — NOT NULL
- proj_nm — VARCHAR(255) — NOT NULL
- crt_dt — TIMESTAMP
station
- stat_no — INT — Primary key — NOT NULL
- cruise_no — INT — Foreign key → cruise.cruise_no — NOT NULL
- stat_nm — VARCHAR(255) — NOT NULL
- obs_dt — TIMESTAMP — NOT NULL
- obs_lat — DECIMAL(18,8)
- obs_lon — DECIMAL(18,8)
- water_depth — DECIMAL(18,4)
- cloud_amount — DECIMAL(18,4)
- wave_height — DECIMAL(18,4)
- wind_speed — DECIMAL(18,4)
- surf_temp — DECIMAL(18,4)
- surf_salt — DECIMAL(18,4)
- air_img_nm — VARCHAR(255)
- air_img_savenm — VARCHAR(255)
- air_img_path — VARCHAR(500)
- sea_img_nm — VARCHAR(255)
- sea_img_savenm — VARCHAR(255)
- sea_img_path — VARCHAR(500)
- solr_img_nm — VARCHAR(255)
- solr_img_savenm — VARCHAR(255)
- solr_img_path — VARCHAR(500)
- field_img_nm — VARCHAR(255)
- field_img_savenm — VARCHAR(255)
- field_img_path — VARCHAR(500)
- field_note_nm — VARCHAR(255)
- field_note_savenm — VARCHAR(255)
- field_note_path — VARCHAR(500)
- rsch_org — VARCHAR(255)
- rscher — VARCHAR(255)
- crt_dt — TIMESTAMP
- geom — TEXT
station_file_info
- file_no — INT — Primary key — NOT NULL
- file_name — VARCHAR(255) — NOT NULL
- dir_path — TEXT
- acquisition_time — TIMESTAMP — NOT NULL
- processed — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
station_rrs_data
- data_no — INT — Primary key — NOT NULL
- file_no — INT — Foreign key → station_file_info.file_no — NOT NULL
- rrs — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- solar_azimuth_angle — DOUBLE
- solar_zenith_angle — DOUBLE
- viewing_azimuth_angle — DOUBLE
- viewing_zenith_angle — DOUBLE
- reflectance — TEXT
- std_reflectance — TEXT
- reflectance_nosc — TEXT
- std_reflectance_nosc — TEXT
- water_leaving_radiance — TEXT
- std_water_leaving_radiance — TEXT
user_auth
- auth_no — INT — Primary key — NOT NULL
- auth_role — VARCHAR(10) — NOT NULL
user_info
- user_id — VARCHAR(100) — Primary key — NOT NULL
- user_pw — VARCHAR(100) — NOT NULL
- user_nm — VARCHAR(100) — NOT NULL
- user_comp_nm — VARCHAR(100) — NOT NULL
- create_dt — TIMESTAMP — NOT NULL
- update_dt — TIMESTAMP
- auth_role — VARCHAR(10) — Foreign key → user_auth.auth_role — NOT NULL
user_log
- log_no — INT — Primary key — NOT NULL
- user_id — VARCHAR(100) — Foreign key → user_info.user_id — NOT NULL
- log_dt — TIMESTAMP — NOT NULL