파랑프로젝트
테이블 (16)
area
- area_id — bigint — 기본 키 — NOT NULL
- area_address — varchar(255) — NOT NULL
- area_code — varchar(255) — NOT NULL
- area_name — varchar(255) — NOT NULL
board
- board_id — bigint — 기본 키 — NOT NULL
- Key — 기본 키 — NOT NULL
- board_title — varchar(255)
- board_content — text
- board_hates — varchar(255)
- board_img — varchar(255)
- board_likes — varchar(255)
- CreatedDate — datetime(6)
- board_writer_id — bigint
- board_writer_nick_name — varchar(45)
- board_tag_uuid — varchar(255)
- board_category — varchar(255)
- Field
fishing_sinker
- id — int — 기본 키 — NOT NULL
- fishing_category_id — int — NOT NULL
- fishing_category — varchar(45) — NOT NULL
- fishing_category_name — varchar(30) — NOT NULL
fishingcategory
- fishing_category_name — varchar(255) — 기본 키 — NOT NULL
- id — bigint
fishingfloat
- fishingFloatId — bigint — 기본 키 — NOT NULL
- fishing_category_id — bigint — NOT NULL
- fishing_float_appearance — varchar(255) — NOT NULL
- fishing_float_buoyancy — varchar(255) — NOT NULL
fishinghook
- fishing_hook_id — bigint — 기본 키 — NOT NULL
- fishing_category_id — bigint — NOT NULL
- fishingCategoryName — varchar(255)
- fishing_hook_brandname — varchar(255)
- fishing_hook_size — varchar(255) — NOT NULL
fishingline
- fishing_line_id — bigint — 기본 키 — NOT NULL
- fishing_category_id — bigint — NOT NULL
- fishing_line_length — varchar(255) — NOT NULL
fishingsinker
- fishing_sinker_id — bigint — 기본 키 — NOT NULL
- fishing_category_id — bigint — NOT NULL
- fishing_sinker_weight — varchar(255) — NOT NULL
fishingtaboo
- taboo_id — int — 기본 키 — NOT NULL
- species — varchar(45) — NOT NULL
- prohibition_startdate — date
- prohibition_enddate — date
- prohibition_body — bigint
- species_image_src — varchar(255)
fsb
- id — int — 기본 키 — NOT NULL
- fsboNm — varchar(50)
- fsnoNo — varchar(14)
- maxPsrNum — varchar(10)
- maxShcrNum — varchar(10)
- shpmHangNm — varchar(100)
probability
- id — bigint — 기본 키 — NOT NULL
- air_temp — varchar(100)
- fish_name — varchar(255)
- lat — varchar(100)
- lon — varchar(100)
- date — varchar(100)
- name — varchar(100)
- tide_time_score — varchar(100)
- time_type — varchar(100)
- total_score — varchar(255)
- water_temp — varchar(100)
- wave_height — varchar(100)
reply
- reply_id — bigint — 기본 키 — NOT NULL
- board_id — bigint — NOT NULL
- reply_content — varchar(255) — NOT NULL
- reply_hates — varchar(255)
- reply_likes — varchar(255)
- reply_updated_time — datetime(6)
- reply_writer_id — bigint — NOT NULL
tag
- tag_id — bigint — 기본 키 — NOT NULL
- tag_uuid — varchar(255)
- tag_content — varchar(255)
user
- userId — bigint — 기본 키 — NOT NULL
- user_age — varchar(255) — NOT NULL
- user_email — varchar(255) — NOT NULL
- user_name — varchar(255) — NOT NULL
- user_nick_name — varchar(255) — NOT NULL
- user_pnum — varchar(255) — NOT NULL
- user_password — varchar(255) — NOT NULL
- user_profile_picture — varchar(255)
- user_role — varchar(255)
- user_sex — varchar(255)
- CreatedDate — date
userinterest
- user_interest_id — bigint — 기본 키 — NOT NULL
- area_id — bigint — NOT NULL
- fishing_category_id — bigint — NOT NULL
- fishing_float_id — bigint — NOT NULL
- fishing_hook_id — bigint — NOT NULL
- fishing_line_id — bigint — NOT NULL
- fishing_sinker_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
weather
- weather_id — bigint — 기본 키 — NOT NULL
- fcst_date — varchar(100)
- fcst_time — varchar(100)
- fcst_pop — varchar(100)
- fcst_pcp — varchar(100)
- fcst_vec — varchar(100)
- fcst_reh — varchar(100)
- fcst_wav — varchar(100)
- fcst_sky — varchar(100)
- fcst_pty — varchar(100)
- fcst_harbor_name — varchar(100) — NOT NULL
- fcst_tmp — varchar(100)