테스트

테이블 (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