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 (유저등급)