한강뷰_뉴

테이블 (9)

attached_file

  • file_id — BIGSERIAL
  • file_path — VARCHAR(255)

cctv

  • wlobscd — VARCHAR
  • name — VARCHAR

hacheon

  • id — SERIAL
  • hacheon_name — TEXT
  • hacheon_grade — TEXT
  • start_location_province — TEXT
  • start_location_district — TEXT
  • start_location_town — TEXT
  • start_location_boundary — TEXT
  • start_plan_frequency — TEXT
  • start_plan_flood_volume — TEXT
  • start_plan_flood_level — TEXT
  • start_plan_width — TEXT
  • end_location_province — TEXT
  • end_location_district — TEXT
  • end_location_town — TEXT
  • end_location_boundary — TEXT
  • end_plan_frequency — TEXT
  • end_plan_flood_volume — TEXT
  • end_plan_flood_level — TEXT
  • end_plan_width — TEXT
  • river_length — TEXT
  • river_plan_declared_date — TEXT
  • river_plan_extension — TEXT
  • river_plan_end_established — TEXT
  • euro_length — TEXT
  • drainage_area — TEXT
  • river_remedy_total — TEXT
  • river_remedy_completion_zone — TEXT
  • river_remedy_reinforcement_zone — TEXT
  • river_remedy_creation_zone — TEXT
  • river_designation_basis_date — TEXT

member

  • member_id — BIGSERIAL
  • email — VARCHAR(50)
  • name — VARCHAR(20)
  • password — VARCHAR(100)
  • register_datetime — TIMESTAMP

post

  • post_id — BIGSERIAL
  • type — post_type — NOT NULL
  • title — VARCHAR(255)
  • department — VARCHAR(255)
  • person_in_charge — VARCHAR(255)
  • phone_number — VARCHAR(255)
  • context — TEXT
  • register_date — TIMESTAMP
  • view_count — INTEGER
  • member_id — BIGINT

post_file

  • post_id — BIGINT
  • file_id — BIGINT

untitled

  • gid — INTEGER
  • ufid — VARCHAR
  • name — VARCHAR
  • divi — VARCHAR
  • type — VARCHAR
  • stat — VARCHAR
  • scls — VARCHAR
  • fmta — VARCHAR

water_request

  • request_id — BIGSERIAL
  • name — VARCHAR(255)
  • applicant — VARCHAR(255)
  • tel — VARCHAR(255)
  • email — VARCHAR(255)
  • fax — VARCHAR(255)
  • river — VARCHAR(255)
  • message — TEXT
  • request_date — TIMESTAMP
  • member_id — BIGINT

water_request_file

  • request_id — BIGINT
  • file_id — BIGINT