cctv

테이블 (10)

마커 (marker)

  • marker_no (Key) — INT — 기본 키 — NOT NULL
  • map_no — INT — 외래 키 → 지도타입.map_no — NOT NULL
  • marker_title (m_title) — VARCHAR(255) — ex) fire
  • marker_url (m_type) — VARCHAR(255) — ex) /upload/image/fire.ico

모듈 (module)

  • m_no (Key) — INT — 기본 키 — NOT NULL
  • v_no — INT — 외래 키 → 뷰테이블.v_no — NOT NULL
  • m_title — VARCHAR(255) — ex) 모듈명
  • m_type — VARCHAR(255) — ex) 그래프 or 리스트 or 맵 lets save it as korena name 그래프 -> graph 리스트 -> list 맵 -> map
  • m_template_no — INT — ex) 1 or 2 or 3 we manage templeate number by hardcode
  • m_column — VARCHAR(255) — school_name,count_user_age,sum_user_age
  • m_column_title — VARCHAR(255) — ex) school name, number of user, total age this column will have 3 value bcz, m_column have 3data
  • m_title_position — VARCHAR(255)
  • m_bg_color — VARCHAR(255) — ex) #352244
  • m_font_size — VARCHAR(255) — 7,6,6
  • m_font_color — VARCHAR(255) — #333444,#444555,#999222
  • m_time_create — datetime
  • m_time_update — datetime
  • m_del_yn — CHAR(1)
  • m_del_time — datetime

뷰테이블 (view_table)

  • v_no — INT — 기본 키 — NOT NULL
  • v_title — VARCHAR(255) — ex) 도시정보 뷰테이블
  • v_table_name — VARCHAR(255) — ex) user_city_visit_history
  • v_column — text — ex) school.name,school.address,city_name, city.population,city.size
  • v_column_count — text — ex) city_name, city.population,city.size
  • v_column_sum — text — user.visit_count,city.population
  • v_column_agv — text — ex) school.age,user.age,
  • v_column_group_by — test — city.name,city.area
  • v_column_order_by — text — city.age asc,city.area desc
  • v_sql — text — ex) CREATE OR REPLACE VIEW user_history AS SELECT school.name as school_name, count(user.age) as count_user_age, sum(us…
  • v_create_time — datetime
  • v_update_time — datetime
  • v_del_yn — CHAR(1)
  • v_del_time — datetime

사이트 (site)

  • s_no — INT — 기본 키 — NOT NULL
  • s_name — datetime — ex) my city fire
  • s_logo — datetime — ex) /img/pusan.jpg
  • s_time_create — datetime
  • s_time_updzte — datetime
  • s_del_yn — CHAR(1)
  • s_del_time — datetime

사이트 페이지 (site_page)

  • sp_no (Key) — INT — 기본 키 — NOT NULL
  • p_no — datetime — 외래 키 → 페이지.p_no — NOT NULL
  • s_no — datetime — 외래 키 → 사이트.s_no — NOT NULL
  • s_name — VARCHAR(255) — ex) small fire information
  • s_name_depth1 — VARCHAR(255) — ex) fire information

조인테이블 (join_table)

  • j_no — INT — 기본 키 — NOT NULL
  • v_no — INT — 외래 키 → 뷰테이블.v_no — NOT NULL
  • table1 — VARCHAR(255) — ex) School
  • table2 — VARCHAR(255) — ex) city
  • table1_key — VARCHAR(255) — ex) school.s_no
  • table2_key — VARCHAR(255) — ex) city.s_no
  • join_type — VARCHAR(255) — ex) left outer join

지도타입 (map)

  • map_no — INT — 기본 키 — NOT NULL
  • m_no — INT — 외래 키 → 모듈.m_no — NOT NULL
  • map_lat — DECIMAL(11,8) — ex) city_lat write column name that has city lat
  • map_lng — DECIMAL(12,8) — ex) city_lng write column name that has city lng
  • map_marker — VARCHAR(255) — ex) gender write column name that has marker type for example, if we want to use different marker male and female. choo…
  • mpa_number_of_marker — VARCHAR(255) — if user use 0, we need to show without limit, if we write 50, we show just 50 from center of map

페이지 (page)

  • p_no — INT — 기본 키 — NOT NULL
  • p_title — datetime — ex) school history
  • p_url — datetime — ex) /3/5
  • p_time_create — datetime
  • p_time_update — datetime
  • p_del_yn — CHAR(1)
  • p_del_time — datetime

페이지 모듈 (page_module)

  • pm_no — INT — 기본 키 — NOT NULL — it is about Absolute position in css and height and width of this moudle in this page
  • m_no — datetime — 외래 키 → 모듈.m_no — NOT NULL
  • p_no — datetime — 외래 키 → 페이지.p_no — NOT NULL
  • pm_top — INT — 1
  • pm_left — INT — 20
  • pm_height — INT — ex) 200 module height in this page
  • pm_width — INT — ex) 2000 module width in this page

필터 (filter)

  • f_no — INT — 기본 키 — NOT NULL — if there is data in filter, we will show filter if there is not, this module do not use filter
  • map_no — INT — 외래 키 → 지도타입.map_no — NOT NULL
  • f_category (marker_category) — VARCHAR(255) — CCTV
  • f_value — VARCHAR(255) — city