테스트
테이블 (11)
IMG
- IMG_NO — NUMBER — 기본 키 — NOT NULL
- ORDER_NO — NUMBER — 외래 키 → ORDER.ORDER_NO — NOT NULL
- ORIGIN_NAME — STRING — NOT NULL
- CHANGE_NAME — STRING — NOT NULL
Inq_Category
- CATEGORY_ID — NUMBER — 기본 키 — NOT NULL
- CATEGORY_NAME — VARCHAR2(55)
Inquiries
- INQUIRY_ID — NUMBER — 기본 키 — NOT NULL
- USER_ID — bigint(20) — 외래 키 → Users.USER_ID — NOT NULL
- CATEGORY_ID — NUMBER — 외래 키 → Inq_Category.CATEGORY_ID — NOT NULL
- MEMBER_ID — NUMBER
- TITLE — VARCHAR2(110)
- CONTENT — VARCHAR2(110)
- CREATE_DATE — DATE
- UPDATE_DATE — DATE
InquiryResponse
- RESPONSE_ID — NUMBER — 기본 키 — NOT NULL
- INQUIRY_ID — NUMBER — 외래 키 → Inquiries.INQUIRY_ID — NOT NULL
- RESPONSE_CONTENT — LONG
- CREATE_DATE — TIMESTAMP
InquiryStatuses
- STATUS_NAME — VARCHAR2(55)
- RESPONSE_ID — NUMBER — 외래 키 → InquiryResponse.RESPONSE_ID — NOT NULL
ORDER
- ORDER_NO — NUMBER — 기본 키 — NOT NULL
- USER_ID — BIGINT(20) — 외래 키 → Users.USER_ID
- ORDER_TITLE — LONG — NOT NULL
- ORDER_CONTENT — LONG — NOT NULL
- CATEGORY_MAIN — VARCHAR2(60) — NOT NULL
- CATEGORY_DETAIL — VARCHAR2(60) — NOT NULL
- ALERT_FRAGILE — CHAR(1) — NOT NULL
- ALERT_VALUABLE — CHAR(1) — NOT NULL
- ALERT_URENT — CHAR(1) — NOT NULL
- START_POINT — VARCHAR2(110) — NOT NULL
- END_POINT — VARCHAR2(110) — NOT NULL
- CREATE_DATE — TIMESTAMP
- ORDER_STATUS — VARCHAR2(60) — NOT NULL
- START_DATE — TIMESTAMP — NOT NULL
- DISTANCE — NUMBER — NOT NULL
- PRICE — NUMBER — NOT NULL
- END_DATE — TIMESTAMP — NOT NULL
ORSER_DETAIL
- RIDER_ID — BIGINT(20) — 외래 키 → Rider.RIDER_ID — NOT NULL
- ORDER_NO — NEMBER — 외래 키 → ORDER.ORDER_NO — NOT NULL
REVIEW
- RIDER_ID — BIGINT(20) — 외래 키 → ORSER_DETAIL.RIDER_ID — NOT NULL
- ORDER_NO — NUMBER — 외래 키 → ORSER_DETAIL.ORDER_NO — NOT NULL
- REVIEW_CONTENT — LONG
- CREATE_DATE — DATE
- RATING — NUMBER — NOT NULL
- Field — VARCHAR(255)
Rider
- RIDER_ID — BIGINT(20) — 기본 키 — NOT NULL
- USER_ID — BIGINT(20) — 외래 키 → Users.USER_ID — NOT NULL
- VEHICLE — VARCHAR(200)
Users
- USER_ID — BIGINT(20) — 기본 키 — NOT NULL
- EMAIL — VARCHAR(100) — 유니크
- PASSWORD — BIGINT(255) — NOT NULL
- NAME — VARCHAR(100) — NOT NULL
- NICKNAME — VARCHAR(100) — NOT NULL
- BIRTH — VARCHAR(11) — NOT NULL
- GENDER — VARCHAR(10) — NOT NULL
- PHONE — VARCHAR(11) — NOT NULL — 고마운분
- ADDRESS — VARCHAR(255) — NOT NULL
- CREATE_DATE — TIMESTAMP
- ROLE — VARCHAR(100) — NOT NULL — 일반
- PROFILE_IMAGE — VARCHAR(255)
- STATUS — VARCHAR(10)
- UPDATE_DATE — TIMESTAMP
Vehicles
- RIDER_ID — BIGINT(20) — 외래 키 → Rider.RIDER_ID — NOT NULL
- VEHICLE — VARCHAR2(55)
- MAX_DISTANCE — NUMBER