dd

Tables (29)

admin_division

  • cd — varchar(10) — Primary key — NOT NULL — 법정동코드 (10자리)
  • full_nm — varchar(200) — NOT NULL — 전체명
  • sido_nm — varchar(50) — NOT NULL — 시도명
  • sigungu_nm — varchar(100) — 시군구명
  • emd_nm — varchar(100) — 읍면동명
  • ri_nm — varchar(100) — 리명
  • level — int2 — NOT NULL — 단계 (1=시도,2=시군구,3=읍면동,4=리)
  • parent_code — varchar(10) — 상위코드
  • status — varchar(20) — NOT NULL — 상태
  • created_at — timestamp — 생성일시

admin_member

  • admin_id — bigserial — Primary key — NOT NULL — 관리자ID
  • login_id — varchar(50) — NOT NULL — 로그인ID
  • password — varchar(255) — NOT NULL — 비밀번호
  • name — varchar(50) — NOT NULL — 이름
  • phone — varchar(20) — 연락처
  • role_id — int8 — Foreign key → role.role_id — 권한ID
  • admin_status — varchar(20) — 관리자상태
  • created_at — timestamp — 생성일시
  • updated_at — timestamp — 수정일시

area

  • area_id — bigserial — Primary key — NOT NULL — 권역ID
  • area_name — varchar(100) — NOT NULL — 권역명
  • area_status — varchar(20) — 권역상태
  • created_at — timestamp — 생성일시
  • updated_at — timestamp — 수정일시

attachment

  • attachment_id — bigserial — Primary key — NOT NULL — 첨부파일ID
  • ref_type — varchar(50) — NOT NULL — 참조타입
  • ref_id — int8 — NOT NULL — 참조ID
  • file_name — varchar(255) — NOT NULL — 파일명
  • file_path — varchar(500) — NOT NULL — 파일경로
  • file_size — int8 — 파일크기
  • content_type — varchar(100) — 컨텐츠타입
  • created_at — timestamp — 생성일시

code

  • code_id — bigserial — Primary key — NOT NULL — 코드ID
  • group_code — varchar(50) — NOT NULL — 그룹코드
  • code — varchar(50) — NOT NULL — 코드
  • code_name — varchar(100) — NOT NULL — 코드명
  • sort_order — int4 — 정렬순서
  • code_status — varchar(20) — 코드상태

dispatch

  • dispatch_id — bigserial — Primary key — NOT NULL — 배차ID
  • dispatch_plan_id — int8 — Foreign key → dispatch_plan.dispatch_plan_id — 배차계획ID
  • vehicle_id — int8 — Foreign key → vehicle.vehicle_id — NOT NULL — 차량ID
  • rcd_id — int8 — Foreign key → operation_rcd.rcd_id — 운행일지ID
  • driver_id — int8 — Foreign key → driver.driver_id — 기사ID
  • route_id — int8 — Foreign key → route.route_id — 노선ID
  • route_name — varchar(100) — 노선명
  • dispatched_at — timestamp — 배차일시
  • accepted_at — timestamp — 수락일시
  • accepted_yn — varchar(1) — 수락여부
  • reservation_deadline_time — timestamp — NOT NULL — 예약마감시간
  • dispatch_status — varchar(20) — 운행상태
  • created_at — timestamp — 생성일시

dispatch_history

  • history_id — bigserial — Primary key — NOT NULL — 이력ID
  • dispatch_id — int8 — 배차ID
  • dispatch_plan_id — int8 — 배차계획ID
  • action_type — varchar(30) — NOT NULL — 작업유형
  • prev_vehicle_id — int8 — 이전차량ID
  • new_vehicle_id — int8 — 변경후차량ID
  • reason — varchar(500) — NOT NULL — 변경/삭제 사유
  • modified_by — int8 — 작업자ID
  • modified_by_name — varchar(100) — 작업자명
  • modified_at — timestamp — 작업일시
  • deleted_count — int4 — 삭제건수
  • delete_condition — text — 삭제조건(JSON)
  • prev_driver_id — int8 — 이전기사ID
  • new_driver_id — int8 — 변경후기사ID
  • dispatch_ids — text — 배차ID목록

