test
Tables (27)
api
- id — bigint — NOT NULL
- call_url — character
- method_type — character
- request_body_type — character
- response_body_type — character
- api_type — character
- target_url — character
- target_path — character
- content_type — character
- service_nm — character
- service_prefix — character
- auth_info — character
- tokens — character
api_param
- id — bigint — NOT NULL
- seq — integer
- field_nm — character
- field_map_nm — character
- data_type — character
- required — boolean
- param_type — character
- value — character
- description — character
- api_id — bigint
- crypto_type — character
- crypto_key — character
- parent_seq — integer
api_param_conv
- conv_seq — integer — Primary key — NOT NULL
- api_param_seq — integer
- value — character
gj_b_emd_4326
- gid — integer — NOT NULL
- emd_cd — character
- emd_nm — character
- sgg_oid — integer
- col_adm_se — character
- __gid — integer
- geom — public.geometry(MultiPolygon,4326)
spatial_ref_sys
- srid — integer — Primary key — NOT NULL
- auth_name — character
- auth_srid — integer
- srtext — character
- proj4text — character
t_area_code_name
- area_code — character — NOT NULL
- area_name — character
- use_yn — boolean
t_area_emd
- gid — integer — NOT NULL
- emd_cd — character
- emd_nm — character
- sgg_oid — integer
- col_adm_se — character
- __gid — integer
- geom — public.geometry(MultiPolygon,4326)
t_common_code
- code_seq — bigint — NOT NULL
- code_id — character
- code_name — character — NOT NULL
- code_value — character
- parent_code_seq — bigint
- use_kind — character — NOT NULL
- insert_dt — timestamp — NOT NULL
- insert_user_seq — bigint — NOT NULL
- update_dt — timestamp
- update_user_seq — bigint
t_config
- config_seq — integer — NOT NULL
- name — character
- value — character
- type — integer
- insert_dt — timestamp
- update_dt — timestamp
t_district
- district_seq — integer — NOT NULL
- district_name — character — NOT NULL
- insert_dt — timestamp
- insert_user_seq — integer
- update_dt — timestamp
- update_user_seq — integer
t_event
- event_seq — integer — NOT NULL
- facility_seq — integer — NOT NULL
- event_kind — integer
- event_grade — integer
- event_proc_stat — integer
- event_address — character
- event_start_dt — timestamp
- event_end_dt — timestamp
- event_manager — character
- event_mng_dt — timestamp
- event_mng_content — character
- insert_dt — timestamp — NOT NULL
- station_seq — integer
- event_message — character
t_exception
- EXCEPTION_SEQ — bigint — NOT NULL
- STATUS_CODE — character
- REQUEST_URL — character
- EXCEPTION_DT — date
- EXCEPTION_ADMIN_SEQ — bigint
- EXCEPTION_CONTENT — text
- SYSTEM_TYPE — character
- REQUEST_IP — character
t_face_detection
- face_seq — bigint — NOT NULL
- face_name — character — NOT NULL
- face_age — integer
- face_gender — smallint
- face_file — character
- face_similarity — double
- face_status — smallint
- face_kind — character
- face_uid — character
- insert_dt — timestamp
- insert_user_seq — bigint
- update_dt — timestamp
- update_user_seq — bigint
t_facility
- facility_seq — bigint — NOT NULL
- station_seq — bigint
- facility_kind — smallint — NOT NULL
- facility_status — smallint — NOT NULL
- facility_image — character
- facility_instl_info — character
- facility_instl_dt — timestamp
- insert_dt — timestamp
- insert_user_seq — integer
- update_user_seq — integer
- facility_id — character
- latitude — double
- longitude — double
- update_dt — timestamp
- administ_zone — character
- facility_name — character
t_facility_active_log
- facility_active_log_seq — bigint — NOT NULL
- facility_seq — integer — NOT NULL
- facility_active_check — boolean — NOT NULL
- facility_active_ip — character — NOT NULL
- insert_dt — timestamp
t_facility_opt
- facility_opt_seq — integer — NOT NULL
- facility_seq — integer — NOT NULL
- facility_opt_name — character — NOT NULL
- facility_opt_value — character — NOT NULL
- facility_opt_geom — public.geometry
- facility_opt_type — integer
- insert_dt — timestamp
- remark — character
t_net_mapping
- seq — bigint — NOT NULL
- ip — character — NOT NULL
- insert_date — timestamp
- update_date — timestamp
t_net_mapping_sub
- net_mapping_ip — character — NOT NULL
- seq — bigint — NOT NULL
- ip — character — NOT NULL
- port — character
- insert_date — timestamp
- update_date — timestamp
t_notice
- notice_seq — integer — NOT NULL
- notice_title — text — NOT NULL
- notice_content — text
- insert_dt — timestamp — NOT NULL
- insert_user_seq — integer
- update_dt — timestamp
- update_user_seq — integer
- notice_file — character
- notice_vectors — tsvector
t_permit
- permit_seq — integer — NOT NULL
- user_group_seq — integer
- user_seq — integer
- insert_dt — timestamp
- insert_user_seq — integer
- permit_name — character
- update_dt — timestamp
- update_user_seq — integer
t_signage_template
- template_seq — bigint — NOT NULL
- template_name — character — NOT NULL
- template_explain — character
- template_content — character — NOT NULL
- use_yn — character
t_station
- station_seq — bigint — NOT NULL
- station_name — character — NOT NULL
- station_kind — smallint — NOT NULL
- administ_zone — character
- address — character
- station_image — character
- station_compet_dt — timestamp
- station_size — integer
- station_material — character
- latitude — double
- longitude — double
t_user
- user_seq — bigint — NOT NULL
- id — character — NOT NULL
- password — character — NOT NULL
- email — character
- tel — character
- address — character
- detail_address — character
- last_login_dt — timestamp
- insert_user_seq — integer
- update_user_seq — integer
- insert_dt — timestamp
- update_dt — timestamp
- status — character
- refresh_token — character
- user_name — character
t_user_group
- user_group_seq — integer — NOT NULL
- user_group_name — character — NOT NULL
- user_group_remark — character
- insert_dt — timestamp
- insert_user_seq — integer
- update_dt — timestamp
- update_user_seq — integer
- user_group_status — character
t_user_group_permit
- idx — integer — NOT NULL
- user_group_seq — integer — NOT NULL
- permit_seq — integer — NOT NULL
- insert_dt — timestamp — NOT NULL
- insert_user_seq — integer — NOT NULL
- permit_menu_seq — integer
t_user_in_user_group
- user_group_seq — integer — NOT NULL
- user_seq — integer — NOT NULL
- insert_dt — timestamp
- insert_user_seq — integer
- idx — integer — NOT NULL
yj_b_emd_4326
- gid — integer — NOT NULL
- emd_cd — character
- emd_nm — character
- sgg_oid — integer
- col_adm_se — character
- __gid — integer
- geom — public.geometry(MultiPolygon,4326)