hailing

Tables (12)

Balance (정산)

  • Driver_ID (드라이버아이디)
  • Balance (정산금액)

Call (운행요청(콜))

  • Call_ID (운행요청아이디) — Primary key — NOT NULL
  • Product_ID (상품아이디) — Foreign key → Product.Product_ID
  • User_ID (유저아이디) — Foreign key → User.User_ID — NOT NULL
  • Start_Lat (출발지위도)
  • Start_Long (출발지경도)
  • Start_Address (출발지주소)
  • End_Lat (도착지위도)
  • End_Long (도착지경도)
  • End_Address (도착지주소)
  • User_ID (요청유저아이디)
  • Driver_ID (수락기사아이디)
  • Req_Date (요청시간)
  • Field (완료상태)
  • Complete_Date (완료시간)
  • Review_ID (리뷰아이디) — Foreign key → CallReview.Review_ID
  • Field (결제정보)
  • Field (결제상태)
  • Req_Lat (요청지위도)
  • Req_Long (요청지경도)
  • Ride_Lat (탑승지위도)
  • Ride_Long (탑승지경도)
  • Update_Date (요청정보 갱신시간)

CallExpose (요청노출(드라이버에게))

  • Call_ID (운행요청아이디) — Foreign key → Call.Call_ID — NOT NULL
  • Product_ID (상품아이디) — Foreign key → Call.Product_ID
  • User_ID (유저아이디) — Foreign key → Call.User_ID — NOT NULL
  • Expose_Date (노출일시)
  • Driver_ID (대상드라이버)
  • Location (노출지역)
  • State (상태)

CallReview (운행리뷰)

  • Review_ID (리뷰아이디) — Primary key
  • Rate (리뷰점수)
  • Content (리뷰내용)
  • Call_ID (운행요청아이디)

Car (차량)

  • Car_ID (차량아이디) — Primary key — NOT NULL
  • Type (차량종류)

CarAssign (배차)

  • Driver_ID (드라이버아이디) — Foreign key → Driver.Driver_ID — NOT NULL
  • Car_ID (차량아이디) — Foreign key → Car.Car_ID — NOT NULL
  • Start_Date (배차시작일시)
  • End_Date (배차종료일시)

CarTrack (차량운행)

  • Car_ID (차량아이디) — Foreign key → Car.Car_ID — NOT NULL
  • Driver_ID (드라이버아이디) — Foreign key → Driver.Driver_ID — NOT NULL
  • Latitude (위도)
  • Logitude (경도)
  • Speed (속도)
  • Date (기록시간)
  • Status (운행상태)
  • Call_ID (운행요청아이디) — Foreign key → Call.Call_ID — NOT NULL
  • Product_ID (상품아이디) — Foreign key → Call.Product_ID
  • User_ID (ID) — Foreign key → Call.User_ID — NOT NULL

Driver (드라이버)

  • Driver_ID (드라이버아이디) — Primary key — NOT NULL
  • Name (드라이버이름)

Payment (결제정보)

  • User_ID (유저아이디)
  • Cash (결제금액)
  • Status (결제상태)

Product (상품)

  • Product_ID (상품아이디) — Primary key
  • Name (상품명)

SearchHistory (검색기록)

  • User_ID (유저아이디) — Foreign key → User.User_ID — NOT NULL
  • Field

User (유저)

  • User_ID (유저아이디) — Primary key — NOT NULL
  • Name (이름)
  • PhoneNumber (전화번호)
  • PayInfo (결제정보)
  • Class (유저등급)