dispatch_plan

  • dispatch_plan_id — bigserial — Primary key — NOT NULL — 배차계획ID
  • route_id — int8 — Foreign key → route.route_id — NOT NULL — 노선ID
  • route_name — varchar(100) — NOT NULL — 노선명
  • vehicle_id — int8 — Foreign key → vehicle.vehicle_id — 차량ID
  • start_date — date — NOT NULL — 시작일
  • end_date — date — NOT NULL — 종료일
  • start_time — time — NOT NULL — 운행시작시간
  • end_time — time — NOT NULL — 운행종료시간
  • dispatch_interval — int4 — NOT NULL — 배차간격(분)
  • reservation_deadline — int4 — NOT NULL — 예약마감기준
  • operation_days — varchar(20) — NOT NULL — 한글운행요일
  • include_holidays — bool — NOT NULL — 공휴일포함여부
  • dispatch_plan_status — varchar(20) — 배차계획상태
  • created_at — timestamp — 생성일시
  • updated_at — timestamp — 수정일시
  • route_type — varchar(20) — 노선유형

driver

  • driver_id — bigserial — Primary key — NOT NULL — 기사ID
  • name — varchar(50) — NOT NULL — 이름
  • phone — varchar(20) — 연락처
  • driver_status — varchar(20) — 기사상태
  • created_at — timestamp — 생성일시
  • updated_at — timestamp — 수정일시

holiday

  • holiday_id — bigserial — Primary key — NOT NULL — 공휴일ID
  • holiday_date — date — NOT NULL — 휴일
  • holiday_nm — varchar(100) — NOT NULL — 휴일이름
  • created_at — timestamp — 생성일시

inquiry

  • inquiry_id — bigserial — Primary key — NOT NULL — 문의ID
  • member_id — int8 — Foreign key → member.member_id — 사용자ID
  • title — varchar(200) — NOT NULL — 제목
  • content — text — 내용
  • answer — text — 답변
  • inquiry_status — varchar(20) — 문의상태
  • created_at — timestamp — 생성일시
  • answered_at — timestamp — 답변일시

link

  • link_id — bigserial — Primary key — NOT NULL — 링크ID
  • f_node_id — int8 — Foreign key → node.node_id — NOT NULL — 기점노드ID
  • t_node_id — int8 — Foreign key → node.node_id — NOT NULL — 종점노드ID
  • link_type — int4 — NOT NULL — 도로유형(KTDB코드)
  • length — float8 — 실거리(km)
  • lane — int4 — 편도차로수
  • speed — float8 — 속도
  • capacity — int4 — 용량
  • cost — float8 — 비용
  • reverse_cost — float8 — 역방향통행비용(분)
  • geom — public.geometry(linestring, 4326) — 형상정보
  • area_id — int8 — Foreign key → area.area_id — 권역ID
  • use_flag — int4 — NOT NULL — 사용여부
  • description — varchar(500) — 비고
  • created_at — timestamp — 생성일시
  • updated_at — timestamp — 수정일시

member

  • member_id — bigserial — Primary key — NOT NULL — 사용자ID
  • phone — varchar(20) — NOT NULL — 연락처
  • name — varchar(50) — 이름
  • device_token — varchar(255) — 디바이스토큰
  • member_status — varchar(20) — 회원상태
  • created_at — timestamp — 생성일시
  • updated_at — timestamp — 수정일시

