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