파랑프로젝트

테이블 (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)