menu

  • menu_id — bigserial — Primary key — NOT NULL — 메뉴ID
  • menu_name — varchar(100) — NOT NULL — 메뉴명
  • menu_url — varchar(255) — 메뉴URL
  • parent_id — int8 — Foreign key → menu.menu_id — 상위메뉴ID
  • sort_order — int4 — 정렬순서
  • menu_status — varchar(20) — 메뉴상태
  • icon — varchar(50) — 아이콘

node

  • node_id — bigserial — Primary key — NOT NULL — 노드ID
  • node_type — int4 — NOT NULL — 노드구분(0=일반,1=교차로,2=정류장연결)
  • latitude — numeric(10, 7) — NOT NULL — 위도
  • longitude — numeric(10, 7) — NOT NULL — 경도
  • geom — public.geometry(point, 4326) — 형상정보
  • zone_id — int4 — 존번호(KTDB호환)
  • area_id — int8 — Foreign key → area.area_id — 권역ID
  • use_flag — int4 — NOT NULL — 사용여부
  • description — varchar(500) — 비고
  • created_at — timestamp — 생성일시
  • updated_at — timestamp — 수정일시
  • u_turn_allowed — bool — NOT NULL — 유턴허용여부

notice

  • notice_id — bigserial — Primary key — NOT NULL — 공지사항ID
  • title — varchar(200) — NOT NULL — 제목
  • content — text — 내용
  • start_date — date — 시작일
  • end_date — date — 종료일
  • admin_id — int8 — 관리자ID
  • created_at — timestamp — 생성일시
  • updated_at — timestamp — 수정일시

notification

  • notification_id — bigserial — Primary key — NOT NULL — 알림ID
  • target_type — varchar(20) — 대상유형
  • target_id — int8 — 대상ID
  • title — varchar(200) — 제목
  • message — text — 메시지
  • is_read — bpchar(1) — 읽음여부
  • created_at — timestamp — 생성일시

operation_detail

  • detail_id — bigserial — Primary key — NOT NULL — 상세ID
  • dispatch_id — int8 — Foreign key → dispatch.dispatch_id — NOT NULL — 배차ID
  • station_id — int8 — Foreign key → station.station_id — 정류장ID
  • seq — int4 — 정류장순번
  • expc_arrivaled_at — timestamp — 예상도착시간
  • arrived_at — timestamp — 도착일시
  • up_count — int4 — 승차인원
  • down_count — int4 — 하차인원

operation_rcd

  • rcd_id — bigserial — Primary key — NOT NULL — 운영일지ID
  • dispatch_id — int8 — Foreign key → dispatch.dispatch_id — NOT NULL — 배차ID
  • vehicle_id — int8 — Foreign key → vehicle.vehicle_id — NOT NULL — 차량ID
  • driver_id — int8 — Foreign key → driver.driver_id — NOT NULL — 기사ID
  • route_id — int8 — Foreign key → route.route_id — 노선ID
  • operation_date — date — NOT NULL — 운행일자
  • operation_year — int4 — 운행년도
  • operation_month — int4 — 운행월
  • operation_day — int4 — 운행일
  • operation_dow — int4 — 운행요일(1:월~7:일)
  • started_at — timestamp — 운행시작일시
  • completed_at — timestamp — 운행종료일시
  • total_distance — numeric(10, 1) — 총운행거리
  • passenger_count — int4 — 승객수
  • status — varchar(20) — 상태
  • vehicle_location — text — 운행차량위치정보(JSON)
  • tagging_info — text — 카드태깅정보
  • created_at — timestamp — 생성일시

reservation

  • reservation_id — bigserial — Primary key — NOT NULL — 예약ID
  • member_id — int8 — Foreign key → member.member_id — 사용자ID
  • dispatch_id — int8 — Foreign key → dispatch.dispatch_id — NOT NULL — 배차ID
  • boarding_station_id — int8 — Foreign key → station.station_id — 승차정류장ID
  • alighting_station_id — int8 — Foreign key → station.station_id — 하차정류장ID
  • reservation_time — timestamp — NOT NULL — 예약시간
  • passenger_count — int4 — 승객수
  • reservation_status — varchar(20) — 예약상태
  • created_at — timestamp — 생성일시
  • canceled_at — timestamp — 취소일시

