한강뷰_뉴
테이블 (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