dkERD

Tables (9)

Complaints (신고)

  • compl_id (신고ID) — int NOT NULL — Primary key — NOT NULL
  • user_id (의뢰자ID) — int NOT NULL — Foreign key → User.user_id — NOT NULL
  • driver_id (운전자ID) — int NOT NULL — Foreign key → Driver.driver_id — NOT NULL
  • reporter (신고자) — enum NOT NULL
  • c_title (신고제목) — varchar NOT NULL
  • c_content (신고내용) — varchar NOT NULL
  • c_status (신고상태) — enum NOT NULL
  • c_cate (신고 카테고리) — enum NOT NULL

Driver (운전자)

  • driver_id (운전자ID) — int NOT NULL — Primary key — NOT NULL
  • Field4

User (의뢰자)

  • user_id (의뢰자ID) — int NOT NULL — Primary key — NOT NULL
  • Field4

actual_calc (실계산)

  • ac_id (실계산ID) — int NOT NULL — Primary key — NOT NULL
  • ec_id (예상계산 ID) — int NOT NULL — Foreign key → expect_calc.ec_id — NOT NULL
  • distance (거리) — long NOT NULL
  • weight (무게) — long NOT NULL
  • mountainous (산간지역여부) — boolean NOT NULL
  • fragile (취급주의여부) — boolean NOT NULL
  • stopover1 (경유지1) — boolean
  • stopover2 (경유지2) — boolean
  • stopover3 (경유지3) — boolean
  • amount (총 금액) — int NOT NULL
  • status_id (상태로그ID)

complaints_pic (신고사진)

  • cp_id (신고사진 ID) — int NOT NULL — Primary key — NOT NULL
  • compl_id (신고ID) — int NOT NULL — Foreign key → Complaints.compl_id — NOT NULL
  • file_name (파일 이름) — varchar NOT NULL

expect_calc (예상계산)

  • ec_id (예상계산 ID) — int NOT NULL — Primary key — NOT NULL

history (이용기록)

  • history_id (이용기록ID) — int NOT NULL — Primary key — NOT NULL
  • driver_id (운전자ID) — int NOT NULL — Foreign key → Driver.driver_id — NOT NULL
  • pay_id (결제 ID) — int NOT NULL — Foreign key → payment.pay_id — NOT NULL
  • ac_id (실계산ID) — int NOT NULL — Foreign key → actual_calc.ac_id — NOT NULL
  • depart_loc (출발지) — varchar NOT NULL
  • arrival_loc (도착지) — varchar NOT NULL

payment (결제)

  • pay_id (결제 ID) — int NOT NULL — Primary key — NOT NULL
  • user_id (의뢰자ID) — int NOT NULL — Foreign key → User.user_id — NOT NULL
  • prepaid_id (사전결제 ID) — int — Foreign key → payment.pay_id — NOT NULL
  • pay_method (결제방법) — varchar NOT NULL
  • pay_amount (결제금액) — int NOT NULL
  • pay_status (결제상태) — enum NOT NULL
  • paid (결제완료일시) — date
  • settlement (정산여부) — boolean NOT NULL
  • refund_date (환불일자) — enum
  • failure (결제실패사유) — enum

review (리뷰)

  • review_id (리뷰 ID) — int NOT NULL — Primary key — NOT NULL
  • history_id (이용기록ID) — int NOT NULL — Foreign key → history.history_id — NOT NULL
  • rating (평점) — int not null
  • reason (사유) — varchar
  • state (상태) — enum not null