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)