카링

테이블 (12)

ATTACHEDFILE_ID

  • ATTACHEDFILE_ID — number — 기본 키 — NOT NULL
  • CARINFO_ID — NUMBER
  • ORIGINAL_FILENAME — VARCHAR2(500 BYTE)
  • SAVED_FILENAME — VARCHAR2(500 BYTE)
  • FILE_SIZE — NUMBER

board

  • board_id — number — 기본 키 — NOT NULL
  • carInfo_id — number — 외래 키 → carInfo.carInfo_id — NOT NULL
  • host_email — varchar2(20) — 외래 키 → host.host_email — NOT NULL
  • title — varchar2(20)
  • contents — varchar2(4000) — NOT NULL
  • created_time — date
  • price — number — NOT NULL
  • area — varchar2(20) — NOT NULL
  • rent_start
  • rent_end — number
  • LAT
  • LNG

brand

  • brand_id — number — 기본 키 — NOT NULL
  • brand_name — varchar2(20)

carInfo

  • carInfo_id — number — 기본 키 — NOT NULL
  • car_year — number — NOT NULL
  • seat — number — NOT NULL
  • host_email (host_email2) — varchar2(20) — 외래 키 → host.host_email — NOT NULL
  • fuel_id (Key) — number — 외래 키 → fuel.fuel_id — NOT NULL
  • brand_id — number — 외래 키 → brand.brand_id — NOT NULL
  • ATTACHEDFILE_ID — number — 외래 키 → ATTACHEDFILE_ID.ATTACHEDFILE_ID — NOT NULL
  • carType_id (carType_id2) — number — 외래 키 → carType.carType_id — NOT NULL
  • optionList_id — number — 외래 키 → optionList.optionList_id — NOT NULL

carType

  • carType_id — number — 기본 키 — NOT NULL
  • carType_name — varchar2(20)

feature

  • feature_id (Key) — number — 기본 키 — NOT NULL
  • feature_name — varchar2(40) — NOT NULL

fuel

  • fuel_id (Key) — number — 기본 키 — NOT NULL
  • fuel_name — varchar2(20) — NOT NULL

host

  • host_email — varchar2(20) — 기본 키 — NOT NULL
  • host_password — varchar2(20) — NOT NULL
  • host_name — varchar2(20) — NOT NULL
  • host_phone — varchar2(20) — NOT NULL
  • host_img

optionList

  • optionList_id — number — 기본 키 — NOT NULL
  • carInfo_id — number
  • option_value — varchar2(100)
  • feature_id (Key) — number — 외래 키 → feature.feature_id — NOT NULL

reservation

  • reservation_id — number — 기본 키 — NOT NULL
  • board_id — number — 외래 키 → board.board_id — NOT NULL
  • carInfo_id (carInfo_id2) — number — 외래 키 → board.carInfo_id — NOT NULL
  • host_email — varchar2(20) — 외래 키 → board.host_email — NOT NULL
  • reservation_date — date — NOT NULL
  • total_price — number — NOT NULL
  • rent_start — number — NOT NULL
  • rent_end — number — NOT NULL
  • status — varchar2(20)
  • customer_email (customer_email2) — varchar2(20) — 외래 키 → user.customer_email — NOT NULL

review

  • review_id — number — 기본 키 — NOT NULL
  • created_time — date
  • rate — number — NOT NULL
  • contents — varchar2(4000) — NOT NULL
  • reservation_id (reservation_id2) — number — 외래 키 → reservation.reservation_id — NOT NULL
  • carInfo_id — number — 외래 키 — NOT NULL
  • board_id — number — 외래 키 → reservation.board_id — NOT NULL
  • carInfo_id (carInfo_id2) — number — 외래 키 → reservation.carInfo_id — NOT NULL
  • host_email — varchar2(20) — 외래 키 → reservation.host_email — NOT NULL

user

  • customer_email — varchar2(20) — 기본 키 — NOT NULL
  • customer_password — varchar2(20) — NOT NULL
  • customer_name — varchar2(20) — NOT NULL
  • customer_address — varchar2(200) — NOT NULL
  • customer_phone — varchar2(20) — NOT NULL
  • license — varchar2(20) — NOT NULL
  • CUSTOMER_IMG — VARCHAR2(100 BYTE)