role

  • role_id — bigserial — Primary key — NOT NULL — 권한ID
  • role_name — varchar(50) — NOT NULL — 권한명
  • description — varchar(500) — 비고
  • role_status — varchar(20) — 권한상태

role_menu

  • role_menu_id — bigserial — Primary key — NOT NULL — 권한메뉴ID
  • role_id — int8 — Foreign key → role.role_id — 권한ID
  • menu_id — int8 — Foreign key → menu.menu_id — 메뉴ID
  • read_yn — bpchar(1) — 읽기권한
  • write_yn — bpchar(1) — 쓰기권한
  • delete_yn — bpchar(1) — 삭제권한

route

  • route_id — bigserial — Primary key — NOT NULL — 노선ID
  • route_name — varchar(100) — 노선명
  • route_type — varchar(20) — 노선유형
  • description — varchar(500) — 비고
  • use_flag — int4 — 사용여부
  • created_at — timestamp — 생성일시
  • area_id — int8 — Foreign key → area.area_id — 권역ID

route_path

  • seq — int4 — Primary key — NOT NULL — 정류장순번
  • route_id — int8 — Foreign key → route.route_id — NOT NULL — 노선ID
  • station_id — int8 — Foreign key → station.station_id — NOT NULL — 정류장ID
  • geom — public.geometry — 형상정보
  • cost — float8 — 비용
  • created_at — timestamp — 생성일시

station

  • station_id — bigserial — Primary key — NOT NULL — 정류장ID
  • station_name — varchar(100) — NOT NULL — 정류장명
  • latitude — numeric(10, 7) — NOT NULL — 위도
  • longitude — numeric(10, 7) — NOT NULL — 경도
  • area_id — int8 — Foreign key → area.area_id — NOT NULL — 권역ID
  • station_status — varchar(20) — 정류장 사용 상태
  • division_code — varchar(10) — Foreign key → admin_division.cd — 법정동코드
  • created_at — timestamp — 생성일시
  • updated_at — timestamp — 수정일시
  • nearest_node_id — int8 — Foreign key → node.node_id — 매칭노드ID

statistics_daily

  • statistics_daily_id — bigserial — Primary key — NOT NULL — 일별통계ID
  • stat_date — date — NOT NULL — 통계일자
  • vehicle_id — int8 — Foreign key → vehicle.vehicle_id — 차량ID
  • total_distance — numeric(10, 2) — 총운행거리
  • total_calls — int4 — 총호출건수
  • total_passengers — int4 — 총승객수

terms_info

  • terms_id — int4 — Primary key — NOT NULL — 약관ID
  • terms_ver — int4 — Primary key — NOT NULL — 약관버전
  • terms_nm — varchar(255) — NOT NULL — 약관명
  • terms_contents — text — 약관내용
  • ess_flag — varchar(1) — NOT NULL — 필수여부
  • roles — varchar(255) — NOT NULL — 대상역할
  • use_flag — int4 — NOT NULL — 사용여부

vehicle

  • vehicle_id — bigserial — Primary key — NOT NULL — 차량ID
  • vehicle_no — varchar(20) — NOT NULL — 차량번호
  • vehicle_type — varchar(50) — 차량유형
  • capacity — int4 — 용량
  • vehicle_status — varchar(20) — 차량상태
  • total_distance — numeric(10) — 총운행거리
  • created_at — timestamp — 생성일시
  • updated_at — timestamp — 수정일시

vrp_config

  • config_id — bigserial — Primary key — NOT NULL — 설정ID
  • config_key — varchar(50) — NOT NULL — 설정키
  • config_value — varchar(200) — NOT NULL — 설정값
  • description — varchar(500) — 비고
  • updated_at — timestamp — 수정일시