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) — 은행_계좌_번호