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 — 수정일시