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