IDLE_REACT

NaviLogistics's ERD

Tables (18)

ADMIN

  • ID_INDEX — SERIAL — Primary key — 관리자_고유_인덱스_(Primary_Key)
  • ADMIN_ID — VARCHAR(255) — Primary key — NOT NULL — 관리자_로그인_ID_(고유)
  • ROLE — VARCHAR(255) — NOT NULL — 관리자_역할_(DEV_ADMIN
  • PASSWORD — VARCHAR(255) — NOT NULL — 관리자_비밀번호
  • NAME — VARCHAR(255) — 관리자_이름
  • EMPL_ID — VARCHAR(255) — 직원_ID
  • REG_DATE — TIMESTAMP — NOT NULL — 등록_일시
  • DEL_DATE — TIMESTAMP — 삭제_일시
  • IS_DEL — BOOLEAN — 삭제_여부

BUSINESS_LICENSE

  • id — BIGSERIAL — Primary key — 사업자_등록증_고유_ID_(Primary_Key)
  • BUSINESS_NUMBER — VARCHAR(255) — NOT NULL — 사업자_등록_번호
  • BUSINESS_NAME — VARCHAR(255) — 사업자명
  • START_DATE — TIMESTAMP — 사업_개시일
  • VERIFIED — BOOLEAN — 사업자_등록증_인증_여부
  • VERIFIED_AT — TIMESTAMP — 사업자_등록증_인증_일시

DRIVER_LICENSE

  • id — BIGSERIAL — Primary key — 운전면허증_고유_ID_(Primary_Key)
  • LICENSE_NUMBER — VARCHAR(255) — NOT NULL — 면허_번호
  • NAME_ON_LICENSE — VARCHAR(255) — 면허증_상_이름
  • ISSUE_DATE — DATE — 발급일
  • VERIFIED — BOOLEAN — 면허증_인증_여부
  • VERIFIED_AT — TIMESTAMP — 면허증_인증_일시
  • transport_auth_id — BIGINT — NOT NULL — 운송사_인증_ID_(CarOwnerAuthEntity_참조)

TRANSPORT_AUTH

  • id — BIGSERIAL — Primary key — 운송사_인증_고유_ID_(Primary_Key)
  • CAR_NUM — VARCHAR(255) — 차량_번호
  • ID_NUM — INTEGER — NOT NULL — 고객_고유_번호_(CustomerEntity_참조)
  • CAR_TYPE — VARCHAR(255) — NOT NULL — 차량_유형
  • CAR_INSURANCE_STATUS — BOOLEAN — NOT NULL — 차량_보험_가입_여부
  • GETORDER — BIGINT — 주문_수락_횟수
  • vehicle_id — BIGINT — 차량_정보_ID_(CarOwnerVehiclesEntity_참조)
  • business_license_id — BIGINT — NOT NULL — 사업자_등록증_ID_(BusinessLicenseEntity_참조)

car_owner_order

  • id — BIGSERIAL — Primary key — 차량_소유주_주문_목록_고유_ID_(Primary_Key)
  • owner_id — VARCHAR(50) — NOT NULL — 차량_소유주_ID
  • status — VARCHAR(20) — NOT NULL — 주문_상태_(READY
  • departure — VARCHAR(255) — NOT NULL — 출발지
  • arrival — VARCHAR(255) — NOT NULL — 도착지
  • cargo_type — VARCHAR(255) — NOT NULL — 화물_유형
  • cargo_size — VARCHAR(255) — 화물_크기
  • weight — VARCHAR(255) — 화물_무게
  • vehicle — VARCHAR(255) — 희망_차량
  • immediate — BOOLEAN — NOT NULL — 즉시_배차_여부
  • reserved_date — VARCHAR(255) — 예약_날짜
  • distance — VARCHAR(255) — 거리
  • vehicle_id — BIGINT — 배정된_차량_ID
  • proposed_price — INTEGER — 제안_가격
  • final_price — INTEGER — 최종_가격
  • created_at — TIMESTAMP — NOT NULL — 생성_일시
  • updated_at — TIMESTAMP — NOT NULL — 최종_수정_일시
  • version — BIGINT — 버전_(옵티미스틱_락)

car_owner_vehicle

  • id — BIGSERIAL — Primary key — 차량_소유주_차량_고유_ID_(Primary_Key)
  • owner_id — VARCHAR(50) — NOT NULL — 차량_소유주_ID
  • plate_number — VARCHAR(20) — NOT NULL — 차량_번호판_(소유주별_고유)
  • type — VARCHAR(30) — 차량_유형
  • model — VARCHAR(30) — 차량_모델
  • capacity — INTEGER — 적재_용량
  • is_primary — BOOLEAN — NOT NULL — 주력_차량_여부
  • status — VARCHAR(20) — 차량_상태_(ACTIVE/INACTIVE)
  • registered_at — TIMESTAMP — NOT NULL — 등록_일시

chat_sessions

  • id — BIGSERIAL — Primary key — 채팅_세션_고유_ID_(Primary_Key)
  • chat_room_id — VARCHAR(255) — NOT NULL — 채팅방_ID_(고유)
  • session_id — VARCHAR(255) — NOT NULL — 세션_ID_(고유)
  • created_at — TIMESTAMP — NOT NULL — 생성_일시
  • customer_id — INTEGER — 고객_ID_(CustomerEntity_참조

customer

  • ID_NUM — SERIAL — Primary key — 고객_고유_번호_(Primary_Key)
  • ID — VARCHAR(255) — NOT NULL — 고객_로그인_ID
  • PASSWORD_ENC — VARCHAR(255) — 암호화된_비밀번호
  • CUSTOM_NAME — VARCHAR(255) — 고객_실명
  • ROLE — VARCHAR(255) — 사용자_역할_(예:_USER
  • CREATED_AT — TIMESTAMP — NOT NULL — 계정_생성_일시
  • UPDATED_AT — TIMESTAMP — 계정_정보_최종_수정_일시
  • PHONE — VARCHAR(255) — NOT NULL — 전화번호
  • NICKNAME — VARCHAR(255) — NOT NULL — 닉네임
  • SNS_LOGIN_PROVIDER — VARCHAR(255) — SNS_로그인_제공자_(예:_KAKAO
  • SNS_PROVIDER_ID — VARCHAR(255) — SNS_제공자_고유_ID
  • LEFTED_AT — TIMESTAMP — 탈퇴_일시
  • IS_LEFTED — BOOLEAN — NOT NULL — 탈퇴_여부
  • USER_POINT — INTEGER — NOT NULL — 사용자_보유_포인트
  • REFRESH_TOKEN — VARCHAR(128) — 리프레시_토큰_(해시_권장)
  • RT_EXPIRES_AT — TIMESTAMP — 리프레시_토큰_만료_일시
  • AVATAR_URL — VARCHAR(200) — 아바타_이미지_URL
  • RESET_TOKEN_HASH — VARCHAR(64) — 비밀번호_재설정_토큰_해시_(고유)
  • RESET_EXPIRES_AT — TIMESTAMP — 비밀번호_재설정_토큰_만료_일시
  • RESET_USED — BOOLEAN — 비밀번호_재설정_토큰_사용_여부

driver_offers

  • id — BIGSERIAL — Primary key — 기사_제안_고유_ID_(Primary_Key)
  • order_id — BIGINT — NOT NULL — 주문_ID_(OrderEntity_참조)
  • driver_id_num — INTEGER — NOT NULL — 기사_고객_고유_번호_(CustomerEntity_참조)
  • price — BIGINT — NOT NULL — 입찰가
  • memo — VARCHAR(255) — 추가_메모
  • status — VARCHAR(20) — NOT NULL — 입찰_상태_(PENDING
  • created_at — TIMESTAMP — NOT NULL — 생성_일시
  • updated_at — TIMESTAMP — NOT NULL — 수정_일시

faqs

  • id — BIGSERIAL — Primary key — FAQ_고유_ID_(Primary_Key)
  • question — VARCHAR(255) — NOT NULL — 질문_내용
  • answer — TEXT — NOT NULL — 답변_내용
  • created_at — TIMESTAMP — NOT NULL — 생성_일시
  • updated_at — TIMESTAMP — NOT NULL — 최종_수정_일시
  • deleted_at — TIMESTAMP — 삭제_일시
  • is_del — BOOLEAN — NOT NULL — 삭제_여부
  • writer_admin_id — VARCHAR(255) — NOT NULL — 작성_관리자_ID
  • view_count — INTEGER — NOT NULL — 조회수

inquiry

  • inquiry_id — UUID — Primary key — 문의_고유_ID_(Primary_Key)
  • customer_id_num — BIGINT — NOT NULL — 고객_고유_번호
  • inquiry_title — VARCHAR(255) — NOT NULL — 문의_제목
  • inquiry_content — TEXT — NOT NULL — 문의_내용
  • inquiry_answer — TEXT — 문의_답변_내용
  • created_at — TIMESTAMP — NOT NULL — 생성_일시
  • answered_at — TIMESTAMP — 답변_일시
  • admin_id — VARCHAR(255) — 답변_관리자_ID
  • status — VARCHAR(50) — NOT NULL — 문의_상태_(INQUIRY_PENDING
  • re_inquiry_id — UUID — 재문의_ID_(원래_문의_참조)

notices

  • id — BIGSERIAL — Primary key — 공지사항_고유_ID_(Primary_Key)
  • content — TEXT — NOT NULL — 공지사항_내용
  • created_at — TIMESTAMP — NOT NULL — 생성_일시
  • deleted_at — TIMESTAMP — 삭제_일시
  • is_del — BOOLEAN — NOT NULL — 삭제_여부
  • title — VARCHAR(255) — NOT NULL — 공지사항_제목
  • updated_at — TIMESTAMP — NOT NULL — 최종_수정_일시
  • writer_admin_id — VARCHAR(255) — NOT NULL — 작성_관리자_ID
  • view_count — INTEGER — NOT NULL — 조회수

orders

  • id — BIGSERIAL — Primary key — 주문_고유_ID_(Primary_Key)
  • order_no — VARCHAR(32) — NOT NULL — 주문_번호_(고유)
  • proposed_price — INTEGER — 제안_가격
  • driver_price — BIGINT — 기사_가격
  • avg_price — BIGINT — 평균_가격
  • departure — VARCHAR(255) — 출발지
  • arrival — VARCHAR(255) — 도착지
  • distance — DOUBLE — 거리
  • reserved_date — VARCHAR(255) — 예약_날짜
  • is_immediate — BOOLEAN — 즉시_배차_여부
  • weight — VARCHAR(255) — 화물_무게
  • vehicle — VARCHAR(255) — 차량_종류
  • cargo_type — VARCHAR(255) — 화물_유형
  • cargo_size — VARCHAR(255) — 화물_크기
  • packing_option — VARCHAR(255) — 포장_옵션
  • status — VARCHAR(255) — NOT NULL — 주문_상태_(CREATED
  • assigned_driver_id — BIGINT — 배정된_기사_ID
  • shipper_id — VARCHAR(255) — 화주_ID
  • created_at — TIMESTAMP — 생성_일시
  • updated_at — TIMESTAMP — 최종_수정_일시
  • departed_at — TIMESTAMP — 출발_일시
  • completed_at — TIMESTAMP — 완료_일시

payments

  • id — BIGSERIAL — Primary key — 결제_고유_ID_(Primary_Key)
  • merchant_uid — VARCHAR(255) — 가맹점_주문_번호
  • item_name — VARCHAR(255) — 상품명
  • amount — BIGINT — 결제_금액
  • buyer_name — VARCHAR(255) — 구매자_이름
  • buyer_email — VARCHAR(255) — 구매자_이메일
  • payment_status — VARCHAR(255) — 결제_상태
  • requested_at — TIMESTAMP — 결제_요청_일시
  • paid_at — TIMESTAMP — 결제_완료_일시
  • cancelled_at — TIMESTAMP — 결제_취소_일시
  • imp_uid — VARCHAR(255) — 아임포트(IMP)_고유_ID
  • points_used — INTEGER — 사용된_포인트
  • pg_provider — VARCHAR(255) — PG사_(결제_대행사)
  • order_id — BIGINT — 주문_ID_(OrderEntity_참조)
  • customer_id — INTEGER — 고객_ID_(CustomerEntity_참조)

point_history

  • id — BIGSERIAL — Primary key — 포인트_내역_고유_ID_(Primary_Key)
  • customer_id_num — INTEGER — NOT NULL — 고객_고유_번호_(CustomerEntity_참조)
  • transaction_type — VARCHAR(255) — NOT NULL — 거래_유형_(예:_적립
  • amount — INTEGER — NOT NULL — 거래_금액
  • balance_after — INTEGER — NOT NULL — 거래_후_잔액
  • transaction_date — TIMESTAMP — NOT NULL — 거래_일시
  • description — VARCHAR(255) — 거래_설명

reviews

  • id — SERIAL — Primary key — 리뷰_고유_ID_(Primary_Key)
  • rating — INTEGER — NOT NULL — 평점_(1-5)
  • content — TEXT — 리뷰_내용
  • created_at — TIMESTAMP — NOT NULL — 생성_일시
  • author_id — INTEGER — NOT NULL — 리뷰_작성자_ID_(CustomerEntity_참조)
  • target_id — INTEGER — NOT NULL — 리뷰_대상_ID_(CustomerEntity_참조)
  • order_id — BIGINT — 주문_ID_(OrderEntity_참조)

settlement

  • id — BIGSERIAL — Primary key — 정산_항목_고유_ID_(Primary_Key)
  • batch_id — BIGINT — 정산_배치_ID_(CarOwnerSettlementBatchEntity_참조)
  • order_id — BIGINT — NOT NULL — 주문_ID_(OrderEntity_참조
  • owner_id — VARCHAR(255) — NOT NULL — 소유주_ID
  • amount — NUMERIC(18,2) — NOT NULL — 정산_금액_(주문에서_가져온_금액)
  • commission — NUMERIC(18,2) — NOT NULL — 플랫폼_수수료
  • status — VARCHAR(255) — NOT NULL — 정산_상태_(READY
  • requested_at — TIMESTAMP — 정산_요청_일시
  • approved_at — TIMESTAMP — 정산_승인_일시
  • paid_at — TIMESTAMP — 정산_지급_일시
  • month_key — DATE — NOT NULL — 월_집계_키_(주문_완료일_기준_그_달의_1일)
  • created_at — TIMESTAMP — NOT NULL — 생성_일시
  • updated_at — TIMESTAMP — NOT NULL — 최종_수정_일시

settlement_batch

  • id — BIGSERIAL — Primary key — 정산_배치_고유_ID_(Primary_Key)
  • owner_id — VARCHAR(255) — NOT NULL — 소유주_ID
  • month_key — DATE — NOT NULL — 정산_대상_월_(YYYY-MM-DD_형식)
  • status — VARCHAR(255) — NOT NULL — 정산_상태_(REQUESTED
  • requested_at — TIMESTAMP — NOT NULL — 정산_요청_일시
  • approved_at — TIMESTAMP — 정산_승인_일시
  • paid_at — TIMESTAMP — 정산_지급_일시
  • total_amount — NUMERIC(18,2) — NOT NULL — 총_정산_금액
  • item_count — INTEGER — NOT NULL — 정산_항목_수
  • bank_code — VARCHAR(10) — 은행_코드
  • bank_account_no — VARCHAR(64) — 은행_계좌_번호